1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

how to do horizontal and vertical addition

Discussion in 'Free Source Codes' started by Rishi kumar, Jan 20, 2024.

    
  1. Rishi kumar

    Rishi kumar Member


    Dear expert .
    I have created a report in which last column is total . before total column three more columns.
    i want these three field value added and shown in total column and total column value vertical added .
    how is possible? i did but not succeeded.
    pls see attachment. what i want to say and what i want ,would be clear.

    coding :
    [Field:Awb Amount]
    Use: Amount Field
    Storage:AwbAmount
    ;; Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    Set as:$$Table:AwbAwbNo:$CAmount

    [Field:Awb Covid]
    Use: Amount Field
    Storage:AwbCovid
    ;;Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb FSC]
    Use: Amount Field
    Storage:AwbFSC
    ;;Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Field: AwbTotal ]
    Use: Amount Field
    Set as:#AwbAmount+#AwbCovid+#AwbFSC
    Storage:AwbTotal
    ;; Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo


    last total line; this is for vertical addition.

    [Line: Awb Total Line]
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    Local:Field:default:Skip:Yes
    Local:Field:Awb Sl:Set as:""
    Local:Field:Awb Sl:Format:"nozero"
    Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals"
    Local:Field: AwbAwbNo:Delete:Table
    Local:Field:AwbTotal:setas:$$total:AwbTotal

    pls advice

    thanks & Regards
    Rishi
     

    Attached Files:

    Last edited: Jan 20, 2024
    Rishi kumar, Jan 20, 2024
    #1


  2. vishnu joshi

    vishnu joshi Member


    Add Following Line in Repeated Line Part
    ;-------------
    Total : AwbTotal
     
    vishnu joshi, Jan 20, 2024
    #2


  3. Rajat Agarwal

    Rajat Agarwal Member


    Recheck your code....it requires collection in Total
    Have you make any collection in it?

    Also in this given code you have not given any UDF ....in storage If not share your code
     
    Rajat Agarwal, Jan 20, 2024
    #3


  4. Rishi kumar

    Rishi kumar Member


    This Is full code. I want to add value of these three field Value Awb Amount, Awb Covid, Awb FSC in Total field horizontal....


    [Form:Awb Details]
    Part: Form Subtitle, Awb Part
    Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of " + ":" + $PartyLedgerName
    Full Height:Yes
    Full Width:Yes

    [Part:Awb Part]
    Lines: Awb Title Line, Awb Details Line
    Bottom Line:Awb Total Line
    Repeat:Awb Details Line: Awb Details Coll
    Common Border:Yes
    Scroll:Vertical
    Float: No
    Border : Thin Box
    Total: Awb Total
    Break On: $$IsSysName:$AwbAwbNo

    [Line:Awb Title Line]
    Use:Awb Details Line
    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    ;;Local:Field:Default:Delete:Use
    ;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    ;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local : Field : Default : Type: String
    ;;Local : Field : Default : Style: Small Bold
    Local : Field : Default : Align: Centre
    Local : Field : Default : Skip : Yes
    Local: Field: Awb Sl:Set as:$$LocaleString:"SL.No"
    Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No."
    Local:Field:Awb Date: Set as:$$LocaleString:"Date"
    Local:Field:Awb Destination:Set as:$$LocaleString:"Destination"
    Local:Field:Awb Network:Set as:$$LocaleString:"Network"
    Local:Field:Awb Ds:Set as:$$LocaleString:"D/s"
    Local:Field:Awb Weight:Set as:$$LocaleString:"Weight"
    Local:Field:Awb Amount:Set as:$$LocaleString:"Amount"
    Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19"
    Local:Field:Awb FSC:Set as:$$LocaleString:"FSC"
    Local:Field:Awb Total:Set as:$$LocaleString:"Total"
    Border: Thin bottom

    [Line:Awb Details Line]
    ;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local: Field: Default: Align: Centre
    [Field:Awb Sl]
    Use: Number Field
    Set as:$$Line
    Width: 3
    ;;Style: Small
    Border : Thin Right
    Skip:Yes

    [Field:Awb Awb No]
    Use: Name Field
    Storage:AwbAwbNo
    Width:15
    Border: Thin Right
    Table: AWB List Coll, End of List
    Show Table:Always
    Set Always:Yes
    Unique:Yes

    [Field:Awb Date]
    Use: Name Field
    Storage:AwbDate
    ;;Style:Small
    Width:10
    Border:Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    Set as:$$Table:AwbAwbNo:$AWBILLDate

    [Field:Awb Destination]
    Use: Name Field
    Storage:AwbDestination
    ;;Style:Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    Set as:$$Table:AwbAwbNo:$Dest

    [Field: Awb Network]
    Use: Name Field
    Storage:AwbNetwork
    ;;Style:Small
    Border: Thin Right
    ;;Width:10
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb Ds]
    Use: Name Field
    Storage:AwbDs
    ;; Style:Small
    Border: Thin Right
    Width:10
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb Weight]
    Use: Name Field
    Storage:AwbWeight
    ;;Style:Small
    Border: Thin Right
    Width:10
    Inactive:$$IsEnd:$AwbAwbNo
    Set as:$$Table:AwbAwbNo:$Weight
    [Field:Awb Amount]
    Use: Amount Field
    Storage:AwbAmount
    ;; Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    Set as:$$Table:AwbAwbNo:$CAmount

    [Field:Awb Covid]
    Use: Amount Field
    Storage:AwbCovid
    ;;Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb FSC]
    Use: Amount Field
    Storage:AwbFSC
    ;;Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Field: AwbTotal ]
    Use: Amount Field
    Set as:#AwbAmount +#AwbCovid+#AwbFSC
    Storage:AwbTotal
    ;; Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Line: Awb Total Line]
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    Local:Field:default:Skip:Yes
    Local:Field:Awb Sl:Set as:""
    Local:Field:Awb Sl:Format:"nozero"
    Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals"
    Local:Field: AwbAwbNo:Delete:Table
    Local:Field:AwbTotal:setas:$$total:AwbTotal
    Local:Field: AwbFSC:Set as:""
    Local:Field: Awbcovid:Set as:""
    Local:Field: AwbAmount:Set as:""
    Local:Field: Awbweight:Set as:""
    Local:Field: Awb Ds:Set as:""
    Local:Field: AwbNetwork:Set as:""
    Local:Field: AwbDestination:Set as:""
    Local:Field: AwbDate:Set as:""
    Border:Thick Top



    [System: UDF]
    AwbAwbNo : String: 41002
    AwbTotal: Amount:31002
    AwbFSC: Amount:31003
    AwbCovid:Amount:31004
    AwbAmount:Amount:31006
    AwbWeight:String:31005
    AwbDs:String:31007
    AwbNetwork:String:31008
    AwbDestination:String:31009
    AwbDate:String:31011
    AwbDetailsColl:Aggregate:31012
     
    Rishi kumar, Jan 20, 2024
    #4


  5. Rajat Agarwal

    Rajat Agarwal Member


    Rishi Ji
    You have not sent me the whole code as it seems an error...pls send the tally data demo file and the actual code yo have made to recheck the issue...
     

    Attached Files:

    Rajat Agarwal, Jan 20, 2024
    #5


  6. Rishi kumar

    Rishi kumar Member


    full code:

    [#Menu:Gateway of tally]
    add: Item: before:mad:@locquit: Cust Awb Details: Alter:Awb Details


    [Report:Awb Details]
    Form:Awb Details
    Title: "Awb Details"
    Object: Company

    [Form:Awb Details]
    Part: Form Subtitle, Awb Part
    Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of "
    Full Height:Yes
    Full Width:Yes

    [Part:Awb Part]
    Lines: Awb Title Line, Awb Details Line
    Bottom Line:Awb Total Line
    Repeat:Awb Details Line: Awb Details Coll
    Common Border:Yes
    Scroll:Vertical
    Float: No
    Border : Thin Box
    Total: Awb Total
    Break On: $$empty:$AwbAwbNo

    [Line:Awb Title Line]
    Use:Awb Details Line
    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    ;;Local:Field:Default:Delete:Use
    ;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    ;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local : Field : Default : Type: String
    ;;Local : Field : Default : Style: Small Bold
    Local : Field : Default : Align: Centre
    Local : Field : Default : Skip : Yes
    Local: Field: Awb Sl:Set as:$$LocaleString:"SL.No"
    Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No."
    Local:Field:Awb Date: Set as:$$LocaleString:"Date"
    Local:Field:Awb Destination:Set as:$$LocaleString:"Destination"
    Local:Field:Awb Network:Set as:$$LocaleString:"Network"
    Local:Field:Awb Ds:Set as:$$LocaleString:"D/s"
    Local:Field:Awb Weight:Set as:$$LocaleString:"Weight"
    Local:Field:Awb Amount:Set as:$$LocaleString:"Amount"
    Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19"
    Local:Field:Awb FSC:Set as:$$LocaleString:"FSC"
    Local:Field:Awb Total:Set as:$$LocaleString:"Total"
    Border: Thin bottom

    [Line:Awb Details Line]
    ;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local: Field: Default: Align: Centre
    [Field:Awb Sl]
    Use: Number Field
    Set as:$$Line
    Width: 3
    ;;Style: Small
    Border : Thin Right
    Skip:Yes

    [Field:Awb Awb No]
    Use: Name Field
    Storage:AwbAwbNo
    Width:15
    Border: Thin Right
    ;;Table: AWB List Coll, End of List
    ;; Show Table:Always
    Set Always:Yes
    Unique:Yes

    [Field:Awb Date]
    Use: Name Field
    Storage:AwbDate
    ;;Style:Small
    Width:10
    Border:Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    ;; Set as:$$Table:AwbAwbNo:$AWBILLDate

    [Field:Awb Destination]
    Use: Name Field
    Storage:AwbDestination
    ;;Style:Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    ;;Set as:$$Table:AwbAwbNo:$Dest

    [Field: Awb Network]
    Use: Name Field
    Storage:AwbNetwork
    ;;Style:Small
    Border: Thin Right
    ;;Width:10
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb Ds]
    Use: Name Field
    Storage:AwbDs
    ;; Style:Small
    Border: Thin Right
    Width:10
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb Weight]
    Use: Name Field
    Storage:AwbWeight
    ;;Style:Small
    Border: Thin Right
    Width:10
    Inactive:$$IsEnd:$AwbAwbNo
    ;; Set as:$$Table:AwbAwbNo:$Weight

    [Field:Awb Amount]
    Use: Amount Field
    Storage:AwbAmount
    ;; Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo
    ;;Set as:$$Table:AwbAwbNo:$CAmount

    [Field:Awb Covid]
    Use: Amount Field
    Storage:AwbCovid
    ;;Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Field:Awb FSC]
    Use: Amount Field
    Storage:AwbFSC
    ;;Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Field: AwbTotal ]
    Use: Amount Field
    Set as:#AwbAmount +#AwbCovid+#AwbFSC ;;#AwbAmount+#AwbCovid+#AwbFSC
    Storage:AwbTotal
    ;; Style: Small
    Border: Thin Right
    Inactive:$$IsEnd:$AwbAwbNo

    [Line: Awb Total Line]
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    Local:Field:default:Skip:Yes
    Local:Field:Awb Sl:Set as:""
    Local:Field:Awb Sl:Format:"nozero"
    Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals"
    Local:Field: AwbAwbNo:Delete:Table
    Local:Field:AwbTotal:setas:$$total:AwbTotal
    Local:Field: AwbFSC:Set as:""
    Local:Field: Awbcovid:Set as:""
    Local:Field: AwbAmount:Set as:""
    Local:Field: Awbweight:Set as:""
    Local:Field: Awb Ds:Set as:""
    Local:Field: AwbNetwork:Set as:""
    Local:Field: AwbDestination:Set as:""
    Local:Field: AwbDate:Set as:""
    Border:Thick Top



    [System: UDF]
    AwbAwbNo : String: 41002
    AwbTotal: Amount:31002
    AwbFSC: Amount:31003
    AwbCovid:Amount:31004
    AwbAmount:Amount:31006
    AwbWeight:String:31005
    AwbDs:String:31007
    AwbNetwork:String:31008
    AwbDestination:String:31009
    AwbDate:String:31011
    AwbDetailsColl:Aggregate:31012

    now check , enter data manually....
     
    Rishi kumar, Jan 20, 2024
    #6


  7. Rajat Agarwal

    Rajat Agarwal Member


    Rishi Ji

    After saving the entries the total will automatically get correct. So not to worry just make a trial if any problem then let me know

    ((( I have Created a Button for party ledger name for your kind reference if you require to use it in your code so just make the coding accordingly to include party ledger by using Variables, Collections, or Explode Collections )))

    Below the code is correctly working....as per your requirement..



    [#Menu:Gateway of Tally]
    Add: Item: AWB Details: Alter:Awb Details

    [Report:Awb Details]
    Use:DSP Template
    Form:Awb Details
    Set:FilterPartyNameRishi
    Variable : SV Print Orientation : String
    Repeat: AWB Summary details
    Title: "Awb Details"
    Object: Company

    [Form:Awb Details]
    Button : PrintButton, ExportButton
    Button : ExplodeFlag,ChangePeriod,PartyFilterBtn
    Bottom Toolbar Buttons : EnterKeyPMWEXP,BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
    Set Always : SV Print Orientation : "Landscape"
    Part: Form Subtitle, AWBPeriod, Awb Part
    Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of "
    Local:Field:Default : Color:Leaf Green
    Full Width:Yes
    Background:Misty Rose

    [Part:AWBPeriod]
    Line : AwbPeriod

    [Line:AwbPeriod]
    Right Field : Name Field
    Left Field : Simple Field
    Local : Field : Name Field : Info : @@DSPDateStr
    Local : Field : Name Field : Width : 20
    Local : Field : Name Field : Align : Right
    Border : Thin Box
    Local : Field : Simple Field : Info: "AWB SUMMARY REPORT"
    Local : Field : Simple Field : Space Left:72
    Local : Field : Simple Field : Style : Normal Bold

    [Key: EnterKeyPMWEXP]
    Key : Enter
    Title : $$LocaleString:"Explode"
    Type : BottomToolBarBtn2
    Action : Explode

    [Button:partyFilterBtn]
    Key : F6
    Action : Execute : PartySUMMARYWise
    Title : Party Name
    Background:Goodwill3
    Color:Yellow

    [Report:partySUMMARYWise]
    Form : PartySUMMARYWise

    [Form:partySUMMARYWise]
    Part : PartySUMMARYWise
    Space Left : 2 mms
    Space Right : 2 mms

    [Part:partySUMMARYWise]
    Line : PartySUMMARYWise

    [Line:partySUMMARYWise]
    Field : Medium Prompt,PartyItemMonthSUMMARYWise
    Local : Field : Medium Prompt : Set as : "Select Party Name:"
    Space Bottom : 2 mms

    [Field:partyItemMonthSUMMARYWise]
    Table : Myfilterledger,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : FilterPartyNameRishi
    Modifies : FilterPartyNameRishi

    [Collection: Myfilterledger]
    Type: Ledger

    BelongsTo: Yes

    [Part:Awb Part]
    Lines: Awb Title Line, Awb Details Line
    Bottom Line:Awb Total Line
    Repeat:Awb Details Line: Awb Details Coll
    Common Border:Yes
    Scroll:Vertical
    Float: No
    Border : Thin Box
    Total: Awb Total
    Break On: $$IsSysName:$AwbAwbNo

    [Line:Awb Title Line]
    Use:Awb Details Line
    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    ;;Local:Field:Default:Delete:Use
    ;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    ;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local : Field : Default : Type: String
    ;;Local : Field : Default : Style: Small Bold
    Local : Field : Default : Align: Centre
    Local : Field : Default : Skip : Yes
    Local : Field : Default : Color:Goodwill3
    Local: Field: Awb Sl:Set as:$$LocaleString:"S.No"
    Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No."
    Local:Field:Awb Date: Set as:$$LocaleString:"Date"
    Local:Field:Awb Destination:Set as:$$LocaleString:"Destination"
    Local:Field:Awb Network:Set as:$$LocaleString:"Network"
    Local:Field:Awb Ds:Set as:$$LocaleString:"D/s"
    Local:Field:Awb Weight:Set as:$$LocaleString:"Weight"
    Local:Field:Awb Amount:Set as:$$LocaleString:"Amount"
    Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19"
    Local:Field:Awb FSC:Set as:$$LocaleString:"FSC"
    Local:Field:Awb Total:Set as:$$LocaleString:"Total"
    Border: Thin bottom

    [Line:Awb Details Line]
    ;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
    Local: Field: Default: Align: Centre
    Local : Field : Default : Color:Goodwill3

    [Field:Awb Sl]
    Use: Name Field
    Set as:$$Line
    Width: if $$inprintmode then 3 else 4
    ;;Style: Small
    Border : Thin Right
    Skip:Yes

    [Field:Awb Awb No]
    Use: Name Field
    Storage:AwbAwbNo
    Width:if $$inprintmode then 3 else 15
    Border: Thin Right
    ;;Table: AWB List Coll, End of List
    ;; Show Table:Always
    Set Always:Yes
    Unique:Yes

    [Field:Awb Date]
    Use: Uni Date Field
    Storage:AwbDate
    Set as : $Date
    Format : "full Date"
    ;;Style:Small
    Width:if $$inprintmode then 3 else 15
    Border:Thin Right
    ;Inactive:$$IsSysName:$AwbAwbNo
    ;; Set as:$$Table:AwbAwbNo:$AWBILLDate

    [Field:Awb Destination]
    Use: Name Field
    Storage:AwbDestination
    ;;Style:Small
    Width:if $$inprintmode then 3 else 15
    Border: Thin Right
    ;Inactive:$$IsSysName:$AwbAwbNo
    ;;Set as:$$Table:AwbAwbNo:$Dest

    [Field: Awb Network]
    Use: Name Field
    Storage:AwbNetwork
    ;;Style:Small
    Border: Thin Right
    Width:if $$inprintmode then 3 else 15
    ;Inactive:$$IsSysName:$AwbAwbNo

    [Field:Awb Ds]
    Use: Name Field
    Storage:AwbDs
    ;; Style:Small
    Border: Thin Right
    Width:if $$inprintmode then 3 else 15
    ;Inactive:$$IsSysName:$AwbAwbNo

    [Field:Awb Weight]
    Use: Number Field
    Storage:AwbWeight
    Format:Decimal:2
    ;;Style:Small
    Border: Thin Right
    Width:if $$inprintmode then 3 else 15
    ;Inactive:$$IsSysName:$AwbAwbNo
    ;; Set as:$$Table:AwbAwbNo:$Weight

    [Field:Awb Amount]
    Use: Number Field
    Storage:AwbAmount
    ;; Style: Small
    Set as:$Amount
    Format:Decimal:2
    Width:if $$inprintmode then 3 else 15
    Border: Thin Right
    ;Inactive:$$IsSysName:$AwbAwbNo
    ;;Set as:$$Table:AwbAwbNo:$CAmount

    [Field:Awb Covid]
    Use: Number Field
    Storage:AwbCovid
    Format:Decimal:2
    Width:if $$inprintmode then 3 else 15
    ;;Style: Small
    Border: Thin Right
    ;Inactive:$$IsSysName:$AwbAwbNo

    [Field:Awb FSC]
    Use: Number Field
    Storage:AwbFSC
    Width:if $$inprintmode then 3 else 15
    Format:Decimal:2
    ;;Style: Small
    Border: Thin Right
    ;Inactive:$$IsSysName:$AwbAwbNo

    [Field: AwbTotal]
    Use: Number Field
    Set as:#AwbAmount + #AwbCovid + #AwbFSC ;;#AwbAmount+#AwbCovid+#AwbFSC
    Storage:AVbTotal
    Format:Decimal:2
    Width:if $$inprintmode then 3 else 15
    Set Always:Yes
    ;; Style: Small
    Border: Thin Right
    ;Inactive:$$IsSysName:$AwbAwbNo
    Skip:Yes

    [Line: Awb Total Line]
    Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
    Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total

    Local:Field:Default:Delete:Storage
    Local:Field:Default:Delete:Set as
    Local:Field:Default:Delete:Inactive
    Local:Field:Default:Skip:Yes
    Local:Field:Default:Align:Center

    Local: Field:Awb Sl:Set as:""
    Local:Field:Awb Awb No :Set as:"Net Total"
    Local:Field:Awb Date: Set as:""
    Local:Field:Awb Destination:Set as:""
    Local:Field:Awb Network:Set as:""
    Local:Field:Awb Ds:Set as:""
    Local:Field:Awb Weight:Set as:""
    Local:Field:Awb Amount:Set as:""
    Local:Field:Awb Covid:Set as:""
    Local:Field:Awb FSC:Set as:""
    Local:Field:Awb Total:Set as:$$Total:Awbtotal
    Border:Totals



    [System: UDF]
    AwbAwbNo : String: 2697
    AwbDestination:String:3187
    AwbNetwork:String:3177
    AwbDs:String:3136
    AwbWeight:Number:3144
    AwbAmount:Number:3587
    AwbCovid:Number:5569
    AwbFSC: Number:7897
    AwbTotal: Number:7789
    AwbDate:Date:3109
    AwbDetailsColl:Aggregate:3191

    [Color:Goodwill3]
    RGB:175,0,0

    [Color:Misty Rose]
    RGB:255,228,225

    [Variable: AWB Summary Details]
    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable:FilterPartyNameRishi]
    Type : String


    ;;;;;; if you want to use the party ledger list use coding on your own or by using these below coding...

    /*

    [Part:pMWEXPExplode]
    Line : PMWEXPExplode
    Repeat : PMWEXPExplode:pMWEXPPartyExplode
    Border : Thin Bottom

    [Line:pMWEXPExplode]
    Use : PMWEXPDetails
    Delete : Border
    Local : Field : PMWEXPSno : Set as : "" ;$$Line
    Local : Field : Default : Style : Normal
    Local : Field : Default : Color : red
    Local : Field : PMWEXPPartyNameHarryExpPMWEXP : Set as : $ItemNameHarry
    Local : Field : PMWEXPPartyNameHarryExpPMWEXP : Align : Justified
    Local : Field : PMWEXPAprQty : Set as : $itemQtyAprPMWEXP
    Local : Field : PMWEXPMayQty : Set as : $itemQtyMayPMWEXP
    Local : Field : PMWEXPQtyJunPMWEXP : Set as : $ItemQtyJunPMWEXP
    Local : Field : PMWEXPJulQty : Set as :$ItemQtyJulPMWEXP
    Local : Field : PMWEXPAugQty : Set as : $ItemQtyAugPMWEXP
    Local : Field : PMWEXPSepQty : Set as :$ItemQtySepPMWEXP
    Local : Field : PMWEXPOctQty : Set as : $ItemPMWEXPOctQty
    Local : Field : PMWEXPnovQty : Set as : $ItemPMWEXPnovQty
    Local : Field : PMWEXPdecQty : Set as : $ItemPMWEXPdecQty
    Local : Field : PMWEXPjanQty : Set as : $ItemPMWEXPjanQty
    Local : Field : PMWEXPfebQty : Set as :$ItemPMWEXPfebQty
    Local : Field : PMWEXPmarQty : Set as : $ItemPMWEXPmarQty
    Local : Field : PMWEXPTotal : Set as : $itemPMWEXPTotalQty

    [Collection:pMWEXPPartyWise]
    Source Collection : PMWEXP Voucher
    Walk : ledger Entries
    By : PartyNameHarryExpPMWEXP : $LedgerName
    Aggr Compute: QtyAprPMWEXP : Sum :If @@PMWEXPmonthFilterapr Then $Amount Else 0
    Aggr Compute: QtyMayPMWEXP : Sum :If @@PMWEXPmonthFiltermay Then $Amount Else 0
    Aggr Compute : QtyJunPMWEXP : Sum :If @@PMWEXPmonthFilterjun Then $Amount Else 0
    Aggr Compute : QtyJulPMWEXP : Sum :If @@PMWEXPmonthFilterjul Then $Amount Else 0
    Aggr Compute : QtyAugPMWEXP : Sum :If @@PMWEXPmonthFilteraug Then $Amount Else 0
    Aggr Compute : QtySepPMWEXP : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltersep Then $Amount Else 0
    Aggr Compute : PMWEXPOctQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilteroct Then $Amount Else 0
    Aggr Compute : PMWEXPnovQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilternov Then $Amount Else 0
    Aggr Compute : PMWEXPdecQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterdec Then $Amount Else 0
    Aggr Compute : PMWEXPjanQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterjan Then $Amount Else 0
    Aggr Compute : PMWEXPfebQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterfeb Then $Amount Else 0
    Aggr Compute : PMWEXPmarQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltermar Then $Amount Else 0
    Aggr Compute : TotAmount : Sum : If @@VoucherFilterExpPMWEXP Then $Amount Else 0
    Sort : Default : $PartyNameHarryExpPMWEXP
    Filter : iexpPMWEXP

    [Collection:pMWEXPPartyExplode]
    Source Collection : PMWEXP Voucher
    Walk : ledger Entries
    By : PartyNameHarryExpPMWEXP : $LedgerName
    By : ItemNameHarry : $vouchernumber
    Aggr Compute : itemQtyAprPMWEXP : Sum :If @@PMWEXPmonthFilterapr Then $Amount Else 0
    Aggr Compute : itemQtyMayPMWEXP : Sum :If @@PMWEXPmonthFiltermay Then $Amount Else 0
    Aggr Compute : itemQtyJunPMWEXP : Sum :If @@PMWEXPmonthFilterjun Then $Amount Else 0
    Aggr Compute : itemQtyJulPMWEXP : Sum :If @@PMWEXPmonthFilterjul Then $Amount Else 0
    Aggr Compute : itemQtyAugPMWEXP : Sum :If @@PMWEXPmonthFilteraug Then $Amount Else 0
    Aggr Compute : itemQtySepPMWEXP : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltersep Then $Amount Else 0
    Aggr Compute : itemPMWEXPOctQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilteroct Then $Amount Else 0
    Aggr Compute : itemPMWEXPnovQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilternov Then $Amount Else 0
    Aggr Compute : itemPMWEXPdecQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterdec Then $Amount Else 0
    Aggr Compute : itemPMWEXPjanQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterjan Then $Amount Else 0
    Aggr Compute : itemPMWEXPfebQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFilterfeb Then $Amount Else 0
    Aggr Compute : itemPMWEXPmarQty : Sum :If @@VoucherFilterExpPMWEXP and @@PMWEXPmonthFiltermar Then $Amount Else 0
    Aggr Compute : itemPMWEXPTotalQty : Sum : If @@VoucherFilterExpPMWEXP Then $Amount Else 0
    Filter : PMWEXPExplodeFilter
    Sort : Default : $ItemNameHarry

    [System : Formula]
    iexpPMWEXP : $$IsLedOfGrp:$PartyNameHarryExpPMWEXP:$$GroupDirectExpenses or $$IsLedOfGrp:$PartyNameHarryExpPMWEXP:$$GroupIndirectExpenses
    iexpPMWEXPl : $$IsLedOfGrp:$name:$$GroupIndirectExpenses or $$IsLedOfGrp:$name:$$GroupIndirectExpenses
    VoucherFilterExpPMWEXP : $$IsPayment:$VoucherTypeName or $$IsJournal:$VoucherTypeName or $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName
    PMWEXPmonthFilterapr : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4
    PMWEXPmonthFiltermay : $$MonthOfDate:$Date>=5 and $$MonthOfDate:$Date<=5
    PMWEXPmonthFilterjun : $$MonthOfDate:$Date>=6 and $$MonthOfDate:$Date<=6
    PMWEXPmonthFilterjul : $$MonthOfDate:$Date>=7 and $$MonthOfDate:$Date<=7
    PMWEXPmonthFilteraug : $$MonthOfDate:$Date>=8 and $$MonthOfDate:$Date<=8
    PMWEXPmonthFiltersep : $$MonthOfDate:$Date>=9 and $$MonthOfDate:$Date<=9
    PMWEXPmonthFilteroct : $$MonthOfDate:$Date>=10 and $$MonthOfDate:$Date<=10
    PMWEXPmonthFilternov : $$MonthOfDate:$Date>=11 and $$MonthOfDate:$Date<=11
    PMWEXPmonthFilterdec : $$MonthOfDate:$Date>=12 and $$MonthOfDate:$Date<=12
    PMWEXPmonthFilterjan : $$MonthOfDate:$Date>=1 and $$MonthOfDate:$Date<=1
    PMWEXPmonthFilterfeb : $$MonthOfDate:$Date>=2 and $$MonthOfDate:$Date<=2
    PMWEXPmonthFiltermar : $$MonthOfDate:$Date>=3 and $$MonthOfDate:$Date<=3
     
    Rajat Agarwal, Jan 21, 2024
    #7


  8. Rishi kumar

    Rishi kumar Member


    Ok rajat Ji i check
    Thanks a lot
     
    Rishi kumar, Jan 21, 2024
    #8


Share This Page