add tax field in invoice total

Discussion in 'Requests' started by NainaSiraj, Apr 19, 2020.

    
  1. NainaSiraj

    NainaSiraj Member


    kindly help me to showing these fields in simple printed invoice total
    see file plzzzz
     

    Attached Files:



  2. NainaSiraj

    NainaSiraj Member


    kindly provide help
     


  3. NainaSiraj

    NainaSiraj Member


    [Part:expsmp invTotal]
    Line:SJ00,Sjj00

    [line:SJ00]
    left Field:Name Field:sjj0001
    Right Field:Name Field:sjj0002

    [Field:sjj0001]
    Use:Name Field
    Set as:ADD surcharge
    Align:center

    Style:Normal Bold


    [Field:sjj0002]
    Use:Name Field
    Set as: this should be 10% of Inv Amount
    Align:center
    Style:Normal Bold



    [line:SJJ00]
    left Field:Name Field:sjj00010
    Right Field:Name Field:sjj00020

    [Field:sjj00010]
    Use:Name Field
    Set as:Net Invoice
    Align:center
    Style:Normal Bold


    [Field:sjj00020]
    Use:Name Field
    Set as: this should be 10% of Inv Amount+inv Amount=net inv amount
    Align:center
    Style:Normal Bold
     


  4. NainaSiraj

    NainaSiraj Member


    kinldy see how i can make correction please
     


  5. NainaSiraj

    NainaSiraj Member


    PLEASE GUIDE ME
     


  6. NainaSiraj

    NainaSiraj Member


    GOOD EVENING
    I PREPARE A CODE WITH THE HELP OF A MEMBER FREELANCEE
    KINDLY GUIDE ME HOW CAN I SET FORMULAE IN RED MARK SENTENCE





    [#Form : Simple Printed Invoice]

    Add : Bottom Part : After : EXPSMP totals : EXPSMPTotalAmout
    Local : Part :EXPSMP totals: Invisible : no

    [Part : EXPSMPTotalAmout]

    Line : EXPSMPTotalArrears,EXPSMPTotalAmout, EXPSMPTotalTaxAmout, EXPSMPTotalInvAmout
    Border : Thin Top

    [Line : EXPSMPTotalArrears]

    Right Field : Medium Prompt, Name Field
    Local : Field : Medium PrompT : Info : "Arrears"
    Local : Field : Name Field : Set as : HOW TO SET AS ?????
    local:Field:Medium Prompt:Format : "DrCr"
    Local : Field : Name Field : Align : Right
    Local : Field : Medium Prompt : Border : Thin Left
    Local : Field : Name Field : Border : Thin Right
    [Line : EXPSMPTotalAmout]

    Right Field : Medium Prompt, Name Field
    Local : Field : Medium PrompT : Info : "Pay within Due Date"
    Local : Field : Name Field : Set as : $$AsDrAmt:#EXPSMPPrevBal + #EXPSMPBillAmt THIS IS NOT WORKING
    local:Field:Medium Prompt:Format : "DrCr"

    Local : Field : Name Field : Align : Right
    Local : Field : Medium Prompt : Border : Thin Left
    Local : Field : Name Field : Border : Thin Right

    [Line : EXPSMPTotalTaxAmout]

    Right Field : Medium Prompt, Name Field
    Local : Field : Medium PrompT : Info : "Lp Surcharge"
    Local : Field : Name Field : Set as : $$AsDrAmt:#EXPSMPBillAmt*7% THIS IS ALSO NOT WORKING
    Local : Field : Name Field : Align : Right
    Local : Field : Name Field : Print fg:Blue
    Local : Field : Medium Prompt : Border : Thin Left
    Local : Field : Name Field : Border : Thin Right

    [Line : EXPSMPTotalInvAmout]

    Right Field : Medium Prompt, Name Field
    Local : Field : Medium PrompT : Info : "Payable After Due Date"
    Local : Field : Name Field : Set as : $$AsDrAmt:#EXPSMPPrevBal + #EXPSMPBillAmt + #EXPSMPBillAmt*7% THIS IS ALSO NOT WORKING
    local:Field:Medium Prompt:Format : "DrCr"
    Local : Field : Name Field : Align : Right
    Local : Field : Medium Prompt : Border : Thin Bottom Left
    Local : Field : Name Field : Border : Thin Bottom Right

    [System : Formulae]

    IsAMT : $Parent:Ledger:$LedgerName = $$GroupSales Or $Parent:Ledger:$LedgerName = $$GroupIndirectIncomes
    IsTaxAMT : $Parent:Ledger:$LedgerName = $$GroupDuties
     
    Rajsrisrimal likes this.


  7. NainaSiraj

    NainaSiraj Member


    kindlly see
    values are not fetching automatically
     

    Attached Files:



Share This Page