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
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?
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.
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
This is Good Code But its only import sales without inventory. what about if we wanted to import with inventory transactions.
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?
Hi, Thank you all for help! Adding the Vat Tax Classification & VAT Accessible Value did the trick for me. Thanks Again!
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.
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.