FETCH FROM TAX ANALYSIS

Discussion in 'Free Source Codes' started by GOINDI1311, Nov 19, 2022.

    
  1. GOINDI1311

    GOINDI1311 Member


    Respected Experts

    Please help me to fetch the value of Taxable purchase and cgst sgst value from taxanalysis form
    my report is as below

    upload_2022-11-19_15-54-14.png

    WANT TO FETCH DATA
    upload_2022-11-19_15-55-11.png
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Compute in your Collection...........
    Compute : MyIGSTAmt : $$FilterAmtTotal:LedgerEntries:MyIGSTCond:$Amount ... do same for CGST and SGST

    [System : formula]
    MyIGSTCond : $GSTDutyHead:Ledger:$LedgerName = $$SysName:IGST
     
    GOINDI1311 likes this.


  3. GOINDI1311

    GOINDI1311 Member


    THANK YOU SIR FOR, YOU ALWAY HELPS ME FOR MY PROBLEMS
     


  4. GOINDI1311

    GOINDI1311 Member


    Respect sir please, i count not fetch the taxable indirect expenses

    [Field: PK TAXABLE]

    Use: Amount Field
    Set as: $$CollAmtTotal:LedgerEntries:$Amount
    Set Always: Yes
    Border : Thin left
    Border : Thin box
    Width : 2.5 CM
    upload_2022-11-21_15-2-2.png

    pls help to fetch expenses and fixed asset value
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Depends on how you have defined the collection........ show here
     
    GOINDI1311 likes this.


  6. GOINDI1311

    GOINDI1311 Member


    [Part: ITC CLAIM REPORT]

    Lines : ITC CLAIM REPORT Title, ITC CLAIM REPORT Details

    Repeat : ITC CLAIM REPORT Details : CompanyPurchaseVouchers
    Common Borders : Yes
    Scroll : Both


    [Line: ITC CLAIM REPORT Title]

    Use : ITC CLAIM REPORT Details

    Local : Field : Default : Type : String
    Local : Field : Default : Align : Centre
    Local : Field : Default : Style : Normal Bold


    Local : Field : PK TAXABLE : Set as: "Taxable"




    [Line: ITC CLAIM REPORT Details]

    Fields : PK TAXABLE

    [Field: PK TAXABLE]

    Use: Amount Field
    Set as: $$CollAmtTotal:LedgerEntries:$Amount
    Set Always: Yes
    Border : Thin left
    Border : Thin box
    Width : 2.5 CM
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You have missed my query or not red it properly....... where is the COLLECTION??

    And secondly, if the fixed asset / indirect expense ledger defined properly??
     
    GOINDI1311 likes this.


  8. GOINDI1311

    GOINDI1311 Member


    Respected sir I m Stucking in this Field

    [Field: PK TAXABLE]

    Use: Amount Field
    Set as: $$CollAmtTotal:LedgerEntries:$Amount
    Set Always: Yes
    Border : Thin left
    Border : Thin box
    Width : 2.5 CM


    Trying to Fetch Taxable Value of(Purchase+IndirectEXp+FixedAssest Value)
    I am not able collect these values in above said field

    my report collection is as follows

    [Collection: Mycollection]
    Type:ledger entry:voucher
    Fetch: ledger name
    Filter : yourfilter

    Compute : Compute : MyIGSTAmt : $$FilterAmtTotal:LedgerEntries:MyIGSTCond:$Amount

    [system : formula]
    yourfilter : $$IsPurchase:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName

    MyIGSTCond : $GSTDutyHead:Ledger:$LedgerName = $$SysName:IGST
    MyCGSTCond : $GSTDutyHead:Ledger:$LedgerName = $$SysName:CGST
    MySGSTCond : $GSTDutyHead:Ledger:$LedgerName = $$SysName:SGST

    I am trying to Fetch debit note negative values in report

    Please help


    upload_2022-11-23_16-23-18.png
     
    Last edited: Nov 23, 2022


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do not understand your query / requirement in consonance with your code and the screenshot ...........

    try this.............
    [Collection: Mycollection]
    Type :voucher
    Fetch: name, ledgername
    Filter : yourfilter
     


Share This Page