Dear all, Through this you can import Reference wise of Payment voucher from excel to tally through xml file. Step 1 : Fill template as per describe in template Step 2 : goto ledger sheet and click on unique ledger import Step 3 : Give a proper group of ledger and generate ledger import xml file from second button Step 4 : Then go to tally import ledger form above generate xml file. Step 5 : after that goto 1 sheet and generate Payment vouchers xml file. Step 6 : Now again goto tally and import vouchers from above generated xml file. Task complete For any query M.n. 9152953646 Email : hrharry20@gmail.com Note : Don't import ledger if ledger is already created because it replace old one so beware from this. if you don't want to create ledger you can skip step 2 to 4 (if ledger is already created in company)
Sir, it will be apply only direct & indirect expenditure ledger,month wise budget & expenditure report. Thanks With regards, Birender singh
Dear Sir, Thanks for instant reply We have 15 cost centres, please if possible to provide the budget upload month wise excel template on ledger net transactions budget import of all cost centres. Thanks with regard Birender singh
See this thread http://tdlexperts.net/index.php?threads/import-payment-voucher-with-multiple-cost-center.4915/
Dear sir how to send the sales invoice in msg.... The Msg content like : Date,Item Names,Qty,Item Rate,Amount.
Hi Sir, Please let me know if printing of purchase voucher with multiple bill wise is possible, like we get payment voucher with all billwise details. If yes, please give me some hint so I can start building my TDL..Thanks..
Please provide TDL file for Importing purchase, Journal, Payment And receipt, for the same we have attached sample excel formate
This is not a TDL Selling Website. Try your Own. If Any Struggle Post here we ll help you. Dear Experts, These type of peoples get code here and sell in market. Don't post any code here.
I'm struggling for months in how to import vouchers from excel to tally through TDL, very recently I've got good grip in the area of formatting definitions. Honestly, to me, it always grey area how the collection definition is working., after that I've seen a code for importing sales vouchers. it contains "create object", "set target" "create target" etc.,., now I understand a lill bit of its functional flow. I was even successful to convert the code to my necessary as purchase voucher, payment voucher, receipt voucher and journal. failed in making for contra. Besides that, The code I've got for importing, lacks in adding the bill allocations or bank allocations which was very most necessary for me. I was trying to insert such collection object in the code, it displays,"Original definition for Collection : Bill Allocation not found" for the particular TDL program line .................... 14 : Insert Collection Object : Ledger Entries ...................... 78 : Insert Collection Object : Bill Allocations ................. this same line is working in the other default tdl programs in the TDE. and one more interesting factor, yeah when I hold the ctrl button and click on the "Bill Allocations", TDE also showed the same message, "Original definition for Collection : Bill Allocation not found" and even more interestingly, TDE shows the same message for"Ledger Entries" as well. But The program was running perfectly alright somebody's code, but when I try to modify in my own with other objects, it refusing, what can I do, All I wanted to say above is, How can I import Vouchers with bill wise references,
That is how we learn better.....by doing it little by little..... Refer ... VchColl.500 ...........in TDE. .......... [Function: Set PartyBills] or search for ...........[Function: ExportClosingLedger] It will give you ideas.
not fruitful ideas, I've done lot of permutaion combination of my few ideas, nothing works, at every iteration I got irritated by this error "Collection Bill Allocations Could not be found"., it is able to find the non existence collection"Ledger Entries", then why the heck it is not finding the Bill allocation Collections... grrrrrrrrrrr I'm at top of my patience... below is the code, the label 138 is not at all passed through Code: 130 : INSERT COLLECTION OBJECT : Ledger Entries 131 : SET TARGET : Ledger Entries 132 : SET VALUE : LedgerName : "ROUND OFF" 133 : SET VALUE : Amount : $DSDRAAmt 135 : SET TARGET : .. ;147 : CREATE TARGET 136 : SET OBJECT : AllLedgerEntries 137 : SET TARGET : AllLedgerEntries 138 : INSERT COLLECTION OBJECT : BillAllocations 139 : SET VALUE : Bill Type : $$SysName:AgstRef 140 : SET VALUE : Name : $DSDVchNo 141 : SET VALUE : Amount : $DSDTotal 142 : SET TARGET : ..
INSERT COLLECTION OBJECT : Ledger Entries 131 : SET TARGET : Ledger Entries 132 : SET VALUE : LedgerName : $DSD.............. 133 : SET VALUE : Amount : $DSD...................... ;135 : SET TARGET : .. ;147 : CREATE TARGET Before INSERT COLLECTION OBJECT : BillAllocations in the line SET TARGET : .. Put " ;" I have same issue but I got solved by This
The issue solved, but the objective is not achieved. The objective is to set the bill number in new ref in Bill Allocation page.
hurray, the object is achieved, you're correct @sattam. but I wrote the code at inappropriate place. I've jus cut and pasted code somewhere and its working. However, a new objective required, how to do multiple bill allocations..
Try like this way INSERT COLLECTION OBJECT : Ledger Entries 132 : SET VALUE : LedgerName : $DSD.............. 133 : SET VALUE : Amount : $DSD...................... 134 : Set Value : IsDeemedPositive : Yes 140 : Insert Collection Object : BillAllocations 141 : Set Value : Name : "101" . . . 150 : Set Target : .... 160: Create Target