Skip to main content

How to Change Item's Based Unit of Measure in Business Central

 It is quite frequent that user need to change the existing based unit of measure of an item to another scale in order to fit the operation requirement. But do take note that once there is remaining quantity in the item, an error message will pop up to prevent user from changing the unit of measure in Item Cards.


Refer to the following scenario where the user need to change one of the item, from "Box" to "Pcs"  with quantity still sitting in it. User will need to setup a UOM conversion where 1 "Box" of Apple is equivalent to 50 "Pcs" of Apple.

1.    You will need to perform an negative adjustment on the item quantity. Generate the Inventory Valuation Report to confirm the total quantity that need to adjust out. This is to make sure that the adjustment will not impact the item valuation after the quantity adjustment, as it should remain the same value before and after the adjustment.

Report Path: Search > Items > More Options > Report > Inventory > Finance Reports > Inventory Valuation



2.    Use "Negative Adjustment" in Item Journals to adjust ALL the quantity of Apple from the inventory. It is advise not to change the UNIT COST, user should follow as it is.

Page: Search > Item Journals




3.    Once the Negative Adjustment is posted in Item Journals page, the balance quantity of the item should be Zero "0" now.



4.    To setup the Unit of Measure conversion of the item, go to Units of Measure page.

Page: Search > Item > Select Item from the list > Select "Related" > Item > Unit of Measure



5.    Select the "Base Unit of Measure" code that will be used by this item. Once the Base Unit of Measure is set up, you can set up alternate units of measure with a conversion factor using "Qty. per Unit of Measure".
NOTE that the base Unit of Measure should be the lowest denominator.




6.    Proceed to Item Journals page to capture back the full quantity of the item using "Positive Adjustment". User will need to calculate the converted Quantity and Unit Cost based on the original recorded quantity and unit cost. The total "Amount" should be same as before the item change Unit of Measure.



7.    After posting the "Positive Adjustment" in Item Journals, the item quantity will now be updated based on the new Base Unit of Measure.


8.    The Item Valuation of the item should still remain the same as per original UOM recorded with different quantity.






Do you have question on BC that you think I can help?
Drop me an email at "Hello365businesscentral" at Gmail, I will try to answer if I can. 











Labels:
Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

Start Here

Something in Business Central not behaving? Work down this page. Most things are answered here already — and if they aren't, the last section tells you exactly what to send me so we can skip three rounds of questions. The sixty-second checks These four clear most of what reaches me. Try them before anything else. Hard refresh the page. Hold Ctrl and press F5. A normal refresh reloads the cached copy; this one doesn't. Check which company you are in. The name is at the top of the screen. Posting into the wrong entity is easier than it sounds. Open it in a private window. If it works there, the problem is cache or a browser extension, not Business Central. Try a different browser. If Edge fails and Chrome works, that alone narrows it down enormously. Part 1 — Something on screen isn't working A page won't load, a button does nothing, something has gone missing, or an error stops you posting. Start here if Business Central itself is misbehaving. A...
Post a Comment
Read more

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...
Post a Comment
Read more

Exchange Rate Adjustment in Dynamics 365 Business Central: Unrealized Forex Gain/Loss

Overview Business Central's Exchange Rate Adjustment revalues your open foreign-currency documents and bank balances at month-end and posts the unrealized foreign exchange gain or loss for you. You enter the month-end rate once, run one batch job, and BC handles every customer, vendor and bank account in that currency. Why it matters: under MFRS 121, foreign-currency monetary items such as receivables, payables and bank balances must be translated at the closing rate at each reporting date. The difference from the amount originally booked is an unrealized gain or loss that belongs in that period's P&L. Which version are you on? In newer versions of BC the batch job is called Exch. Rate Adjustment and includes Preview Posting, Adjust per entry and the Exch. Rate Adjmt. Ledger Entries page. Older versions use the Adjust Exchange Rates report, which works the same way but without those options. Search for "exchange rate" in Tell Me to see which one your co...
Post a Comment
Read more