Few lines are missing Here.
Pls Watch the full video to get full coding.
[Line:DR OutList]
Fields:DROUTLineTally,InvDateTally,OInvNoTally,OInvCustomerNameTally,OInvAmountTally,DROUTListPDA,DROUTListFinalBalance ;,DROUTList030,DROUTList3060,DROUTList6090,DROUTList90120,DROUTListM120,
Border:Thin Bottom
[Field:DROUTLineTally]
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:Left
Skip:Yes
[Field:OInvAmountTally]
Use:Name Field
Set as:"INV Amt"
Width:25 mms
Align:Right
Skip:Yes
Border:Thin Right
[Field:DROUTList030]
Use:Name Field
Set as:"0 - 30"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes
[Field:DROUTList3060]
Use:Name Field
Set as:"30 - 60"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes
[Field:DROUTList6090]
Use:Name Field
Set as:"60 - 90"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes
[Field:DROUTList90120]
Use:Name Field
Set as:"90 - 120"
Width:25 mms
Border:Thin Right
Align:Right
Skip:Yes
[Field:DROUTListM120]
Use:Name Field
Set as:"120 - <"
Align:Right
Width:25 mms
Border:Thin Right
Skip:Yes
[Field:DROUTListPDA]
Use:Name Field
Set as:"PDC Amount"
Align:Right
Width:25 mms
Border:Thin Right
Skip:Yes
[Field:DROUTListFinalBalance]
Use:Name Field
Set as:"Final Balance"
Align:Right
Width:25 mms
Skip:Yes
[Field:DROUTList030Tally]
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
[Field:DROUTList3060Tally]
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
[Field:DROUTList6090Tally]
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
[Field:DROUTList90120Tally]
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
[Field:DROUTListM120Tally]
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
[#Form :SALES Color];; Add Print in SALES
Add : Print : ReorderPopUpOutstanding
Add : Button :ReorderPopUpOutstanding
[Button : ReorderPopUpOutstanding]
Action :print Report:ReorderPopUpOutstanding
Key :<Enter your Key>
[Report:ReorderPopUpOutstanding]
Form:ReorderPopUpOutstanding
[Form:ReorderPopUpOutstanding]
Use : DSP TEMPLATE
Parts:AMOutStandingDetails
[Part:AMOutStandingDetails]
Line:DR 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]
Field:DROUTLine,InvDate,OInvNo,OInvCustomerName,OInvAmount,DROUTListPDATally,DROUTListFinalBalanceTally,DROUTListBillDueDate ;;DROUTList030Tally,DROUTList3060Tally,DROUTList6090Tally,DROUTList90120Tally,,DROUTListM120Tally
Space Top:1 mms
Remove if : #DROUTListBillDueDate > $$MachineDate
[Field:DROUTLine]
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
[Field:DROUTListPDATally]
Use:Amount Field
Set as:$$AmountSubtract:$FinalBalance:$OpeningBalance
Align:Right
Style:Normal
Width:25 mms
Skip:Yes
;Border:Thin Right
[Field:DROUTListFinalBalanceTally]
Use:Amount Field
Set as:$FinalBalance
Align:Right
Style:Normal
Width:25 mms
Skip:Yes
[Field:DROUTListBillDueDate]
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
[Line:DR 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 :$$Total:DROUTList030Tally
Local : Field : DROUTList3060Tally: Set As :$$Total:DROUTList3060Tally
Local : Field : DROUTList6090Tally: Set As :$$Total:DROUTList6090Tally
Local : Field : DROUTList90120Tally: Set As : $$Total:DROUTList90120Tally
Local : Field : DROUTListM120Tally: Set As : $$Total:DROUTListM120Tally
Local : Field : DROUTListPDATally: Set As : $$Total:DROUTListPDATally
Local : Field : DROUTListFinalBalanceTally: Set As : $$Total:DROUTListFinalBalanceTally
Border:Thin Top
[System : Formula]
ABSNP : $$FuncDSPAccName:$Parent:##LedgerName Contains ""
.jpg)
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें