Cost prices with more than 5 decimal places
Paul Timms
10-23-19
Is it possible to set SERP to use more than 5 decimal places for cost prices? I have tried setting to 6 in System > Settings > Round Off, but cost prices are still being rounded to 5 decimal places. This is causing issues as follows:

Purchase Order is placed for an item, where the supplier unit is 1000 and the price per 1000 is 6.536. The quantity on the order is one million, giving a total of 6536.00.

When the goods receipt is created, it has a unit price of 0.00654 and row sum of 6540.00. This value debits stock and credits purchase invoice accruals.


When the purchase invoice is created, it has the correct price of 6536.00, and this amount debits purchase invoice accruals, leaving an imbalance of 4.00.

If there's no way to fix this in standard, I will have to write something in HAL to make the goods receipt value calculate correctly.
Omar Dottin
10-28-19
Hi Paul! I am investigating your issue. Will check and if there is no workaround, will create a bug report and escalate.

Thanks!
Omar
Omar Dottin
10-28-19
Hi Paul, its confirmed that we have a 5 place decimal limit with cost price. Will escalate your issue so we can fix. Thanks!

Omar
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Piotr Wycichowski
Thanks Gatis, anyway it seems to be reported as bug instead of wish because now it depends on who created task for whom, am I right? /Piotr W....
14:39 15 May 2024
Aldevinas Katkus
Actually a new version of this bug is SL>>Reports>>Periodic customer statement "accumulates" amounts Not sure why it was duplicated, I clicked "submit"only once....
08:09 10 May 2024