Unable to get fields from INVENTORYALLOCATIONS while I do not need any fields from ALLLEDGERENTRIES while making xml request to Tally
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>EXPORT</TALLYREQUEST>
<TYPE>DATA</TYPE>
<ID>CA_VOUCHER</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT>
<SVCURRENTCOMPANY>Company Name</SVCURRENTCOMPANY>
<SVFROMDATE TYPE="Date">07-03-2023</SVFROMDATE>
<SVTODATE TYPE="Date">07-03-2023</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<REPORT ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHER">
<FORM>CA_VOUCHER</FORM>
</REPORT>
<FORM ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHER">
<PART>CA_VOUCHER</PART>
<XMLTAG>VOUCHERS</XMLTAG>
</FORM>
<PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHER">
<LINE>CA_VOUCHER</LINE>
<REPEAT>CA_VOUCHER:CA_VOUCHERCOLLECTION</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGER">
<LINE>CA_VOUCHERLEDGER</LINE>
<REPEAT>CA_VOUCHERLEDGER:ALLLEDGERENTRIES</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGERINVENTORY">
<LINE>CA_VOUCHERLEDGERINVENTORY</LINE>
<REPEAT>CA_VOUCHERLEDGERINVENTORY:INVENTORYALLOCATIONS</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHER">
<FIELDS>
CA_DATE,CA_VOUCHERTYPENAME,CA_VOUCHERNUMBER</FIELDS>
<XMLTAG>VOUCHER</XMLTAG>
<EXPLODE>CA_VOUCHERLEDGER:Yes</EXPLODE>
</LINE>
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGER">
<FIELDS>CA_LEDGERNAME</FIELDS>
<XMLTAG>ENTRY</XMLTAG>
<EXPLODE>CA_VOUCHERLEDGERINVENTORY:Yes</EXPLODE>
</LINE>
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGERINVENTORY">
<FIELDS>CA_STOCKITEMNAME,CA_ACTUALQTY,CA_RATE</FIELDS>
<XMLTAG>STOCKITEM</XMLTAG>
</LINE>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_DATE">
<TYPE>Date</TYPE>
<SET>$Date</SET>
<XMLTAG>DATE</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHERTYPENAME">
<SET>$VOUCHERTYPENAME</SET>
<XMLTAG>VOUCHERTYPE</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHERNUMBER">
<SET>$VoucherNumber</SET>
<XMLTAG>VOUCHERNUMBER</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_LEDGERNAME">
<SET>$LEDGERNAME</SET>
<XMLTAG>LEDGER</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_STOCKITEMNAME">
<SET>$STOCKITEMNAME</SET>
<XMLTAG>NAME</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_ACTUALQTY">
<TYPE>Quantity</TYPE>
<SET>$ACTUALQTY</SET>
<XMLTAG>QUANTITY</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_RATE">
<TYPE>Rate</TYPE>
<SET>$RATE</SET>
<XMLTAG>RATE</XMLTAG>
</FIELD>
<COLLECTION ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHERCOLLECTION">
<TYPE> Vouchers : VoucherType</TYPE>
<CHILDOF>$$VchTypeSales</CHILDOF>
<BELONGSTO>Yes</BELONGSTO>
<NATIVEMETHOD>*</NATIVEMETHOD>
<NATIVEMETHOD>ALLLEDGERENTRIES.LIST</NATIVEMETHOD>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
Abode code is working fine but neither I need any ledger name nor I need my inventory items enclosed in Entry element (ALLLEDGERENTRIES). When I send request with following XML body it throw fatal error and closed tally.
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>EXPORT</TALLYREQUEST>
<TYPE>DATA</TYPE>
<ID>CA_VOUCHER</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT>
<SVCURRENTCOMPANY>Company Name</SVCURRENTCOMPANY>
<SVFROMDATE TYPE="Date">07-03-2023</SVFROMDATE>
<SVTODATE TYPE="Date">07-03-2023</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<REPORT ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHER">
<FORM>CA_VOUCHER</FORM>
</REPORT>
<FORM ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHER">
<PART>CA_VOUCHER</PART>
<XMLTAG>VOUCHERS</XMLTAG>
</FORM>
<PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHER">
<LINE>CA_VOUCHER</LINE>
<REPEAT>CA_VOUCHER:CA_VOUCHERCOLLECTION</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGER">
<LINE>CA_VOUCHERLEDGER</LINE>
<REPEAT>CA_VOUCHERLEDGER:ALLLEDGERENTRIES</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<PART ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGERINVENTORY">
<LINE>CA_VOUCHERLEDGERINVENTORY</LINE>
<REPEAT>CA_VOUCHERLEDGERINVENTORY:INVENTORYALLOCATIONS</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHER">
<FIELDS>
CA_DATE,CA_VOUCHERTYPENAME,CA_VOUCHERNUMBER</FIELDS>
<XMLTAG>VOUCHER</XMLTAG>
<EXPLODE>CA_VOUCHERLEDGER:Yes</EXPLODE>
</LINE>
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGER">
<FIELDS></FIELDS>
<XMLTAG>ENTRY</XMLTAG>
<EXPLODE>CA_VOUCHERLEDGERINVENTORY:Yes</EXPLODE>
</LINE>
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGERINVENTORY">
<FIELDS>CA_STOCKITEMNAME,CA_ACTUALQTY,CA_RATE</FIELDS>
<XMLTAG>STOCKITEM</XMLTAG>
</LINE>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_DATE">
<TYPE>Date</TYPE>
<SET>$Date</SET>
<XMLTAG>DATE</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHERTYPENAME">
<SET>$VOUCHERTYPENAME</SET>
<XMLTAG>VOUCHERTYPE</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHERNUMBER">
<SET>$VoucherNumber</SET>
<XMLTAG>VOUCHERNUMBER</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_STOCKITEMNAME">
<SET>$STOCKITEMNAME</SET>
<XMLTAG>NAME</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_ACTUALQTY">
<TYPE>Quantity</TYPE>
<SET>$ACTUALQTY</SET>
<XMLTAG>QUANTITY</XMLTAG>
</FIELD>
<FIELD ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_RATE">
<TYPE>Rate</TYPE>
<SET>$RATE</SET>
<XMLTAG>RATE</XMLTAG>
</FIELD>
<COLLECTION ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO"
ISINTERNAL="NO" NAME="CA_VOUCHERCOLLECTION">
<TYPE> Vouchers : VoucherType</TYPE>
<CHILDOF>$$VchTypeSales</CHILDOF>
<BELONGSTO>Yes</BELONGSTO>
<NATIVEMETHOD>*</NATIVEMETHOD>
<NATIVEMETHOD>ALLLEDGERENTRIES.LIST</NATIVEMETHOD>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
I want to generate the following response with above mentioned xml request body.
<VOUCHERS>
<VOUCHER>
<DATE>1-Feb-23</DATE>
<VOUCHERTYPE>Sales</VOUCHERTYPE>
<VOUCHERNUMBER>1</VOUCHERNUMBER>
<STOCKITEM>
<NAME>Product Name</NAME>
<QUANTITY>1000 Pcs</QUANTITY>
<RATE>1.50/Pcs</RATE>
</STOCKITEM>
</VOUCHER>
*
*
*
</VOUCHERS>
Thank you.
Solution
In second xml CA_VOUCHERLEDGER line has no fields, so tally throws error instead change to
<LINE ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO"
NAME="CA_VOUCHERLEDGER">
<FIELDS>SimpleField</FIELDS>
<EXPLODE>CA_VOUCHERLEDGERINVENTORY:Yes</EXPLODE>
<LOCAL>Delete:FIELD:SimpleField</LOCAL>
</LINE>
you will get empty <SIMPLEFIELD></SIMPLEFIELD> tags you can ignore while parsing
- XML request for Groupwise vouchers details ,ledgers and their bill references , GST breakups ,address
- Unable to fetch Voucher Transaction Details in Tally XML
- Not able to fetch UDF fields using XML Request in Tally API
- How to get the created company list in Tally?
- Can we Load TDL file to Tally through C# code automatically
- How to limit nested fields in Tally XML Export Response
- How to export group from tally in XML format?
- Error in exporting other language text as ???? in Tally data
- Not able to fetch LedgerList data in an XML request from Tally
- Tally prime 2.1 is not fetching data under the given date
- Export Item-wise stock summary from Tally ERP 9
- Tally ERP: Bank Statement option disabled
- How to get rid of (&#4;) special character in Tally XML Ledger Export Response
- Unable to get fields from INVENTORYALLOCATIONS while I do not need any fields from ALLLEDGERENTRIES while making xml request to Tally
- Getting error "Cannot understand Bad formula! 'Starting From' " while sending following XML request to Tally to get the list of companies on disk
- What is the meaning of ISMODIFY="NO" ISFIXED="NO" ISINITIALIZE="NO" ISOPTION="NO" ISINTERNAL="NO" in Tally XML Request
- Amount Sign Is Not Exporting in XML Response (Only Absolute Digits Are Exporting)
- Is there a way to extract all the stock items from Tally Group/Category including the items inside sub-group with Tally XML request?
- R Dplyr Add Rows Total
- How to export list of all ledgers which is under sundry debitors from tally using xml
- Is there any option in tally that should be changed for altering stock item names using xml request?
- Got error " Voucher totals do not match!" in tally import with node js
- Display LedgerDetails MonthlyWise from TallyErp 9 using xml tag
- Unable to save the file Error in TallyPrime
- How to export employees from tally in XML format?
- Adding a tally/count of observations using mutate in r
- What language and database is used for Tally ERP development?
- How to export all deleted data from tally using XML
- what control element does "Tally Prime" uses?
- Tally Prime Xml import Voucher total donot match