Dear All Tdl Experts, Thanks in advance, please help me to add one new field in outstanding aging report. i tried in many ways, but i can't do it. please guide me. Thanking you,
try this. [#Line: BILLWithDates] Delete: Right Fields : BILLOverdue [#Field: BILLFixed] Add : Fields : After : BILLRef : BillPONo [Field : BillPONo] use : namefield Width:8 Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:FirstolyfabSales My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo [System: Formula] Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName [#Line: BILLCol1] Local:Field:BillPONo:Setas:"PO No" [#Line: BILLCol2] Local:Field:BillPONo:Setas:""
try this also: [#Line: BILLWithDates] Delete: Right Fields : BILLOverdue [#Field: BILLFixed] Add : Fields : After : BILLRef : BillLPONo, BillPOdate [Field : BillPOdate] ;;Use : Short Date Field Set as : $$FilterValue:$BasicOrderDate:LedgerEntries:FirstolyfabSales ;;if $$IsSysName:$BasicPurchaseOrderNo then "" else $$FullList:InvoiceOrderList:$BasicOrderDateBasicOrderDateUniversal width : 10 MyValue:$$FullList:InvoiceOrderList:$BasicOrderDate [Field : BillLPONo] use : namefield Width:8 Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:FirstolyfabSales My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo ;;Set as: $BasicPurchaseOrderNo [#Collection: Company Receivables] Fetch:BasicPurchaseOrderNo,BasicOrderDate [#Collection: Company Payables] Fetch:BasicPurchaseOrderNo,BasicOrderDate [System: Formula] Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName [#Line: BILLCol1] Local:Field:BillLPONo:Setas:"PO No" [#Line: BILLCol2] Local:Field:BillLPONo:Setas:"" [#Line: BILLCol1] Local:Field:Billpodate:Setas:"PO Date" [#Line: BILLCol2] Local:Field:Billpodate:Setas:""
Dear sir, i want to display customer mobile number in Group outstanding report please correct below code [#Line: BILLCol1] use :BillDetail Local : Field : BillContact : Set as: $$LocaleString:"Contact" [#Line: BILLCol2] Local : Field : BillContact : Set as: "" [#Field: BILLFixed] Add: Field : After: BILLParty : BillContact [Field: BillContact] Set as : $LedgerMobile:LedgerartyLedgerName [#Line: BILL Total] Local : Field : BillContact : Set as : "" [#Part: GRPLedBILL Details] Local: Line : BILL Detail : Local : Field : BillContact : Set as : "" [#Line: GRPLedBILL Total] Local : Field : BillContact : Set as : ""
Try This [#Line: BILLCol1] use :BillDetail Local : Field : BillContact : Set as: $$LocaleString:"Contact" [#Line: BILLCol2] Local : Field : BillContact : Set as: "" [#Field: BILLFixed] Add: Field : After: BILLParty : BillContact [Field: BillContact] Set as : $LedgerMobile:Ledger:$parent [#Line: BILL Total] Local : Field : BillContact : Set as : "" [#Part: GRPLedBILL Details] Local: Line : BILL Detail : Local : Field : BillContact : Set as : "" [#Line: GRPLedBILL Total] Local : Field : BillContact : Set as : ""
Help me to a design a outstanding collection, First repeat will be "BASED ON PARTY LEDGER NAME", THEN REPEAT BASED ON VOUCHER TYPE". [Collection : MyOsColl] Type : Bills Compute : PartyName : $$FuncDSPAccName:$Parent Compute : BillRef : $BillRef Filter :Filter : IsReceivable, PartyFilter [System : Formula] PartyFilter : $$FuncDSPAccName:$Parent = #MyPartyLedger MySPfilter : ($$IsSales:$VoucherTypeName) ExemptedFilter : $$FilterValue:$VoucherTypeName:LedgerEntries:First:MySPFilter = "GST Seeds Sales" TaxableFilter : $$FilterValue:$VoucherTypeName:LedgerEntries:First:MySPFilter = "GST Sales Taxable" Further I am unable use "Walk" and " to Group" "By" in the collection
Started Designing; Below is the Outline; Want a collection "By" "PartyName" then using the collection I want to repeat a PartyName Line in the "Bills Receivables" based on "VoucherTypeName"
Same like this i want to code for Sales Ledger name in outstanding report instead of contact number. so i can analyse what item sold and showing outstanding....pls help me