cancel
Showing results for 
Search instead for 
Did you mean: 

Price Rounding Issue - AFS Pricing

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

johnattan_company
Participant
0 Kudos

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:

    • Empty.

                     In the standard rounding rule '_', values are rounded off according to business standards: 

                         10.454 -> 10.45 DEM

                         10.455 -> 10.46 DEM

    • "A"

                    In rounding rule 'A', values are always rounded up:

                        10.459 -> 10.46 DEM

                        10.451 -> 10.46 DEM

    • "B"

                   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:

    • PDIF - Diff.value (own)
    • DIFF - Rounding Offwith the Conditions that apply to your needs. The standard gives this ones as examples:  [Requirement: Routine 13 - Rounding as perT001R], [Condition Formula 16] and [Basis Type 4]

Regards,

Johnattan.