GST Transactions Import from Excel- MAP Excel Columns, All Voucher Types, Multiple Items & Ledgers

TDL to import te trying/testing

 

Great ........

 

Why Great ??

have you used it successfully ?

 

I checked royal furniture's data.

Single line entries.
Etc.

 

Dear Sir,
Is it possible to export data in excel with desire column setting? How pl guide. because tally export with default setting.
Thanks

 

Great..
I thought my assistance would be required for running this TDL (first time) successfully ..

anyway, great if you tested single line entries also..

 

Which report ? please mention the report name and also mention the setting you are referring to.

 

Any Report. Suppose monthly sale report if u export defaultly coluns of excel sheet will be of default. But if u want desire column setting , like date ist, invoice no. 2nd gst no. third and so on. like this . Thanks for response and Regards.

 

You will have to draft report accordingly and add export button to the report.
Export is internal function in tally i guess.. it reproduces the tally report in other formats

 

Why unauthorized ???

It is free TCP

 

Restriction removed

 

Can You help me about multiply bill reference adjust in one payment voucher import from excel to tally

 

I can surely help.. if you help yourself, if yot know a little TDL.
you will need two tables in excel

send me whatever you have done in TDL in this context, I can help but can not do it from scratch

 

I have done so far Import payment voucher from excel to tally with bank allocation.It import successfully.But problem is It takes only 1st ref. not multiply ref. please share your email so I can contact you.

 

ca.devendra.rawat@gmail.com.

I will try

 

CODE AND Excel file sent to email.Please help me.

 

also set tally demo data file

 

Cheque updated file with little one extra column in excel.


Please note that it was bill allocation and not bank allocation you were asking

 

WHEN I AM MAPING THE EXCEL FILE I GOT AN ERROR COMPANY NAME HAS NOT MEANING FULL CHARACTERS
AND IT IS NOT IMPORTING MULTIPAL SALES ENTERY

 

It is "Error" but it saves data.. and works well.. kindly share error screen, the data you are importing.. etc..

 

Thanks a lot garima ji

 

dear sir

please find attached error screen shot for the your reference

and also please share your code in txt file if it is possiable my mail id is mauliknisha2011@gmail.com

thanks and regards
maulik

 

Please note that UOM measurement is a must when you want to auto create items.

Single line = "No"
Invoice Mode = "Yes"
GST Applicalbe = "Yes"

are a few compulsory fields to be selected

If a new column in inserted in excel, you will first have to remove all mapping one by one and the remap again... I will look into it to make it automatic


Hope you liked on AnyDesk what this TDL can do.. it can work like miracle.

 

YES THANKS AND REGARDS