Skip to Content

Rounding difference for condition type

Hi all,

I have created a new discount condition type and allow user to input this condition at the sales order header.

But when it comes to the invoice, the amount could differ due to the rounding as one sales order item could be spilt into multiple schedule lines.

eg: sales order header condition -10

sales order item 10 -7

sales order item 20 -3

invoice header -10.40

invoice item 11 -3.60

invoice item 12 -3.60

invoice item 21 -1.60

invoice item 22 -1.60

there is a difference of 0.40 from the sales order. Is there anyway to prevent this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 07, 2007 at 03:51 AM

    Hi,

    If you want to round the discount to nearest, Please do the changes in conditon types in rounding rule. you have the three options available in this.

    Regards,

    Naveen Duggineni

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I am using B(fixed amount) as my calculation type...

      And my difference is not assigned to 1 item in the invoice...

      Sales Order Header 85,881,260-

      Item 1 19,479,597-

      Item 2 66,401,663-

      The header discount is spilted accordingly into the item 1 and 2.

      But when it comes to invoice.

      Invoice Header 85,881,262-

      Item 10

      Item 11 9,739,799-

      Item 12 9,739,799-

      Item 20

      Item 21 33,200,832-

      Item 22 33,200,832-

      this is because when my Sales item 1 is divided into Invoice 11 and 12,

      ( 19,479,597 / 2 ) = 9,739,798.5

      system round it up to 9,739,799

      same goes for sales item 2

      ( 66,401,663 / 2) = 33,200,831.5

      system round it up to 33,200,832

      i do not want this to be the case because i want the system to default the sales order discount that i give, and put into the invoice....

      if not, then it is like i have to give 2 more dollars of discount which is not accepted by the user.

  • Aug 17, 2007 at 03:29 AM

    Problem still unsolved

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2007 at 09:37 AM

    Hi

    Instead of allow the user to condition Header, allow them to use round off condition at each line item wise, so that it won't affect the billing document.

    Try it out.

    Reward if it helps

    Regards

    Prasanna R

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2007 at 04:12 AM

    Dear DyL

    Assuming you have maintained % discount, can you clarify which pricing type you are using in copy control in VTFL if delivery is used or VTFA is delivery is not used and Calculation type of your Condition Type and

    Refer

    Note 702508 - Pricing: Rounding difference distributed incorrectly

    Note 403254 - Distribution rule for rounding difference comparison

    Note 639462 - Header condition w/ absolute amount distributed incorrectly

    The cause of this is a different group condition which follows the incorrectly distributed group condition and uses a group key routine. This group key routine mixes up the rounding difference comparison since the key for the table of the group conditions (GKOMV_KEY) was set incorrectly during the adjustment of the subsequent group conditon.

    do revert with your feedback

    Regards

    Jitesh

    Add comment
    10|10000 characters needed characters exceeded