Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

PO_PurchaseOrderDetail_svc - UnitCost rounding

Posted By Marek Krotiuk 10 months ago

Hello, I'm having rounding problem issue - in configuration I have decimal precision set to 4, in the Sage 100 (2022 version 7.10.0.0) my PO Item is stored correctly. Unit price for one of the items is 37.5950, but when I get date by PO_PurchaseOrderDetails_svc I get value rounded to 2 places - 37.6

I checked on Library Master -> Data File Display and Maintenance and for given invoice it shows correct (not rounded) value, any ideas how to fix that?

0 Kevin M 10 months ago

What column are you referencing? UnitCost should give the 4 decimal precision value, but ExtensionAmt never will, because that is the calculated actual $ charge for the line (and must be rounded to the penny).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marek Krotiuk 10 months ago in reply to Kevin M

Sorry for not mentioning this in first place - yes I'm taking value from UnitCost and this value is rounded
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

PO_PurchaseOrderDetail_svc - UnitCost rounding

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING