我正在嘗試通過 xml 請求從計數中獲取 Groupwise 憑證詳細資訊，我成功獲取了組詳細資訊。
接下來，我需要在 for 回圈中一一傳遞組名，應該收到 Groupwise 憑證詳細資訊、分類帳及其賬單參考、GST 拆分、地址等，
我嘗試使用以下代碼獲取組詳細資訊并收到正確的回應。
<?xml version="1.0" encoding="utf-8"?>
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>MyReportGroupTable</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<REPORT NAME="MyReportGroupTable">
<FORMS>MyForm</FORMS>
</REPORT>
<FORM NAME="MyForm">
<PARTS>MyPart</PARTS>
</FORM>
<PART NAME="MyPart">
<LINES>MyLine</LINES>
<REPEAT>MyLine : MyCollection</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="MyLine">
<FIELDS>FldGuid,FldName,FldParent,FldPrimaryGroup,FldIsRevenue,FldIsDeemedPositive,FldSortPosition</FIELDS>
</LINE>
<FIELD NAME="FldGuid">
<SET>$Guid</SET>
</FIELD>
<FIELD NAME="FldName">
<SET>$$StringFindAndReplace:$Name:'"':'""'</SET>
</FIELD>
<FIELD NAME="FldParent">
<SET>$$StringFindAndReplace:$Parent:'"':'""'</SET>
</FIELD>
<FIELD NAME="FldPrimaryGroup">
<SET>$_PrimaryGroup</SET>
</FIELD>
<FIELD NAME="FldIsRevenue">
<SET>$IsRevenue</SET>
</FIELD>
<FIELD NAME="FldIsDeemedPositive">
<SET>$IsDeemedPositive</SET>
</FIELD>
<FIELD NAME="FldSortPosition">
<SET>$SortPosition</SET>
</FIELD>
<COLLECTION NAME="MyCollection">
<TYPE>Group</TYPE>
<FETCH>IsRevenue,IsDeemedPositive,SortPosition,_PrimaryGroup</FETCH>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
在此之后，我需要 XML 請求來獲取 Groupwise 憑證詳細資訊、分類帳詳細資訊、他們的賬單參考、GST 拆分和地址
在過去的一個月里，我嘗試了很多 xml 代碼，但我沒有成功。
我試過以下代碼。我得到了成功的回應。但我無法鏈接/添加組名及其父組名
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>MyReportLedgerVouchers</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVFROMDATE>$fromDate$</SVFROMDATE>
<SVTODATE>$toDate$</SVTODATE>
<SVEXPORTFORMAT>$$SysName:ASCII</SVEXPORTFORMAT>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<REPORT NAME="MyReportLedgerVouchers">
<FORMS>MyForm</FORMS>
</REPORT>
<FORM NAME="MyForm">
<PARTS>MyPart</PARTS>
</FORM>
<PART NAME="MyPart">
<LINES>MyLine</LINES>
<REPEAT>MyLine : MyCollection</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="MyLine">
<FIELDS>FldDate,FldVoucherType,FldVoucherNumber,FldLedger,FldAmount,FldNarration</FIELDS>
</LINE>
<FIELD NAME="FldDate">
<SET>$Date</SET>
</FIELD>
<FIELD NAME="FldVoucherType">
<SET>$VoucherTypeName</SET>
</FIELD>
<FIELD NAME="FldVoucherNumber">
<SET>$$StringFindAndReplace:$VoucherNumber:'"':'""'</SET>
</FIELD>
<FIELD NAME="FldLedger">
<SET>$$StringFindAndReplace:$FldLedger:'"':'""'</SET>
</FIELD>
<FIELD NAME="FldAmount">
<SET>$FldAmount</SET>
</FIELD>
<FIELD NAME="FldNarration">
<SET>$$StringFindAndReplace:$Narration:'"':'""'</SET>
</FIELD>
<COLLECTION NAME="MyCollection">
<TYPE>Voucher</TYPE>
<FETCH>Narration,AllLedgerEntries</FETCH>
<FILTER>FilterCancelledVouchers,FilterOptionalVouchers,FilterVch</FILTER>
</COLLECTION>
<SYSTEM TYPE="Formulae" NAME="FilterVch">NOT $$IsEmpty:($$FilterValue:$LedgerName:AllLedgerEntries:First:FilterVchLedger)</SYSTEM>
<SYSTEM TYPE="Formulae" NAME="FilterVchLedger">$$IsEqual:$LedgerName:"$ledgerName$"</SYSTEM>
<SYSTEM TYPE="Formulae" NAME="FilterVchLedgerNot">NOT $$IsEqual:$LedgerName:"$ledgerName$"</SYSTEM>
<SYSTEM TYPE="Formulae" NAME="FldAmount">if $$IsDr:$$FilterAmtTotal:AllLedgerEntries:FilterVchLedger:$Amount then (-$$FilterAmtTotal:AllLedgerEntries:FilterVchLedger:$Amount) else ($$FilterAmtTotal:AllLedgerEntries:FilterVchLedger:$Amount)</SYSTEM>
<SYSTEM TYPE="Formulae" NAME="FldLedger">if $$FilterCount:AllLedgerEntries:FilterVchLedgerNot > 1 then ($$FullList:AllLedgerEntries:$LedgerName) else ($$FilterValue:$LedgerName:AllLedgerEntries:First:FilterVchLedgerNot)</SYSTEM>
<SYSTEM TYPE="Formulae" NAME="FilterCancelledVouchers">NOT $IsCancelled</SYSTEM>
<SYSTEM TYPE="Formulae" NAME="FilterOptionalVouchers">NOT $IsOptional</SYSTEM>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>```
uj5u.com熱心網友回復：
使用Below Xml根據組名獲取優惠券
<Childof>Sales Accounts</Childof>相應地改變
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>Vouchers</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <!-- * Supports only xml format -->
<SVViewName>Accounting Voucher View</SVViewName>
<SVFROMDATE TYPE="Date">20200801</SVFROMDATE>
<SVTODATE TYPE="Date">20210831</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<COLLECTION ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No" NAME="Vouchers">
<TYPE> Vouchers : Group</TYPE>
<!--Replace Sales Accounts with GroupName you want to search -->
<Childof>Sales Accounts</Childof>
<NATIVEMETHOD>*</NATIVEMETHOD>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/427391.html