Purchase Price List

[former_member730536]

Hi,

We are buying one item in drum of 18 liters (UoM Drum18)

Our inventory is in liter.

We created a Purchase Price List, but we noticed that the unit of measurement appearing on that price list is for liter.

The price of each drum is 200, so the price per litter is 11.111, then the system is making it 11.11.

When we create a purchase order using this price list, the total price for a drum is coming to 198.98, which is not the correct price (200).

I'm wondering if the UoM liked to a purchase price list can be the purchase unit of measurement which is the drum of 18 liters?

Or maybe there is another solution that you can suggest. Thanks

[Johan_H]

Hi Javers,

One solution is to set your system to use 3 or 4 decimals for prices. After that the system will start calculating to total correctly

Another solution is to enter 200 x [number of drums] in the line Total field, instead of 11,11 in the Price field. So 1 drum18 = 18 L, the price will show 11.11, but in the total field you enter 200. The price will still show 11.11, but the line total and document total will be correct.

Regards,

Johan

[Johan_H]

Hi Javers,

The first solution avoids manual interaction, the second solution works with your system's current settings. Using more decimals makes all your calculations more precise, and you can adjust printing templates to show only 2 decimals, if that is a problem.

The only other solution that comes to mind, is to set the drum up to be purchased as 1 drum (200), but sold as 18 L (11.11 / L). This would require some fiddling around with the purchasing data and sales data tabs of the Item Master Data window.

I would recommend you create a test database and restore your latest backup onto it, to get recent test data. In this test database you can then try out different settings without messing up your production database. You can also test setting your system to use 3 or 4 decimals Please remember to switch back to the production database when you are done.

Regards,

Johan

P.S. please use the 'Add a Comment' link below my answer to post follow-up questions, otherwise I do not get informed that you responded.

[former_member730536]

Hi Johan,

Thank you for your answer. The second solution looks good but I would like to avoid manual intervention if possible.

Thanks