How to show opening amount in bills receivable report in xml format using tally?

Question

How to show opening amount in bills receivable report in xml format using tally?

222 Views Asked by Sevymol Sebastian At 08 April 2025 at 13:43

I am trying to get Tally Erp 9 Bills Receivable through post XML Request, everything is working fine except opening amount. Please guide me to get opening amount.

XML Request:

     <ENVELOPE>

        <HEADER>
            <TALLYREQUEST>Export Data</TALLYREQUEST>
        </HEADER>

        <BODY>
            <EXPORTDATA>
                <REQUESTDESC>

                    <STATICVARIABLES>
                        <SVEXPORTFORMAT>SysName:XML</SVEXPORTFORMAT>
                    </STATICVARIABLES>

                    <REPORTNAME>Bills Receivable</REPORTNAME>

                </REQUESTDESC>
            </EXPORTDATA>
        </BODY>
            
    </ENVELOPE>

XML Response:

    <ENVELOPE>
    <BILLFIXED>
    <BILLDATE>1-Dec-2016</BILLDATE>
    <BILLREF>A-2602</BILLREF>
    <BILLPARTY>ABC Company</BILLPARTY>
    </BILLFIXED>
    <BILLCL>-17000.00</BILLCL>
    <BILLPDC></BILLPDC>
    <BILLFINAL>-17000.00</BILLFINAL>
    <BILLDUE>31-Dec-2016</BILLDUE>
    <BILLOVERDUE>1848</BILLOVERDUE>
    <BILLFIXED>
    <BILLDATE>15-Dec-2016</BILLDATE>
    <BILLREF>A-2726</BILLREF>
    <BILLPARTY>XYZ Company</BILLPARTY>
    </BILLFIXED>
    <BILLCL>-74400.00</BILLCL>
    <BILLPDC></BILLPDC>
    <BILLFINAL>-74400.00</BILLFINAL>
    <BILLDUE></BILLDUE>
    <BILLOVERDUE>1834</BILLOVERDUE>
    </ENVELOPE>

Expected XML Response:

<ENVELOPE>
    <BILLFIXED>
    <BILLDATE>1-Dec-2016</BILLDATE>
    <BILLREF>A-2602</BILLREF>
    <BILLPARTY>ABC Company</BILLPARTY>
</BILLFIXED>
    <BILLOP>-17000.00</BILLOP>
    <BILLCL>-17000.00</BILLCL>
    <BILLPDC></BILLPDC>
    <BILLFINAL>-17000.00</BILLFINAL>
    <BILLDUE>31-Dec-2016</BILLDUE>
    <BILLOVERDUE>1848</BILLOVERDUE>
    <BILLFIXED>
    <BILLDATE>15-Dec-2016</BILLDATE>
    <BILLREF>A-2726</BILLREF>
    <BILLPARTY>XYZ Company</BILLPARTY>
</BILLFIXED>
    <BILLOP>-90000.00</BILLOP>
    <BILLCL>-74400.00</BILLCL>
    <BILLPDC></BILLPDC>
    <BILLFINAL>-74400.00</BILLFINAL>
    <BILLDUE></BILLDUE>
    <BILLOVERDUE>1834</BILLOVERDUE>
</ENVELOPE>

How to get Tally Erp 9 Bills Receivable through post XML Request with opening amount? Is there is any option to set Show Opening Amount: Yes in XML Request?

Original Q&A

There are 1 best solutions below

**sai vineeth** · Accepted Answer

Extend the report and Add <SET>ShowOpBillAmt:Yes </SET>

Full XML will be

<ENVELOPE>
    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>EXPORT</TALLYREQUEST>
        <TYPE>DATA</TYPE>
        <ID>CustBillsreceivable</ID>
    </HEADER>
    <BODY>
        <DESC>
            <TDL>
                <TDLMESSAGE>
                    <REPORT ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CustBillsreceivable">
                        <USE>Bills Receivable  </USE>
                        <SET>ShowOpBillAmt:Yes </SET>
                    </REPORT>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>

How to show opening amount in bills receivable report in xml format using tally?

There are 1 best solutions below

Related Questions in TALLY

Trending Questions

Popular # Hahtags

Popular Questions