Hi all
We are using AOS_Products to manage hourly rates. Invoices are created based on timesheets so that there is one product line per employee per day, billable hours calculated as quantities and other information (e.g. dates and employee names) included as description. Since daily billable hours often are not whole numbers, also product quantities do include fractional parts.
However upgrading from 7.7.1 to 7.7.4 broke this. The upgrade script resulted in all product_qty entries in the database (so not just in new or edited invoices) being reduced to integers. Instead of mathematical rounding it seems like everything past the decimal point has just been cropped, leaving many line items simply as zeros. All other fields seemed to remain unchanged. Editing an invoice would then require retyping all non-whole number quantities to line items. Upon save prices and taxes were recorded correctly, but quantities would again be reduced to integers.
After restoring backups I tried upgrading again with similar results.
Im assuming this is not an intended feature, so have others noticed a similar issue? If I’m the only one experiencing this, does anyone have any ideas how to fix it or circumvent the problem? The SuiteCRM instance in question is somewhat customized, but none of the changes should interfere with upgrades or line item quantities in this way.