I am working with Tally XML requests and need to extract the GUID for the following hierarchy:
Voucher (Invoice). Invoice (Details of the voucher). StockItem (Specific item in the invoice).
The XML structure I am working with has various nested elements, but I am unsure how to correctly extract the GUID for each of these layers (Voucher, Invoice, StockItem).
Here’s an example of the XML request I am using:
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>EXPORT</TALLYREQUEST>
<TYPE>COLLECTION</TYPE>
<ID>CUSTOMVOUCHERDATA</ID>
</HEADER>
<BODY>
<DESC>
<SVFROMDATE Type="DATE">20240401</SVFROMDATE>
<SVTODATE Type="DATE">20240630</SVTODATE>
<TDL>
<TDLMESSAGE>
<COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="CUSTOMVOUCHERDATA">
<TYPE>VOUCHER</TYPE>
<FETCH>
VOUCHERNUMBER,DATE,ISCANCELLED,PARTYNAME,PARTYLEDGERNAME,PARTYGSTIN,CONSIGNEEGSTIN,
LEDGERENTRIES.LIST,ALLLEDGERENTRIES,AMOUNT,VCHSTATUSDATE,EFFECTIVEDATE,ALTERID,
MASTERID,VOUCHERKEY,VOUCHERRETAINKEY,GUID,BASICSHIPDOCUMENTNO,BASICFINALDESTINATION,
BASICSHIPVESSELNO,EICHECKPOST,BILLOFLADINGNO,BILLOFLADINGDATE,BILLOFLADINGDATE,
BASICSHIPPEDBY,IRN,IRNACKDATE,GSTREGISTRATION,VOUCHERTYPENAME,CMPGSTREGISTRATIONTYPE,
CMPGSTSTATE,NUMBERINGSTYLE,VCHSTATUSTAXUNIT,GSTNATUREOFRETURN,STOCKITEM.GUID
</FETCH>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>