Skip to Content
author's profile photo Former Member
Former Member

scenario Base Value + Packing + Excise + Freight + CST/VAT + Octroi + LBT


My scenario is as Base Value + Packing + Excise + Freight + CST/VAT + Octroi + LBT and Inventory cost will be Toatal value - Excise + LBT, I will provide the Example.

Base Value 100 P000

Packing 1 ZPK3

Excise (10.3) 10.4 (BEDECSSECESS) on 101 value

Freight 10 val 10 (FRD1)

Subtotal 121.40

CST 12.5 15.18 (JVCS on 121.40) but in TAXINN procedure it will calculate on before Freight means 111.40 but client required on after addition of freight 121.40, I have assigned this Condition (JVCS) as statistical and remove From and TO steps it gives calculation 15.23 but correct calculation is 15.175 i am not understanding why it comes 15.23.

Now i have to pass this (JVCS) condition value from Taxinn procedure to ZJRM00 procedure please guide me how to pass in ZJRM00. After that i will take subtotal of this means 121.40 + 15.18 = 136.58 now i will calculate on Octroi 5.5%

Subtotal 136.58

Octroi 5.5% 7.51 (JOCM on 136.58) in ZJRM00 procedure

Subtotal2 144.09

LBT 2% 2.88 (ZLBT on 144.09) in ZJRM00 procedure

Now Inventory cost will be

Subtotal 2 (144.09) + LBT ( 2.88) - Excise (10.40) = 136.57

Please guide me on this scenario in configuration.


Shital Deshpande

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 09, 2011 at 06:53 AM


    check following links

    some scenario is there also he got soled by putting subtotal-4 read it it may solved your problem

    [Pricing Calculation on subtotal value.;


    Kailas Ugale

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 06:28 AM


    In Condition - Accural tick mark in Control Data 2 plays a vital role. This is where you control whether it should be posted to inventory or separate account. Tick accurals if you want to inventrize and remove if you dont want to for the conditions you use in this procedure


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Please do not confuse yourself with you tax proccedure and pricing procedure.

      In pricing procedure you have a calculation procedure where in how to arrive at the net price.

      In tax procedure, you have a calculation of relevant taxes and how to account them.

      When you do GR, the inventory value is updated with the basic value+ taxes as per pricing procedure.

      the GR/IR value will be Basic price + taxes ot basic price-taxes

      If it basic price- taxes, then the basic price will be GR/IR and taxes will accrue in the relevant condition records which are assigned the relevant G/L accounts.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.