We are on 23R2. The Multi Level BOM does not account for UOM conversions in certain columns, such as Purchase Material and Ext Cost.You can see here that the report is taking the Qty 59.9955 x 800.2736 = $48,012.8148 (very close to $48,016.4145 on the report below). If you convert the 59.9955 to the base UOM for RM2010P, you would get 1.0000 EA and the result for ‘Purchase’ (material) on the RM2010P line would be $800.2736 (correct figure) instead of the $48,016.4145 (incorrect figure). The Ext Cost column is also incorrect due to the lack of UOM conversion also.Has anyone else experienced this issue? Seems like a development fix is needed, but maybe I’m missing something? This is the UOM Conversion setup on the RM2010P Stock Item:

Question

Multi Level BOM Costed Not Accounting for UOM Conversions

Forum|Forum|9 months ago
February 27, 2025
6 replies
81 views

danielklumpp
Varsity I

We are on 23R2. The Multi Level BOM does not account for UOM conversions in certain columns, such as Purchase Material and Ext Cost.

You can see here that the report is taking the Qty 59.9955 x 800.2736 = $48,012.8148 (very close to $48,016.4145 on the report below).
If you convert the 59.9955 to the base UOM for RM2010P, you would get 1.0000 EA and the result for ‘Purchase’ (material) on the RM2010P line would be $800.2736 (correct figure) instead of the $48,016.4145 (incorrect figure).
The Ext Cost column is also incorrect due to the lack of UOM conversion also.

Has anyone else experienced this issue? Seems like a development fix is needed, but maybe I’m missing something?

This is the UOM Conversion setup on the RM2010P Stock Item:

ranjithduraisamy72
Captain II
Forum|Forum|9 months ago
February 28, 2025

@danielklumpp Is that a subassembly item? I noticed that the BOM ID appears different on the screenshot. Could you share a screenshot of the BOM and the Production Order?

🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀

danielklumpp
Author
Varsity I
Forum|Forum|9 months ago
February 28, 2025

The BOM ID is reporting that the line is a MATERIAL of the next level up BOM. So the line for RM2010P is reporting that RM2010P is a material of P001048. I don’t believe there is an issue with referencing the correct BOM. Also, I don’t have a production order, I am only dealing with BOMs and the Multi Level BOM report here.

Here is a screenshot of the P001048 BOM:

bwaldie
Freshman I
Forum|Forum|7 months ago
April 24, 2025

how many decimal places do you have configured within the company settings?

danielklumpp
Author
Varsity I
Forum|Forum|7 months ago
April 24, 2025

We have 4 decimal places.

Chris Hackett
Acumatica Community Manager
Forum|Forum|5 months ago
July 2, 2025

Hi @danielklumpp were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

danielklumpp
Author
Varsity I
Forum|Forum|5 months ago
July 3, 2025

No, the Acumatica RnD team is in development on this issue.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded