RATE INCLUSIVE TAX IN PURCHASE SCREEN

Discussion in 'Tally Developer' started by EXPRISHABH, Nov 20, 2017.

    
  1. EXPRISHABH

    EXPRISHABH New Member


    HELLO EXPERTS

    I NEED HELP IN CREATING THE THE RATE INCLUSIVE TAX AS IN SALE VOUCHER ITS BY DEFAULT FOR THE PURCHASE VOUCHER.

    KINDLY HELP
    .
    I HAVE CREATED BUT THE CODE IS NOT WORKING KINDLY CHECK THE BELOW CODE:

    ===============CODE=====================
    [#Line : EI ColumnOne]
    Option : Global EI ColumnOne

    [!Line: Global EI ColumnOne]
    Add : Right Fields : At Beginning : txrate

    [Field : txrate]
    Info : "TAX INCL RATE"
    Align : Centre
    Width : 15
    Style : Small bold

    [#Line : EI InvInfo]
    Option : Global EI InvInfo

    [#Line : CI InvInfo]
    Option : Global EI InvInfo

    [!Line: Global EI InvInfo]
    Add : Right Fields : At Beginning : TAZRATE

    [Field : TAZRATE]
    Align : Centre
    Width : 15

    Use : Rate Price Field
    Set as : If ($$InAlterMode AND NOT $$IsEmpty:$Rate AND (@@STKInclTax OR ##ICFGInclTax)) Then $$AlterInclusiveTaxValue:mad:@ExItemRate:mad:@STItemRate:mad:@VATItemRate:mad:@TCSItemRate:mad:@GSTItemRate:mad:@GSTItemQtyRate:mad:@ExItemMRPDutyValue:mad:@VATItemMRPDutyValue:mad:@ExItemQuantum Else +
    If $$NumFilledItems:BatchAllocations = 0 Then @MRPRateSetVal Else $$CollectionField:$InclusiveTaxValue:1:BatchAllocations

    Set By Condition : $$InAlterMode AND ((@@STKInclTax OR ##ICFGInclTax) AND $$IsEmpty:$Rate AND $$IsEmpty:$InclVATRate) : ""
    Set By Condition : $$InAlterMode AND (NOT $$IsEmpty:$Amount AND NOT $$IsEmpty:$Rate AND (@@STKInclTax OR ##ICFGInclTax) AND (@LocInclusiveRate!=$Rate)) : $$AlterInclusiveTaxValue:mad:@ExItemRate:mad:@STItemRate:mad:@VATItemRate:mad:@TCSItemRate:mad:@GSTItemRate:mad:@GSTItemQtyRate:mad:@ExItemMRPDutyValue:mad:@VATItemMRPDutyValue:mad:@ExItemQuantum

    Storage : InclusiveTaxValue
    MRPRateSetVal: If @@IsItemMRPEnabled Then $$ForexValue:mad:@StdVchRate Else @MRPValue

    MRPValue : If $$IsEnd:$StockItemName Then "" Else If +
    $$IsFieldEdited Then $InclusiveTaxValue Else +
    If NOT $$IsEmpty:$MRPRate Then $$Number:$MRPRate +
    Else If $$IsEmpty:mad:locPartyStateName OR $$IsSysName:mad:locPartyStateName Then $$GetEIStkItemMRP:$StockItemName:$Date Else +
    $$GetEIStkItemMRP:$StockItemName:$Date:mad:locPartyStateName

    locPartyStateName: If @@IsGSTOnAndAppl Then $$BaseOwner:$GSTVchPartyState Else $$BaseOwner:$VATPartyLedState
    LocInclusiveRate: $$InclusiveTaxValue:mad:@ExItemRate:mad:@STItemRate:mad:@VATItemRate:mad:@TCSItemRate:mad:@GSTItemRate:mad:@GSTItemQtyRate:mad:@ExItemMRPDutyValue:mad:@VATItemMRPDutyValue:mad:@ExItemQuantum

    Set Always : Yes
    Width : @@VCHGodownNameWidth
    Inactive : $$IsEnd:$StockItemName
    Invisible : @@InclTaxcfg
    HasBatchAllocation: (@@HasBatchWise OR $$IsMultiGodownOn OR $$IsTrackingOn OR @@IsOrdersOn OR @@IsStkCostTrackingON)
    Skip Forward : $$InAlterMode

    +++++++++===========END OF CODE+++++++++++++
     


  2. #AmitSingh

    #AmitSingh New Member


    Use Bellow Code,
    So you can easily get Inclusive Rate in Purchase Voucher
     

    Attached Files:

    auruem and mukeshb like this.


  3. vishal malde

    vishal malde New Member


    i am trying to use the above code given in text format but it is not loading and giving message file unable to load.
     


  4. auruem

    auruem Member


    ITS WORKING

    GREAT WORK.....
     


  5. suraj_kum

    suraj_kum New Member


    Sir,

    how to use this in delivery notes, credit / debit notes or sales order
     


  6. Punit

    Punit New Member


    I am Using it in TallyPrime 2.1 but its not calculating the value and just giving the same value
     


  7. sivam

    sivam Active Member


    [#System: Formula]

    SSInclRateVchs : @@IsPurchase
    SalesInvoiceMode : If @@SSInclRateVchs Then Yes Else (@@IsSalesVch AND $IsInvoice AND NOT ##SVAcctsInvoice)

    Just Try this. You can add All other Voucher Types Also
     


Share This Page