In Bills receivable the give code fails to capture on Account related data. *** <ENVELOPE> <HEADER> <VERSION>1</VERSION> <TALLYREQUEST>Export</TALLYREQUEST> <TYPE>Data</TYPE> <ID>TGOutstandingGroup Details</ID> </HEADER> <BODY> <DESC> <STATICVARIABLES> <EXPLODEFLAG>Yes</EXPLODEFLAG> <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT> <SVCURRENTCOMPANY>${company}</SVCURRENTCOMPANY> <SVFROMDATE>${fromDate}</SVFROMDATE> <SVTODATE>${toDate}</SVTODATE> </STATICVARIABLES> <TDL> <TDLMESSAGE> <REPORT NAME="TGOutstandingGroup Details"> <FORMS>TGOutstandingGroup Details</FORMS> <TITLE>TGOutstandingGroup Details</TITLE> </REPORT> <FORM NAME="TGOutstandingGroup Details"> <TOPPARTS>TGOutstandingGroup Details Part</TOPPARTS> <XMLTAG>"ENVELOPE"</XMLTAG> </FORM> <PART NAME="TGOutstandingGroup Details Part"> <TOPLINES>TGOutstandingGroup Details Line Title, TGOutstandingGroup Details Details </TOPLINES> <REPEAT>TGOutstandingGroup Details Details : TGLedgerwiseBills</REPEAT> <SCROLLED>Vertical</SCROLLED> <COMMONBORDERS>Yes</COMMONBORDERS> </PART> <PART NAME="TGLedgerlist Line Title"> <TOPLINES>TGLedger Details</TOPLINES> <REPEAT>TGLedger Details:LedgerEntries</REPEAT> <SCROLLED>Vertical</SCROLLED> <COMMONBORDERS>Yes</COMMONBORDERS> </PART> <LINE NAME="TGOutstandingGroup Details Line Title"> <USE>TGOutstandingGroup Details Details</USE> <LOCAL>Field : Default : Type : String </LOCAL> </LINE> <LINE NAME="TGLedgerlist Line Title"> <USE>TGLedger Details</USE> <LOCAL>Field : Default : Type : String </LOCAL> <LOCAL>Field : Field Amount : Set as: "Amount"</LOCAL> </LINE> <LINE NAME="TGOutstandingGroup Details Details"> <LEFTFIELDS>BILLDate,BILLREF,BILLParty</LEFTFIELDS> <XMLTAG>BILLFIXED</XMLTAG> <Rightfields>BILLOP,BILLCL,BILLDUE,BILLOVERDUE,PONumber</Rightfields> <EXPLODE>TGLedgerlist Line Title</EXPLODE> </LINE> <LINE NAME="TGLedger Details"> <Rightfields>TGBillVchDate,BillVch,TGBillVchNo,BILLVCH Amount</Rightfields> <XMLTAG>BILLDETAILS</XMLTAG> </LINE> <FIELD NAME="BILLDate"> <USE>Name Field</USE> <SET>$BILLDate</SET> </FIELD> <FIELD NAME="BILLREF"> <USE>Name Field</USE> <SET>$Name </SET> </FIELD> <FIELD NAME="BILLParty"> <USE>Name Field</USE> <SET>$LedgerName</SET> </FIELD> <FIELD NAME="BILLCL"> <USE>Amount Field</USE> <SET>$ClosingBalance</SET> </FIELD> <FIELD NAME="BILLOP"> <USE>Amount Field</USE> <SET>$OpeningBalance</SET> </FIELD> <FIELD NAME="BILLDUE"> <USE>Long Date Field</USE> <SET>$$DueDateByDate:$BillDueDate</SET> </FIELD> <FIELD NAME="BILLOVERDUE"> <USE>Amount Field</USE> <SET>$CurLangVoucherTypeName</SET> </FIELD> <FIELD NAME="PONumber"> <USE>Name Field</USE> <SET>$PONo</SET> </FIELD> <FIELD NAME="BillVch"> <USE>Name Field</USE> <SET>$VoucherTypeName</SET> </FIELD> <FIELD NAME="TGBillVchNo"> <USE>Name Field</USE> <SET>$VoucherNumber</SET> </FIELD> <FIELD NAME="BILLVCH Amount"> <USE>Name Field</USE> <SET>$Amount</SET> </FIELD> <FIELD NAME="TGBillVchDate"> <USE>Name Field</USE> <SET>$Date</SET> </FIELD> <COLLECTION NAME="TGLedgerwiseBills" ISMODIFY="No"> <Type>Bills</Type> <Fetch>.*.</Fetch> <Filter>LedgerGroupFilter</Filter> </COLLECTION> <SYSTEM TYPE="Formulae" NAME="LedgerGroupFilter">$$IsLedOfGrp:$LedgerName:$$GroupSundryDebtors</SYSTEM> </TDLMESSAGE> </TDL> </DESC> </BODY> </ENVELOPE>***
If it's on Account, then Bill is not created Since you are accessing only bills, on Account data will not come. Refer the collection - "Ledger OnAccount Vouchers" in Tally Developer on how to get OnAccount Vouchers
