Share
Report
5We are in the process of switching to Dynamics 365, and in this context, I have a question about a problem that I simply cannot solve no matter what I try. For our inventory management, we have different units of measure – this is because the base unit is one thing (for inventory counting, issuing, etc.) and the purchase unit is something else (set up according to what we are invoiced for). For example, we have a canister (DK) as the base unit, but the purchase unit is KG. One canister equals 3.5 kg, so when I create a purchase order, it should convert to canisters. For example, I buy 87.5 KG at a time, which equals 25 canisters – but when it is received into inventory, it is posted as 24.99963 canisters, which in our view is incorrect – because we will never issue 0.99963 of a canister.
My question is whether something can be done with the conversion factor and rounding precision – I have tried, but I get errors. Under units, I have chosen to say that KG quantity per unit is 0.28571 canisters, since you cannot have more decimals, but I cannot set the quantity rounding precision to 1; I simply get an error. What can be done? It is critical for me to have the purchase unit in KG because we are invoiced in KG and the base unit in canisters because we issue and count in canisters.
Thanks in advance.
All responses (
Answers (
