Purchase amount for second unit of measurement

Business Central/NAV
1

In our company we purchase plywood, the UOM is Pcs, however the quotation is per m3. So
Can the system automtically calculate the m3 of the item in the item card
Can the system calculate the price per pcs or get the Purchase quantity in m3

2

Yes, as long as you have a Unit of Measure conversion setup to handle PCS compared to M3. In the case of a 1/2 in (12mm) x 48 in (1200 mm) x 96 in (2400 mm) sheet, I would have something like the below Item Unit of Measure table:

image
image728×166 7.73 KB

Buying and selling a full sheet is pretty easy, where it becomes a challenge is when you start cutting the sheet. Hope this helps.

P.S. If you use the optional Height x Width x Length fields on Item UOM, be sure you are consistent across ALL Items. I used inches in my example.

1 Like
3

In NAV 2017, if you encounter items with a quantity of 0 but still have a value in the inventory valuation report, there are a few potential reasons and steps you can take to correct this:

  1. Check for pending transactions: Ensure that there are no pending transactions, such as sales orders or purchase orders, that are affecting the inventory value of these items. If there are any pending transactions, process or cancel them accordingly.
  2. Review item ledger entries: Access the item ledger entries for the affected items and examine the transaction history. Look for any entries that might have caused a discrepancy in the quantity and value. Verify if there are any incorrect postings, adjustments, or manual entries that need to be corrected.
  3. Verify inventory posting groups and accounts: Review the inventory posting groups and accounts assigned to the affected items. Check if the accounts associated with these items are correct and accurately reflect the intended valuation method.
  4. Perform a recount or adjustment: If you determine that the quantity and value discrepancy is not due to pending transactions or incorrect postings, you may need to perform a physical inventory recount or adjustment. This involves physically verifying the quantity of the items in question and adjusting the inventory accordingly to match the actual count.
  5. Re-run the inventory valuation report: After addressing the potential causes mentioned above, re-run the inventory valuation report to verify that the issue has been resolved and the items now reflect the correct quantity and value.

Remember to perform these corrective actions in a test or non-production environment before implementing them in your live system. It’s also advisable to consult with your system administrator or NAV support team for assistance and to ensure a smooth resolution.

Thank you, and best of luck in resolving the inventory valuation issue!