How to Fetch total invoice value,taxable value,cgst amt,sgstamt,igstamt

Discussion in 'Free Source Codes' started by Neeru, Mar 8, 2020.

    
  1. NSA

    NSA Member


    [Field : RCP ParticularFld]

    Use : Name Field
    Set as : $FirstContraAcc
    SetbyCondition : ##RCPCondition1:$$RCPVoucherwalkFunc
    Set Always : Yes
    FullWidth : Yes
    Style : Small

    [System: formula]
    RCPCondition1 :$FirstContraAcc:parent: $$IsBelongsTo:$$GroupSales


    Sir,
    Can you please guide me to set a system formula for the condition?

    I need $FirstContraAcc if it is not a sales account, Else I need ##RCPVoucherwalkFunc. Is there any way I can set condition like that?
     


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Set As: If $Parent:Ledger:$FirstContraAcc = "Sales Accounts" then RCPVoucherwalkFunc Else $FirstContraAcc

    This is your Solution But Try To understand
     


  3. subash pal

    subash pal Member


    Dear experts

    Please help for fetch data for customer summary Report as per Following conditions
    If sales Voucher contain income ledger & other duties for example (Tax Exempted Means Vat is Not added in bill as per Nepal Income Tax Act)
    Item qty Rate Amt
    LED TV 1 16000 16000

    Excise Duty@10% 1600
    Discount@2.5% 400
    Packaging Forwarding 800
    Taxable 18000
    Vat@13% 2340
    Total Amount 20340

    Now how can we fetch Tax Exempted , Taxable, Tax(VAT), Total In customer summary reports
    I am try for this but not able to fetch summary data Please help......... thanks in advance
     



  4. Taxable value is not correct
     


  5. subash pal

    subash pal Member


    @@santosh shrestha Taxable value is 100% right, there is not any mistake, and I am completed customer summary previous year, Thanks for comment
     


Share This Page