on 05-22-2010 7:25 AM
Hello...
Could you let me know how to create a condition type in MM pricing for below scenario:
Purchase value is 100 and VAT on it is 4% and afterwards there will be a purchase discount of lets say 25. So total value becomes 100+4-25 = 79. When goods are received inventory value should be 79 and during LIV vendor should be paid net purchase value i.e 75 and VAT 4 that is 79. Now when I am doing IV system is considering VAT amount 4% on net value that is 75 so it is coming as 3. But my requirement is to pull the data as in PO. I need to create a condition type for this instead of using cash discount or other options.
>
> Hello...
>
> Could you let me know how to create a condition type in MM pricing for below scenario:
>
> Purchase value is 100 and VAT on it is 4% and afterwards there will be a purchase discount of lets say 25. So total value becomes 100+4-25 = 79. When goods are received inventory value should be 79 and during LIV vendor should be paid net purchase value i.e 75 and VAT 4 that is 79. Now when I am doing IV system is considering VAT amount 4% on net value that is 75 so it is coming as 3. But my requirement is to pull the data as in PO. I need to create a condition type for this instead of using cash discount or other options.
Suppose Purchase value is STEP 1, VAT is Step 2, Gross value after VAT is STEP 3,Purchase discount is step 4, then net value, now besides from to field on VAT condition it should be STEp 1, meaning to calculate tax on step 1, then another total line should be made as STEP 3 e.g. Gross value after VAT, this line should have in from to field STEP 1 & 2, meaning total of step 1 and 2 is populated in this line, then besides from to field of Purchase discount you mention STEP 3, meaning discount to be calculated on total of Step 3, and finally in from to field of NET value you mention STEP 3 & 4, meaning amount in this line will be STEP 3 - Step 4.
and your requirement will be fulfilled.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> Hi
>
> Then in the case of MIRO system picks the step 4 price and on that it calculates the VAT. What I want is it should pick step 4 value and VAT should be on STEP1 (means purchase value).
> Do I need to do something in MIRO to have VAT calculated on purchase value(which excludes the discount).
MIRO picks up price of net value, with all conditions maintained displayed as line items as I recall.
It picks up amoounts as mentioned in PO.
Edited by: Afshad Irani on May 22, 2010 12:38 PM
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.