GST Rate issue

Discussion in 'Tally Integration' started by Sudhir83411, May 7, 2022.

    
  1. Sudhir83411

    Sudhir83411 New Member


    Dear All

    Some of the transaction not fetching GST Rate although they have GST Rate in the voucher

    Please check the below code

    [Collection: CompanyCollection]
    Type : Company
    Fetch : Name
    ;;....................................................................................................................................................................
    [Collection:VchPurchase]
    Type: Vouchers:VoucherType
    Child Of:$$VchTypePurchase
    Belongs To: Yes

    [Collection:VchDebitNote]
    Type: Vouchers:VoucherType
    Child Of:$$VchTypeDebitNote
    Belongs To: Yes

    [Collection:VchPayment]
    Type: Vouchers:VoucherType
    Child Of:$$VchTypePayment
    Belongs To: Yes

    [Collection:VchReceipt]
    Type: Vouchers:VoucherType
    Child Of:$$VchTypeReceipt
    Belongs To: Yes

    [Collection:VchJournal]
    Type: Vouchers:VoucherType
    Child Of:$$VchTypeJournal
    Belongs To: Yes

    [Collection: AccountsCCCollection]
    Source Collection : VchPurchase,VchDebitNote,VchPayment,VchReceipt,VchJournal
    Keep Source:NO
    Walk:AllLedgerEntries
    Fetch:GUID,Date,Reference,ReferenceDate,StateName,PartyGSTIN,PlaceOfSupply,VouchertypeName,VoucherNumber,ISDEEMEDPOSITIVE,PartyLedgerName,Amount,Gsttaxrate,Amount
    Compute :LedgerName:$LedgerName
    Compute :Amount:if $PartyLedgerName = $LedgerName then $Amount else 0
    Compute :StateName:$StateName:Company
    Compute :InputSGST:if $PartyLedgerName = $LedgerName then $$FilterAmtTotal:AllLedgerEntries:ISGST:$Amount else 0
    Compute :InputIGST:if $PartyLedgerName = $LedgerName then $$FilterAmtTotal:AllLedgerEntries:IIGST:$Amount else 0
    Compute :InputCGST:if $PartyLedgerName = $LedgerName then $$FilterAmtTotal:AllLedgerEntries:ICGST:$Amount else 0
    Compute :IsEligibleITC:$GSTInEligibleITC
    Compute :IsRevChargeAppl:$GSTIsRevChargeAppl
    Compute :GSTRate:$RATEDETAILS.GSTRATE


    [System:Formulae]
    OCGST :$LedgerName = "Output CGST"
    OSGST :$LedgerName = "Output SGST"
    OIGST :$LedgerName = "Output IGST"
    ICGST :$LedgerName = "Input CGST"
    ISGST :$LedgerName = "Input SGST"
    IIGST :$LedgerName = "Input IGST"
    [Collection: AACCollection]
    Collection:AccountsCCCollection:CompanyCollection
    ;;Select $CmpName,$GUID,$PGUID,$Date,$VouchertypeName,$VoucherNumber,$Gsttaxrate,$Reference,$ReferenceDate,$StateName,$PartyGSTIN,$PlaceOfSupply,$PartyLedgerName,LedgerName,$Amount,$InputCGST,$InputSGST,$InputIGST from AACCollection
     


Share This Page