Purchase Analysis SQL ERROR: numeric field overflow
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) |
Confirmed
|
Wishlist
|
OpenERP R&D Addons Team 2 |
Bug Description
addons/
cr.execute("""
create or replace view purchase_report as (
)
""")
-------
ERROR: numeric field overflow
DETAIL: A field with precision 16, scale 2 must round to an absolute value less than 10^14.
********** Error **********
ERROR: numeric field overflow
SQL state: 22003
Detail: A field with precision 16, scale 2 must round to an absolute value less than 10^14.
-------
If i replace in the code : decimal(16,2) --> decimal(18,2)
It's working good.
Hello,
This type of error generate when the purchase order's total exceeds the 16 digit amount.
Thanks.