Sales Voucher Import Using Excel

Hi Experts,

Using the various TDLs found on this wonderful website I managed to create my own TDL for Importing Sales Voucher from the given Excel File.

The only problem I am facing is if the VAT Amount in the Excel File = 0 then all my entries get imported successfully but if I enter the VAT against the Voucher Amount it gives me an error message saying that "There is Voucher Amount Mismatch!". Apparently it says Credit Amount does not equals the Debit Amount and also displays the Difference Amount (Credit - Debit).

Also, the entries are appearing twice!

I have No Clue on what goes wrong! Could anybody fix this please?

Thank You

Regards,
Kailash

 

Not working sir

 

I made that work by explicitly providing the Total Voucher Amount in the Excel File and then referring it through the Variable. The only problem now is of Double Entry. Each entry is appearing twice! Any clue?

 

Problem of Double Entry & Vat Class .

 

Hi Laxman, I solved the problem of Double Entry and as far as the VAT Class is concerned we can solve that also by Explicitly Accepting the VAT Class in the Excel File.

 

Mr.Kailash Double Entry is not working share code again....

 

Hi Laxman,

Put the .xls file in D: Drive or change the path in the Text File accordingly. Also change your ledger names in TO and VAT entry accordingly. For me it is "Sales @ 14%" and "Output VAT @ 14%" respectively. Also, if you Sales Voucher name is different then kindly change that too in the given Text File.

This code is capable of adding new debtors if no debtors exists as per the provided Excel File.

Regards,
Kailash Raj

 

yes code is working thanks

 

This is Good Code But its only import sales without inventory. what about if we wanted to import with inventory transactions.

 

@ psjain_jal where is the bundle of tdl as committed by you earlier in this forum.

 

I am facing this weird problem with this code. My invoices are getting created successfully but they are not appearing in 'VAT Computation'. I have to manually edit each and every invoice and then select 'VAT/Tax Class' against Sales and VAT Ledgers and then save them again to make them appear under 'VAT Computation'. Anyone knows how to get rid off of this problem?

 

You are missing
1.'Tax Classification Name' in 'To Sales Entry' SET Value
2.'Tax Classification Name' & 'VAT Assessable Value' in 'To Vat Entry' SET Value

 

just try this. It is very raw stage. you have to add additional columns in excel to use vat class etc.

 

Off the topic:- I have one coding.But in that I want to call trigger function of collection which will call another report contains another collection which will trigger to final report.Both collections are using udf and not built in collection. any idea?

 

Correct File

 

Hi,

Thank you all for help! Adding the Vat Tax Classification & VAT Accessible Value did the trick for me. Thanks Again!

 

Please share the final codes. May be helpful to others also.

 

HI PSJain.

PFA for sales import with inventory and sample excel also..

 

I am getting error at Label 670. Will it import if you have more items in single sales.

 

U must to create Item in tally as per excel. it will import multiple stock item also.

 

May be I made Mistake While creating Stock Item.

My question is if I have three different item( E.G Apple, Orange,Milk) in single invoice. Can I import same to a single invoice.

 

Defiantly it'll work ...

 

Dear Experts,

I am doing same thing but not by excel by mentioning fixed value, I am getting success to insert a new voucher but Inventory Details are not stored. I have studied attached file in this thread but I dont know why it is not storing inventory entries, I think I have made a small mistake which I am unable to find. Please help me to findout problem in attached code.

 

Hi Maulik Patel

Try this.....