rate inclusive tax in delivery note and sales order

Discussion in 'General Discussions' started by suraj_kum, Sep 19, 2022 at 2:41 PM.

    
  1. suraj_kum

    suraj_kum New Member


    the bellow mentioned code works with purchase , debit note, credit note but doesn't work with delivery Note, receipt note, sales order, purchase order.

    can some one help me with this to make it work on Delivery Note, Receipt Note, Sales Order, Purchase Order

    [#Field: VCH RateIncl]

    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 @@IsGSTOnAppl 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

    [System: Formulae]
    ICFGInclTax : ##ICFGInclTax AND @@SalesInvoiceMode
    InclTaxcfg : NOT (@@ICFGInclTax AND (($$IsTCSOn AND @@IsIndian) OR @@IsExciseTraderOn OR @@IsIndianVAT OR @@IsKenyaVAT OR ($$IsServiceTaxOn AND (@@IsIndian OR @@IsMalaysia)) OR (@@IsGCCCountriesVATOn AND ##VARVchDate >= ##GVATApplicableDate) OR (@@IsGSTon AND (NOT $$IsEmpty:mad:@GSTApplDate AND ##VARVchDate >= @@GSTApplDate))))
    WOICFGInclTax : @@InvoiceInCreate AND NOT ##ICFGInclTax AND @@STKInclTax AND @@SalesInvoiceMode AND NOT $UseForPOSInvoice:VoucherType:$VoucherTypeName
    STKInclTax : $InclusiveTax:StockItem:$StockItemName
    SalesInvoiceMode: $$IsAccountingVch:$VoucherTypeName AND $IsInvoice AND NOT ##SVAcctsInvoice
     


Share This Page