Bills

[Collection:MyLedg Outstanding]

Type : Bills

Cleared: No

Filter:ABSNP



[System : Formula]



ABSNP:$$FuncDSPAccName:$Parent = "Trade Debtors"


I want to filter the bills base on the Party Group

Please anyone help me to do this

 

i cant understand plz check my code

[LineR OutList]
FieldsROUTLineTally,InvDateTally,OInvNoTally,OInvCustomerNameTally,OInvAmountTally,DROUTListPDA,DROUTListFinalBalance ;,DROUTList030,DROUTList3060,DROUTList6090,DROUTList90120,DROUTListM120,
Border:Thin Bottom

[FieldROUTLineTally]
Use:Name Field
Set as:"No"
Width:10 mms
Skip:Yes
Border:Thin Right

[Field:InvDateTally]
Use:Name Field
Set as:"INV Date"
Width:25 mms
Border:Thin Right
Skip:Yes
Align:Right


[Field:OInvNoTally]
Use:Name Field
Set as:"INV No"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes

[Field:OInvCustomerNameTally]
Use:Name Field
Set as:"Cus Name"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes



[Field:OInvAmountTally]
Use:Name Field
Set as:"INV Amt"
Width:25 mms
Align:Right
Skip:Yes
Border:Thin Right


[FieldROUTList030]
Use:Name Field
Set as:"0 - 30"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes

[FieldROUTList3060]
Use:Name Field
Set as:"30 - 60"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes

[FieldROUTList6090]
Use:Name Field
Set as:"60 - 90"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes

[FieldROUTList90120]
Use:Name Field
Set as:"90 - 120"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes

[FieldROUTListM120]
Use:Name Field
Set as:"120 - <"
Align:Right
Width:25 mms
Border:Thin Right
Skip:Yes

[FieldROUTListPDA]
Use:Name Field
Set as:"PDC Amount"

Align:Right
Width:25 mms
Border:Thin Right
Skip:Yes

[FieldROUTListFinalBalance]
Use:Name Field
Set as:"Final Balance"
Align:Right
Width:25 mms
Skip:Yes


;
;;;======================================================================================================
;


[FieldROUTList030Tally]
Use:Amount Field
Set as:if (@@DSPToDate - $BillDate) Between 0 and 30 Then $BillAmt Else ""
Width:25 mms
Style:Normal
Skip:Yes
Align:Right
;+Border:Thin Right

[FieldROUTList3060Tally]
Use:Amount Field
Set as:if (@@DSPToDate - $BillDate) Between 31 and 59 Then $BillAmt Else ""
Width:25 mms
Style:Normal
Skip:Yes
Align:Right
;Border:Thin Right

[FieldROUTList6090Tally]
Use:Amount Field
Set as:if (@@DSPToDate - $BillDate) Between 60 and 89 Then $BillAmt Else ""
Width:25 mms
Style:Normal
Skip:Yes
Align:Right
;Border:Thin Right

[FieldROUTList90120Tally]
Use:Amount Field
Set as:if (@@DSPToDate - $BillDate) Between 90 and 119 Then $BillAmt Else ""
Width:25 mms
Style:Normal
Skip:Yes
Align:Right
;Border:Thin Right

[FieldROUTListM120Tally]
Use:Amount Field
Set as:if (@@DSPToDate - $BillDate) Between 120 and 180 Then $BillAmt Else ""
Width:25 mms
Skip:Yes
Align:Right
;Border:Thin Right

;=======================================================================================


[#Menu: GateWay of Tally]
Add: Key Item: OutatandingPopUp : T isplay: ReorderPopUpOutstanding :NOT $$IsEmpty:$$SelectedCmps

[Report:ReorderPopUpOutstanding]
Form:ReorderPopUpOutstanding

[Form:ReorderPopUpOutstanding]
Use : DSP TEMPLATE
Parts:AMOutStandingDetails

[Part:AMOutStandingDetails]
LineR OutList,LedOutStanding ;,DR OutListTotal
Repeat:LedOutStanding:MyLedg Outstanding
Space Top:1 mms
Total:OInvAmount,DROUTList030Tally,DROUTList3060Tally,DROUTList6090Tally,DROUTList90120Tally,DROUTListM120Tally,DROUTListPDATally,DROUTListFinalBalanceTally
Float:No
Scroll:Vertical
Common Border:Yes

[Line:LedOutStanding]
FieldROUTLine,InvDate,OInvNo,OInvCustomerName,OInvAmount,DROUTListPDATally,DROUTListFinalBalanceTally,DROUTListBillDueDate ;;DROUTList030Tally,DROUTList3060Tally,DROUTList6090Tally,DROUTList90120Tally,,DROUTListM120Tally
Space Top:1 mms
Remove if : #DROUTListBillDueDate > $$MachineDate

[FieldROUTLine]
Use:Number Field
Set as:$$Line
Width:10 mms
Skip:Yes
Style:Normal

[Field:InvDate]
Use:Short Date Field
Set as:$BillDate
Width:20 mms
Style:Normal
Skip:Yes
Align:Right

[Field:OInvNo]
Set as:$Name
Width:20 mms
Style:Normal
Align:Right
Skip:Yes

[Field:OInvCustomerName]
Set as:$DSPAccName:Ledger:$Parent
Width:35 mms
Style:Normal
Align:Right
Skip:Yes

[Field:OInvAmount]
Use:Amount Field
Set as:$BillAmt
Width:25 mms
Align:Right
Skip:Yes
Style:Normal
;Border:Thin Right

[FieldROUTListPDATally]
Use:Amount Field
Set as:$$AmountSubtract:$FinalBalance:$OpeningBalance
Align:Right
Style:Normal
Width:25 mms
Skip:Yes
;Border:Thin Right

[FieldROUTListFinalBalanceTally]
Use:Amount Field
Set as:$FinalBalance
Align:Right
Style:Normal
Width:25 mms
Skip:Yes

[FieldROUTListBillDueDate]
Use:Short Date field
Set as : @@CreditPeriod
Invisible:Yes



[Collection:MyLedg Outstanding]
Type : Bills
Cleared : No
Filter:ABSNP


Compute : PartyName : $$FuncDSPAccName:$Parent
Compute : BillAmt: $OpeningBalance ;$ClosingBalance
Compute : MyDate:$LedgerEntries.LedgerEntries.BillAllocations.BillDate
;Filter : MyLedg

Fetch : LedgerEntries.LedgerEntries.BillAllocations.Amount
Fetch : LedgerEntries.CurLangVoucherTypeName,ClosingBalance
Sort : @@Default : $BillDate, $Parent
Fetch : LedgerEntries.LedgerEntries.BankAllocations.InstrumentDate,BillDate

;Filter:ABSNP

[LineR OutListTotal]

Use:LedOutStanding
Local : Field : Default :Style : Normal Bold
Local : Field : Default : Align : Right
Local : Field : Default : Type : String
Local : Field : DROUTLine : Set As : ""
Local : Field : InvDate : Set As : ""
Local : Field : OInvNo : Set As : "Total"
Local : Field : OInvAmount: Set As :$$Total:OInvAmount
Local : Field : DROUTList030Tally: Set As :$$TotalROUTList030Tally
Local : Field : DROUTList3060Tally: Set As :$$TotalROUTList3060Tally
Local : Field : DROUTList6090Tally: Set As :$$TotalROUTList6090Tally
Local : Field : DROUTList90120Tally: Set As : $$TotalROUTList90120Tally
Local : Field : DROUTListM120Tally: Set As : $$TotalROUTListM120Tally
Local : Field : DROUTListPDATally: Set As : $$TotalROUTListPDATally
Local : Field : DROUTListFinalBalanceTally: Set As : $$TotalROUTListFinalBalanceTally

Border:Thin Top

[System : Formula]

;ABSNP:$$FuncDSPAccName:$Parent = "Trade Debtors"
ABSNP : $$FuncDSPAccName:$Parent:#OInvCustomerName Contains "Trade Debtors"



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

 

I Try Not working.
How to Find a Ledger Budget Value.?

 

Its working fine now .Thank you very much for spending your time and give me a reply

 

hi can u shre updated code plzzzzz