1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Import Payment Voucher for a Particular Bill (Against Ref) through XML Request

Discussion in 'Tally Integration' started by PraveenKumarDS, Mar 19, 2019.

    
Tags:
  1. PraveenKumarDS

    PraveenKumarDS New Member


    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.
     
    PraveenKumarDS, Mar 19, 2019
    #1


  2. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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.
     
    Devendra_Rawat, Mar 19, 2019
    #2


  3. PraveenKumarDS

    PraveenKumarDS New Member


    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?
     
    PraveenKumarDS, Mar 19, 2019
    #3


  4. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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.
     
    Devendra_Rawat, Mar 19, 2019
    #4
    PraveenKumarDS likes this.


  5. PraveenKumarDS

    PraveenKumarDS New Member

    PraveenKumarDS, Mar 19, 2019
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     
    Amit Kamdar, Mar 19, 2019
    #6


  7. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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/
     
    Devendra_Rawat, Mar 19, 2019
    #7
    Amit Kamdar likes this.


Share This Page