on 04-16-2014 11:32 AM
Hello Friends,
We are facing an issue in sales order pricing & its subsequent effect in invoice. We use AFS pricing, where different grid sizes have its basic price.
We have a basic price condition which come thru a master record, and this can be overridden by a manual price condition.
When such manual condition is entered, it applies to all the quantity of the line item irrespective of the number of grid sizes.
So suppose I had 6 grid sizes in the line item (which also results into 6 schedule lines) list price will be shown across all the grid sizes, see DOC1
But when I enter a manual price EUR 7, it applies to the total quantity that is 6. So the net value in this case will be EUR 7, See DOC2
By calculation, 7/6 = 1.166666666666667
So when now I create the invoice, the value gets rounded for all the grid sizes & it becomes 1.17
Here when system calculate the net value it will sum up 1.17, six times & the resultant net value is EUR 7.02, see DOC3
As a result most of the time there is difference between the order value & the invoice value.
Please suggest what action should be taken.
Regards,
Dhananjay Borate
Hi Dhananjay,
One thing you could try to do is to set your price by 100units=700EUR, hopefully it will reduce your rounding error by two decimal places.
Regards,
Edgar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Mr.Dhanajay,
Please try assigning requirement 13[Rounding as perT001R] against condition type in the pricing procedure. Before that you have to maintain entries in the table company code, Currency, Unit.
Let me know if working.
Regards,
Senthil Venugopal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Dhananjay Borate,
You can avoid this issue working this the following options:
Every Condition Type, in the "Control Data Box 1" have the option to apply a "Rouding Rule" with three different options:
In the standard rounding rule '_', values are rounded off according to business standards:
10.454 -> 10.45 DEM
10.455 -> 10.46 DEM
In rounding rule 'A', values are always rounded up:
10.459 -> 10.46 DEM
10.451 -> 10.46 DEM
In rounding rule 'B', values are always rounded down:
1045.9 -> 1045 LIT
1045.1 -> 1045 LIT
Also you can use, in the "Gruop Condition ", the Rounding difference comparison.
Indicator that controls whether rounding difference is settled for group conditions with a group key routine. If the indicator is set, the system compares the condition value at header level with the total of the condition values at item level. The difference is then added to the largest item.
Use the Conditons Types:
Regards,
Johnattan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.