Knowledge Management

Question:
This is with reference to Base Price which is inclusive of Excise
(Modvatable) and Sales Tax.
In pricing procedure I used subtotal to 6 for taxes, and routine 362
for TAXINJ. Back calculation of Base Price and Excise is working OK in
Purchase order. But when we do Goods Receipt, GR is done at Base Price
inclusive of taxes, though excise is picked up correctly in Excise
Invoice.
EXAMPLE:
PB00 Base Price Rs.100 (inclusive of Exc. and Sales Tax)
System back calculates
Base price as 83.15
Excise as 13
Sales Tax as 3.85
Which is ok and shown on Tab Page of Tax Details. But in condition Tab
net Price is still shown as 100.
At the time of GR it is done at 103.85 (which is wrong)and Excise
invoice is captured at 13 (which is correct).
Is there any other standard routine which can be used for transfering
this 83.15 as Net Price to GR.
We are working on 4.7 Enterprise version
Thanks and Regards,
Anuj Agarwal,
Answer:
I face the same problem when we Implemented 4.7 at Pinnacle/Bajaj. After going through the routines of CIN we found that subtotal 6 is the culprit in the whole scenarion and it is loading taxes twice during goods receipt.
Solutions
For calculating the reverse basic price you must have defined few conditions and routines to calulate the factor and the tax inclusive in the price. To derive at the Net basic price you might have use this subtotal 6 and must be deriving at the net basic price.( Gross condition - tax condition ) - Don apply this method for deriving the net basic price.
use this.
define the tax condition to negative and change the routine ( multiply by -1) . ( you can also copy this condition from discount condition - R000 ) In this way you will be able to avoid subtotal 6 and will also be able to derive the net price exclusive of taxes .In front of net basic price ( gross condition - tax condition ) use subtotal 9 , Then net basic will be pass to the tax procedure - BUSB where on net basic taxes will be calculated.
After GR you will find all accounting entires will be correct.
If you find any Problem you can mail to me on following email id.
kiran.bhansali@accenture.com

Regards
Kiran
Answer:
This is with reference to Base Price which is inclusive of Excise
(Modvatable) and Sales Tax.
In pricing procedure I used subtotal to 6 for taxes, and routine 362
for TAXINJ. Back calculation of Base Price and Excise is working OK in
Purchase order. But when we do Goods Receipt, GR is done at Base Price
inclusive of taxes, though excise is picked up correctly in Excise
Invoice.
EXAMPLE:
PB00 Base Price Rs.100 (inclusive of Exc. and Sales Tax)
System back calculates
Base price as 83.15
Excise as 13
Sales Tax as 3.85
Which is ok and shown on Tab Page of Tax Details. But in condition Tab
net Price is still shown as 100.
At the time of GR it is done at 103.85 (which is wrong)and Excise
invoice is captured at 13 (which is correct).
Is there any other standard routine which can be used for transfering
this 83.15 as Net Price to GR.
We are working on 4.7 Enterprise version
Thanks and Regards,
Anuj Agarwal,