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

How to Correct Dimensions in Business Central

  It is quite common that users might find out that some entries might mistakenly charge to wrong dimension, which will cause inaccurate financial reporting and analysis. The classic method of rectifying this type of error is to create a manual general journal entry to reverse it. One of the popular features which available in Business Central is “ Correction Dimension ” where it allows you to correct the dimension values in General Ledger Entries age in a simple way.     Important Note 1 : Dimension Correction apply only G/L entries. They do not change the dimensions that assigned in other ledgers for the same transaction. There will be mismatch between the dimensions assigned in the general ledger and the sub-ledgers. Important Note 2 : If you need to do Dimension Correction in a large scale, say more than 100 transactions, it is advised to schedule or perform during the non-peak hours as it may cause Table Locking during posting of other transactions by other use...
Post a Comment
Read more

Why business central fixed asset depreciation amount is different from my calculation

  Upon data migration to Business Central, customers often wonder why the monthly depreciation amount is different from their calculations. The only explanation we've identified so far is that the data provided for the migration inadvertently caused either over- or under-depreciation of depreciation amounts. The following example illustrates how BC's depreciation amount will differ from your calculated amount.           1.        The following asset was migrated to BC with the cut-off date till 31 st August 2022.           2.        You can print the Projected Value report to check on the future depreciation and book value of the asset. Page: Projected Value           3.        According to your book, the trend of monthly depreciation from now until December 31, 2022 is $1,000, but BC is recording ...
Post a Comment
Read more

Intercompany Setup in Business Central

Before you able to create a Sales Invoice or Purchase Invoice to your intercompany partners, there are some configurations need to complete in between the company you administer and the company your partner is managing.      1.        Setup Intercompany Partner Code   This setup will allow the system to differentiate which entity under the same Business Central should the invoice direct to. The Intercompany Partner Code should be unique and agreed upon by all companies. Page:  Intercompany Setup i.           Enable the “Auto Send Transactions” which allows system to send out to intercompany partner once there is transaction posted.     2 .        Setup Intercompany Partners Code This setup will configure the intercompany partners that will involve in the whole intercompany setup in BC. In another word, you will need to create a Intercompany...
Post a Comment
Read more