Sales Voucher Import Using Excel

Dear Sir,

Thank you for your support but it is giving error like attached file.


Earlier it was giving error like this thats why i have inserted All Ledger Entries object

 

Hi NaraSimhulu Devalam,
My problem is very similar to Maulik Patel. multiple line, multiple stock items with multiple locations and cost centres. I tried using this txt file but popped up with error "FUNCTION: 'MLK Insert Voucher' LABEL: 228 : Action execution failed!" . May be my excel template not correct or so. Can you send your excel template for this module so that I can define it for my module.
Thanks in advance. vijay

 

in excel can we repeat rows for multiple items?
what about other columns? do we need to repeat while preparing excel data sheet for import?

Name of the Item Batch Num QTY Rate
T7110/1LB 0 1 5250

 

yes, you can repeat n numbers of rows for items in for a voucher. And you have to repeat other cloumns as well to run the code smothly (Unless you have specifically mentioned not repeat for other columns)

 

Hi,

I was using the original code I posted until now but certainly started facing problem when I updated my Tally. Now when I try to import the Sales/Receipts it says "Invalid Number of Steps". I checked my XLS File and it has some valid entries. Also, when I remove the code for "Progress Bar" from my TDL file then it works fine and import all the entries without any notifications.

Could anyone please help me rectify this error? I also started a new thread regarding this problem but no luck so far.

Regards,
Raj

 

this issue may be because of the versions of Tally and Excel would not matching. Make sure you are using same version of both. Means the Tally & Excel should be either 64bit or 32bit....if you are using 64bit tally and excel is 32bit then it will not work.

 

Hello Aaradhya,

Thanks for your reply. I am on a x64 OS (Windows 7) and using x64 Versions of both the Applications i.e. MS Office and Tally. Tally seems to do everything correctly if I remove the "Progress Bar" but then it doesn't prompt anything in case of Duplicate Entries etc.

I am again attaching the files which I was using before...

Is there any other fix?

Thank You

Regards,
Raj

 

Try the attached

 

Hello Aaradhya,

Thank you very much for your reply. I tried it but it's giving me the same problem again. I even tried installing X32 Version but no luck. I have no clue why it is not working.

Just out of curiosity which version and built of Tally you are using? And does it works fine for you?

Thank You

Regards,
Raj

 

Hi Kailash, this updated code is running smoothly at my end. I am using 32bit Tally & Excel while running the same. You must have not amended the voucher number to Manual and Unique number to YES. Amend these both the things for Sales vch and try. Hope it would work for you as well.

 

assesable value in showing is minus ?

see attach ..

 

Oh common Laxman you can do it with yourself!!! Just try it, if not able to do it then let me know.

 

Dear Laxman,

I found in mostly of your thread that you are finding some mistakes in other developer's coding. Do not break moral of other experts by findig their mistakes specialy for those who are trying to help others. Here I want to tell you somthing which I have seen somewhere "First think how much of it you can do then try to find someone's mistake."

 

Superb explanation....

 

Hi Aaradhya,

Thanks for your reply. I tried changing the connection string and also appended ';' to my file name and now it seems to work fine. I don't even know what was the problem but it seems resolved now. Although there is one more small problem that I am facing. My VAT Computation report seems to be fine but when I export the VAT Form 8A for my e-VAT Return then the Voucher Amount comes incorrect. Every time I export that report I need to correct the Voucher Amount manually. Is there a problem with Cr/Dr in my code here? I tried it with hit and trial and don't even know when to put *(-1) in the above code. Seeing your expertise I hope you'll be able to help me out with this.

Thanks Again

Regards,
Raj

 

Hi Raj, please try your self first. As Laxman also said the assessable amount is in minus that you have make it in Positive. *(-1) is used for that.

 

Hi Raj, please try your self first. As Laxman also said the assessable amount is in minus that you have make it in Positive. *(-1) is used for that.

 

Hi Aaradhya,

Thanks for your reply. I tried doing some changes and now the VAT Assessable Value is coming as positive but no luck with the 8A Form.
I'm attaching the modified code and problem I am facing with 8A.

Thank You

Regards,
Raj

 

Dear Experts,

I have a tdl to import Sales Stock data from excel, taken some of ideas from Maulikbhai TDL, but could not complete as there is lack of few issues like:

* It does not check whether item exist or not?
* total of Dr & Cr does not tally?
* As i have used Actual & Billed Qty, in voucher it show only one column?
* how to retrieve Party Ledger Address, of that particular ledger?

This are few issue i am facing rest any more update on this TDL is welcome.

 

EXPERTS,

Please help me out, or at least guide how to go about it.

As anybody ask for code, experts say we will guide you so i have posted. Atleast you write code.

thanks

 

at the very first i am very sorry that you could not get any help.

i was not active all these days because of audit.Till septomber it will continue

1)It does not check whether item exist or not?
Code is missing
2) total of Dr & Cr does not tally?
please check some of samples I have posted. It will help you
3) As i have used Actual & Billed Qty, in voucher it show only one column?
have you enabled Actual & Billed Qty in tally
4) how to retrieve Party Ledger Address, of that particular ledger?
$address:ledger: nameofledger
please note here name means the variable/method/field that contains ledger name of which address is required.if you need all address in one field you need to use $$fulllist function

 

Dear Joharfchhil,

Share your excel template as well to have clear picture...

 

I have customized according to my needs, in stock item master i select ledger account for tax classification, rest tdl does it.

 

Jobimon sir, sorry not needed as all are busy with their work and schedule. thanks a lot.

 

how to resolve this error :

FUNCTION: 'ImportSVC' LABEL: 95 : Voucher totals
do not match!