Editing Currency Field to remove currency Precision for rounding purpose.

[Bilal Mujahid]

So i am testing rounding feature in iDempiere. So i want to get amount like 100. The system is providing 103.83 while creating purchase order.

1) So i am researching iDempiere forums and they are suggesting that setting standard precision to 0 can resolve this issue?? But the currency fields are locked.

2) I wanna know how to add manual rounding too. Can i use the discount feature to to manual rounding or there is another way??

[Dmitry Oxenenko]

Look for 'Price Precision' field in a given 'Price List'. That's the only way that I have been able to figure out to do what you want to do. If you find another way, please share.
No idea about manual rounding.

[Bilal Mujahid]

So i have changed the price list precision to zero. Still i am getting decimal numbers in the line amount of purchase order. I think solution is something else??

[Martin Schönbeck]

Hi Bilal,

Am Freitag, 22. Mai 2020 09:39:37 UTC+2 schrieb Bilal Mujahid:

So i have changed the price list precision to zero. Still i am getting decimal numbers in the line amount of purchase order. I think solution is something else??

Perhaps you could describe a little more precise what you are doing, what you expect where and what you get

Regards,

Martin

[Bilal Mujahid]

Hi Martin i am working on purchase orders.

1) So we purchase Copper wire in KG like 19.86 kg and its price is 830 per kg. So actual price becomes 16483.8. But we actually paid 16480. So i need to get information how to round this value to 16480. Do i need to use charge to achieve this functionality. So i manipulated the price and setup the price to 829.81 that is close enough to 19480.03. But i am still getting decimal Values.

2) Second information i need to get that we purchase this same wire in KG but we use it as Gram in the BOM. How to achieve this operation. I have also setup the UOM Conversion in the product field. But when i run report like Storage detail it is showing the same KG UOM in the report. Like i setup the KG to Gram Conversion and setup the multiply rate to 0.001 and divide rate to 1000.

So i need to know about how to round values in the first part & in the second part how to Convert from KG to gram to use in BOM.

[Martin Schönbeck]

Hi Bilal,

Am Freitag, 22. Mai 2020 11:15:17 UTC+2 schrieb Bilal Mujahid:

Hi Martin i am working on purchase orders.

1) So we purchase Copper wire in KG like 19.86 kg and its price is 830 per kg. So actual price becomes 16483.8. But we actually paid 16480. So i need to get information how to round this value to 16480. Do i need to use charge to achieve this functionality. So i manipulated the price and setup the price to 829.81 that is close enough to 19480.03. But i am still getting decimal Values.

2) Second information i need to get that we purchase this same wire in KG but we use it as Gram in the BOM. How to achieve this operation. I have also setup the UOM Conversion in the product field. But when i run report like Storage detail it is showing the same KG UOM in the report. Like i setup the KG to Gram Conversion and setup the multiply rate to 0.001 and divide rate to 1000.

So i need to know about how to round values in the first part & in the second part how to Convert from KG to gram to use in BOM.

You have to set product measure to gram to get the second questions answered. You may then even buy it as kgm if you set up the reverse conversion. And while you are at it you can set the unit price to the real price, because in gram you have three digits more. If you stick at kgm you could change the pricelist accuracy to three or more digits. Or when paying write off the surcharge.

Regards,

Martin

[shiju01]

If your invoice value is 16480 either you can use Discount column and define a CHARGE or PRODUCT called ROUND OFF and enter difference  as Price Actual  and  Qty -1

Do not try to adjust currency precision, it might not work always

If you paid only 16480  then you can use the Over/under Payment / Write Off in Payment Allocation window  

[Bilal Mujahid]

Hi Shiju,

1) Shiju if i make a charge for example. The round off value will be shown in the expense account under the default/suspense account summary head. I mean it will be shown as expense in the books and actually we have not done any expense. Can you please explain this part.

2) Other thing the kg to gram conversion is successful. Now i have only worries around the rounding off values.

[Flo Boj]

Hi Bilal,

I just THINK you could put Product "OFFSET" into a newly created ProductCategory :

theres a tab down below Product Category called "Accounting" . There you can define the accounts to book to this article, I think.

Now if you say this is not an expense, MAYBE you can call your Accountant and ask him which account(-ing category) to book this amount to.

Unfortunately im absolutely NOT with accounting, but as for now I doubt there are any products out there that arent expense at all, from the Acccounting perspective !

[Bilal Mujahid]

Hi flo,

1) Actully i have created a Charge called offset and booked this amount into the main Charge account 79600.

2) I make the product to -1 and then post the round value to the above mentioned charged amount.

3) I am doing all the accounting work for my company and i think at the end i need to post this expense in the bad debts and manually offset the final amount from the financial statements at the end of the accounting period. I know this is not an efficient solution but this is the idea i comes up with right now.