Dear All I write small tdl file i have following errors 1. FUNCTION :Import of sales voucher LABEL :50 Collection 'Bill Allocations' could not be found 2. Cost Center Allocations also same problem can you help me with in half an hour time becuase i have to post 1500 entries Regards Mano
Dear Manoharan, You have not mentioned Bill Allocations in your import function, try "INSERT COLLECTION OBJECT : BillAllocations" in your import function.
Hi Friend pls go through on of my code i made for Sales import may help you ;;60:SET: SVVoucherType: "Sales" 70:SET VALUE: Date: $ExcelVchDate ;;VCH_DT 75:SET VALUE: NARRATION: $REMARKS 80:SET VALUE: VoucherTypeName : "SALES" 85:LOG: $VoucherTypeName ;;90:SET VALUE: VoucherNumber 100:SET VALUE: PartyLedgerName: $LED_NM 101:SET VALUE : PersistedView: ##SVViewName 110:SET VALUE: IsInvoice: Yes 120:SET VALUE: Reference: $$STRING:$INV_NO 121: log: $inv_no 130:INSERT COLLECTION OBJECT: LEDGERENTRIES 140:SET VALUE: LedgerName: $LED_NM 150:SET VALUE: IsDeemedPositive: Yes 160:SET VALUE: Amount: $$AsAmount:$TOT_AMT * -1 ;;170:SET TARGET: .. 171:INSERT COLLECTION OBJECT: CATEGORY ALLOCATIONS 171A:SET VALUE: CATEGORY: "Primary Cost Category" 172:SET VALUE: IsDeemedPositive: yES 173:INSERT COLLECTION OBJECT: COST CENTRE ALLOCATIONS 174:SET VALUE: NAME: $CST_NM 175:SET VALUE: AMOUNT: $$ASAMOUNT:$TOT_AMT * -1 176:SET TARGET : ... 330:INSERT COLLECTION OBJECT: lEDGER ENTRIES 340:SET VALUE: LedgerName: $SALES_LED 350:SET VALUE: IsDeemedPositive: No 360:SET VALUE: Amount: $$AsAmount:$SALESAMT 361:INSERT COLLECTION OBJECT: CATEGORY ALLOCATIONS 361A:SET VALUE: CATEGORY: "Primary Cost Category" 362:SET VALUE: IsDeemedPositive: No 363:INSERT COLLECTION OBJECT: COST CENTRE ALLOCATIONS 364:SET VALUE: NAME: $CST_NM 365:SET VALUE: AMOUNT: $$ASAMOUNT:$SALESAMT 370:SET TARGET: ... 371:INSERT COLLECTION OBJECT: lEDGER ENTRIES 372:SET VALUE: LedgerName: "VAT (Input VAT-16%)" 373:SET VALUE: IsDeemedPositive: No 374:SET VALUE: Amount: $$AsAmount:$VAT_AMT 375:INSERT COLLECTION OBJECT: CATEGORY ALLOCATIONS 376:SET VALUE: CATEGORY: "Primary Cost Category" 377:SET VALUE: IsDeemedPositive: No 378:INSERT COLLECTION OBJECT: COST CENTRE ALLOCATIONS 379:SET VALUE: NAME: $CST_NM 380:SET VALUE: AMOUNT: $$ASAMOUNT:$vAT_AMT 381:SET TARGET: ... 391:INSERT COLLECTION OBJECT: lEDGER ENTRIES 392:SET VALUE: LedgerName: "DISCOUNT" 393:SET VALUE: IsDeemedPositive: No 394:SET VALUE: Amount: $$AsAmount:$LED_DIS * -1 395:INSERT COLLECTION OBJECT: CATEGORY ALLOCATIONS 396:SET VALUE: CATEGORY: "Primary Cost Category" 397:SET VALUE: IsDeemedPositive: No 398:INSERT COLLECTION OBJECT: COST CENTRE ALLOCATIONS 400:SET VALUE: NAME: $CST_NM 401:SET VALUE: AMOUNT: $$ASAMOUNT:$LED_DIS * -1 402:SET TARGET: .. ;;403: SET VALUE : PersistedView: ##SVViewName 404:CREATE TARGET
tdl for Receipt & payment voucher import with multi cost center allocation. have any one to help??????????
DEAR all, i was use a trick from internet to import any data once pl enter one sales voucher as u want in tally export daybook to xml of same voucher edit xml file in notepad copy tally massege to tallymassege to new text file and paste in word doc please delete all gl name, amounts,date = values now go to word and open mail merge and pick from address from excel now map xml blank field to column head of excel sheet from address now after all mapping pl start mail merge it will take 10 min max pl copy this txt to original mail ( old tally message to message should delete} import this xml as normally. finish
Hi, Can someone help me setup bulk voucher import inside Tally ? Basically I have external data, which needs to be added to Tally and their respective invoices need to be created. I would be willing to pay for your time, if anyone can help. Thanks
but what about the Continuous following id how we can generate it - through mail merge. <VOUCHER REMOTEID="aaeb8870-afa4-4fe9-bd6f-" VCHTYPE="Payment" <GUID>aaeb8870-afa4-4fe9-bd6f-0f</GUID>
but what about the Continuous following id how we can generate it - through mail merge. <VOUCHER REMOTEID="aaeb8870-afa4-4fe9-bd6f-" VCHTYPE="Payment" <GUID>aaeb8870-afa4-4fe9-bd6f-0f</GUID>
dEAR you have to delete all guid, amounts, gl names, for eg original - <GUID>aaeb8870-afa4-4fe9-bd6f-0f</GUID> we need <GUID></GUID> it is auto created by tally. i have imported many times by this trick.
dEAR you have to delete all guid, amounts, gl names, for eg original - <GUID>aaeb8870-afa4-4fe9-bd6f-0f</GUID> we need <GUID></GUID> it is auto created by tally. i have imported many times by this trick.