I am trying to import a payment voucher for a particular bill through XML request. I was partially successful in doing it. I was only able to import a payment voucher against an Account but not Against a Reference (Particular bill). Here is the XML Request : <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Import</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Vouchers</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVCURRENTCOMPANY>Test Company</SVCURRENTCOMPANY> </STATICVARIABLES> </DESC> <DATA> <TALLYMESSAGE> <VOUCHER> <DATE>20190302</DATE> <NARRATION>Test Import Payment</NARRATION> <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME> <ALLLEDGERENTRIES.LIST> <LEDGERNAME>Test Bill</LEDGERNAME> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <AMOUNT>-2.00</AMOUNT> </ALLLEDGERENTRIES.LIST> <ALLLEDGERENTRIES.LIST> <LEDGERNAME>Cash</LEDGERNAME> <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE> <AMOUNT>2.00</AMOUNT> </ALLLEDGERENTRIES.LIST> </VOUCHER> </TALLYMESSAGE> </DATA> </BODY> </ENVELOPE> The above XML successfully creates a Payment voucher On Account but not against a Reference. I have made some XML changes (adding <BILLALLOCATIONS.LIST> tag) to achieve my desired result but it ends up giving the same result. <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Import</TALLYREQUEST> <TYPE>Data</TYPE> <ID>Vouchers</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <SVCURRENTCOMPANY>Test Company</SVCURRENTCOMPANY> </STATICVARIABLES> </DESC> <DATA> <TALLYMESSAGE> <VOUCHER> <DATE>20190302</DATE> <NARRATION>Test Import Payment</NARRATION> <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME> <ALLLEDGERENTRIES.LIST> <LEDGERNAME>Test Bill</LEDGERNAME> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <AMOUNT>-2.00</AMOUNT> <BILLALLOCATIONS.LIST> <NAME>777</NAME> <BILLTYPE>Agst Ref</BILLTYPE> <TDSDEDUCTEEISSPECIALRATE>No</TDSDEDUCTEEISSPECIALRATE> <AMOUNT>-₹ 2.00</AMOUNT> <INTERESTCOLLECTION.LIST> </INTERESTCOLLECTION.LIST> <STBILLCATEGORIES.LIST> </STBILLCATEGORIES.LIST> </BILLALLOCATIONS.LIST> </ALLLEDGERENTRIES.LIST> <ALLLEDGERENTRIES.LIST> <LEDGERNAME>Cash</LEDGERNAME> <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE> <AMOUNT>2.00</AMOUNT> </ALLLEDGERENTRIES.LIST> </VOUCHER> </TALLYMESSAGE> </DATA> </BODY> </ENVELOPE> Kindly help me in achieving my desired output. Thanks in Advance.
This may also happen when Bill Ref No i.e. Bill Name "777" is your example is already used somewhere in allocations.. as agst Ref. also note that while saving the payment transaction, it will be "Agst Ref" but when you again open this Payment Voucher it will automatically change to On Account Try altering original bill entry or delete it and then pass a new entry se a different ref no.. unique one.. and again try with your code.
Thanks for your reply. I have tried creating a new Bill and made a payment but still I'm getting the Payment Voucher created "On Account" only. Also, you have mentioned in your answer that, even though Payment is recorded "Agst Ref" but it will be automatically changed to "On Account". Does it mean that when I try to import I wont be able to record a Payment against a particular bill? If the above is true, I won't be able to close my bill even after recording the payment and the Bill amount will always be displayed in the Outstanding Payables. Can you please suggest a solution for this?
Ok.. Rupee Symbol is the issue.. Good Second line in my last message would be applicable only when error mentioned in my first line is there.
A suggestion....from my past experience of importing vouchers........ After importing and before opening any vouchers..... please REWRITE the company.............. hope it helps in this case.
Right Sir @Amit Kamdar and some time we need to close the Tally to refresh List variables and collection values.. Particularly when Variable definition is changed/