i want formula to calculate grand (total / qty) of sales invoice

Discussion in 'Free Source Codes' started by bikash agarwal, Oct 2, 2023.

    

  1. grand total is final amount including taxes
    quantity of bill

    code is >>>>


    [System: Formula]

    JPAMT: $$FilterAmtTotal:LedgerEntries:sGSTSKR:$Amount
    SGSTSKR :$Name:Ledger:$LedgerName Contains $$LocaleString:"Sales"

    qtyGST:$$CollAmtTotal:inventoryentries:$Billedqty;$$vchbilledqty;$billedqty

    avggAMOUNT: @@JPAMT / @@qtyGST
     


  2. parthiban.M

    parthiban.M Member


    change $$CollAmtTotal as $$CollQtyTotal
     



  3. [System: Formula]

    JPAMT: $$FilterAmtTotal:LedgerEntries:sGSTSKR:$Amount
    SGSTSKR :$Name:Ledger:$LedgerName Contains $$LocaleString:"Sales"

    qtyGST:$$CollQtyTotal:inventoryentries:$Billedqty;$$vchbilledqty;$billedqty

    avggAMOUNT: @@JPAMT / @@qtyGST



    not working :(:(
     


  4. parthiban.M

    parthiban.M Member


    try as qtygst:$$total:(yourfieldname)...and add in ur repeat line as total:(yourfieldname)
     


Share This Page