Community

Unit Price - Five Decimal Places

Does anyone know how to work around ABBYY's rounding of the unit_price to four decimal places.   Our unit_prices go up to five (5) decimal places, and I changed the PROPERTIES of the Unit_price in the Line_Items to a Number / General / Any and when I do a TEST of the document definition, the five decimal place numbers appear now without the rounding to four decimal places, but ABBYY gives the error that 'The field value is not a number'.    

0

Comments

6 comments

  • Avatar
    Scott Chau

    I would have left it at default of Amount of Money, and disable the normization.  

    If you leave it as amount of money, make sure you have the following enable

    0
  • Avatar
    Jerry Rayburn

    Thanks, Scott!  I tried, but it's still not working.  I changed my settings as you suggested.

    Revert to 'Amount of Money', allow multiple decimals, turn normalization off.

     

    For the four line items in red, they should have five decimal places, like .08838, .013059.

    The other two, that do not get rounded, are matching my dataset and making the correct match, but for those that are being rounded to four places, I'm getting 'Data not found in database' error because they do not match the dataset.

     

    0
  • Avatar
    Jerry Rayburn

    I hadn't noticed before, but once again, when I reverted to 'Amount of Money', ABBYY 

    reduces the number to four decimal places.  I don't know how to override this feature.

    0
  • Avatar
    Scott Chau

    How about trying number without normization and these setting.  It seems to not have a number error for me.  Only issue for me is the DB and adding up to total but that because I had to fake some invoice data.

     

    0
  • Avatar
    Jerry Rayburn

    Just to reply thank you, and I will try later today and update.  Much appreciated!   Jerry

    0
  • Avatar
    Jerry Rayburn

    Scott, it's working, it's working, it's working !!!

    0

Please sign in to leave a comment.