1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Incorrect precision at Line Amount (AP Invoice) that match from PO.

Discussion in 'Oracle Financials' started by yingsras, May 3, 2012.

  1. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi everyone,

    I matched the invoice with PO but the Amount at Line is not correct.
    e.g Unit Price = 6,041.12
    Quantity Invoiced = 5

    The Amount should be 30,205.60 but at the amount line it has been round up to 30,206.

    I'm not sure if there's the setup of rounding rule. Could you please advise?

    Thanks,
    Ying
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ying,

    As of your values we are getting 30205.6 when we run the following query:

    Code (Text):
    select (6041.12*5) from dual;
    Can you please tell us what you are exactly trying to do. Is that amount is one of the field of any table or that is just a calculation part.
     
  3. yingsras

    yingsras Forum Advisor

    Messages:
    155
    Likes Received:
    16
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    Hi Bharat G,

    Thank you very much for your help.
    I would like to inform that this issue has been fixed after Technical restart the server after applied patch for fixing some issues.
    Well... I'm sorry for any inconvenient.

    Anyway.. for your information..
    The issue is the amount on AP invoice line is round off (e.g 300.60 to 301)
    And I already setup the precision at Currency to 2 but the issue is still happening.
    So I was coming to ask you all here. But now the issue is disappeared after the server was restarted.

    Thanks,
    Ying
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ying,

    That's not a problem. Thanks for you reply. Actually I thought that was a column problem in table.