The following error message displays in Counterpoint when attempting to release or cancel an order:
An error occurred loading this document: Invalid floating point operation
One of the units of an item in the ticket has been deleted from Counterpoint after an order with the old unit has been imported.
The case of the units on the item don't match. (e.g. "Each" vs. "EACH").
Add the unit back to Counterpoint or match unit cases and retry the ticket release/cancellation.
The following code can be used to compare the current units for an item found in Counterpoint vs. the unit on the order.
SELECT ITEM_NO, QTY_UNIT, * FROM PS_DOC_LIN WHERE TKT_NO = '#######' SELECT STK_UNIT,ALT_1_UNIT,ALT_2_UNIT,ALT_3_UNIT,ALT_4_UNIT,ALT_5_UNIT FROM IM_ITEM WHERE ITEM_NO = '#######'
In the image above you can see that the order unit and the item units don't match. This is why the error is occurring when attempting to release or cancel the order.
To avoid this error from reoccurring, it is best practice to only append units, and not delete them from item records.
Steps to reproduce error using only standard Counterpoint
- Place an order for an items stocking unit
- Change the stocking unit on the item and make sure the previous unit does not exist as another unit
- Attempt to cancel or release the order, and receive error: