including vat not working in erp release 6.1

Discussion in 'Requests' started by Vishesh, Aug 4, 2013.

    
  1. Vishesh

    Vishesh New Member


    Dear Experts
    The below code not working in Release 4.6 plz make changes

    ;Small code which allows Tax incl rate in Invoice
    ;*** need to put Vat rate in Item Master Creation - Enable - Tax Inclusive Rate from F11 - Accounting Features

    [#Part : CMP Acc Feat Right]
    Add : Line : CMP Final Rate
    [Line : CMP Final Rate]
    Fields : Long Prompt, Logical Field
    Local : Field : Long Prompt : Info : $$LocaleString:"Tax inclusive rates on Invoices ?"
    Local: Field : Logical Field : Storage: isFinalRateOn
    ;;Local : Field : Default: Tooltip: +
    Local : Field : Default: On : Focus : Yes : Set : SVERPFeatureDesc : +
    "This features allows a user to enter Tax Inclusive Rates while creation invoice. The module will automatically do the reverse calculation based on the defined Tax rates on item master."
    Space Top: 0.25
    [System : UDF]
    isFinalRateOn: Logical : 23
    [System : Formula]
    isFinalRateOn: $isFinalRateOn:Company:##SVCurrentCompany and @@isERPPlusModuleOn

    [#Line : VCH Batch Column One]
    add : option : My VCH Batch Column One : @@isSales and @@isFinalRateOn
    [#Line : VCH Batch Column Two]
    add : option : My VCH Batch Column Two : @@isSales and @@isFinalRateOn
    [!Line : My VCH Batch Columnone]
    Add : Right Field: Before : VCH RateTitle : MyFinalRateTitle
    [Field : My FinalRateTitle]
    Use: Name Field
    INfo: "Tax inc. Rate"
    Width: @@VCHRateWidth
    Lines: 2
    Style: Normal
    Align: Centre
    [!Line : My VCH Batch Columntwo]
    Add : Right Field : Before : VCH RateTitle : MyFinalRateTitle
    Local : Field : MyFinalRateTitle : Info : ""

    [#Line : STKVCH Batch2]
    Add : Option : MyStkvch Batch2 : @@isSales and @@isFinalRateOn
    [!Line : MystkVCH Batch2]
    Add : Right Field : Before : VCHBATCH Rate : MyFinalRate

    [Field: MyFinalRate]
    Use: Rate Price Field
    ;;Fetch Object: Stockitem: $StockitemName: RateOfVAT
    Storage: MyFinalRate
    Skip: $$Line > 1

    [system: UDF]
    MyFinalRate: Rate: 101
    MyFinalRate2: Rate : 102

    [#Field: VCHBATCH Rate]
    Add : Option : MyRate : @@isSales and @@isFinalRateOn
    [!Field : MyRate]
    Delete : Set as
    Delete: Set By Condition
    Add : Set By Condition : Yes : ($MyFinalRate *100 ) / (100 + $RateofVAT:Stockitem:$Stockitemname)

    [#Line : Ei ColumnOne]
    add : option : My VCH Batch Column One : @@isSales and @@isFinalRateOn
    [#Line : Ei ColumnTwo]
    add : option : My VCH Batch Column Two : @@isSales and @@isFinalRateOn

    [#Line : Ei InvInfo]
    Add : Option : My Ei Info : @@isSales and @@isFinalRateOn
    [#Line : Ci InvInfo]
    Add : Option : My Ei Info : @@isSales and @@isFinalRateOn
    [!Line : My ei info]
    Add : Right Field : Before : VCH Rate : MyFinalRate2
    [Field : MyFinalRate2]
    Use: Rate Price Field
    Width: @@VCHRateWidth
    Storage : MyFinalRate2
    ;;Set as: $$CollectionField:$MyFinalRate:1:BatchAllocations
    Set always: Yes
    inactive: $$isEnd:$Stockitemname
    Skip on: @@hasinvsuballoc AND NOT @@isPOSInvoice
    Setval : if @@HasInvSubAlloc then $$CollectionField:$MyFinalRate:1:BatchAllocations else +
    if $BilledQty = 0 then 0 else +
    if $$IsValidPriceLevel:$PriceLevel then $$ForexValue:mad:@StdVchRate else +
    if $StockItemName != #VCHPrevItem AND NOT $$IsStartupValue then $$ForexValue:mad:@StdVchRate else +
    if ($Amount != 0) AND ($Amount != @@CalcedAmt) then @@NrmlAmount / $BilledQty else +
    if $$IsFieldEdited OR $$InAlterMode then $$Value else +
    if $$IsEmpty:$$Value then $$ForexValue:mad:@StdVchRate else $$Value

    Set as : If #VCHBilledQty = 0 OR #VCHBilledQty != 0 then @Setval else @Setval


    [#Field: VCH NrmlRate]
    Add : Option : MyRate2 : @@isSales and @@isFinalRateOn
    [#Field: VCH POS Rate]
    Add : Option : MyRate2 : @@isSales and @@isFinalRateOn
    [!Field : MyRate2]
    Delete : Set as
    Add : Set as : ($MyFinalRate2 *100 ) / (100 + $RateofVAT:Stockitem:$Stockitemname)
     


  2. Nirav Merchant

    Nirav Merchant Active Member


    [System : Formula]isFinalRateOn: $isFinalRateOn:Company:##SVCurrentCompany and @@isERPPlusModuleOn
    Hi kindly remove word from and in the sysrem formula shd work than"
     


  3. Nirav Merchant

    Nirav Merchant Active Member


    Kindly remove this from system formula "and @@isERPPlusModuleOn"
     


  4. Vishesh

    Vishesh New Member


    thanks sir..
    its working now.:)
     


  5. kamal

    kamal Member


    Dear sir,
    this option is working but when connecting through Remote id its not calculating rate.
     


Share This Page