Changing product consumption

(0) Share

Report

Posted on by MiroV

We have a product which we order and receive based on “pc” (piece) measurement unit. The product it self is a box with two bottles. When consuming this product, throe production order, we consume the box (as a piece), but we really need just to consume one bottle at the time.

With out of changing the product number (creating a new one), I would like to know how can I consume only one bottle at the time, so purchasing would not order a new product (box with two bottles), until we consume the second bottle.

I was looking at Product —> Unit Conversion —>Intra-class Conversations as a possible solution, but not sure if this would be a proper way. My thinking was to setup conversion for this product as a one piece = two bottles.

Would this be the correct way and if yes, would I be able to consume individual bottle on production order, or is there any other way to accomplish this?

Thank you in advance for any information.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

ColbyGallagher 3,666 on at

Like (1)

Report
General disclaimer: The recommended approach in AX is to set your inventory unit of measure to the smallest unit you will ever consume, and then convert to purchase / sales / BOM units that are larger. In this scenario the recommendation would be set the stocking unit to "Bottle" and purchase unit as PC or BX where PC = BX = 2 Bottle.

However, you're on the right path with unit conversions. You can do what you want to do, but you may run in to decimal precision errors later on that can be really nasty to clean up.

To do this without creating a new item / changing the stocking unit of measure for your item:

make sure the "PC" unit has decimal precision greater than 1, so you can show 0.5 PC on hand. Discuss this change very carefully with your team, it will have implications beyond just this item.

add unit "Bottle" with conversion 1 PC = 2 Bottle

Set your BOM / Formula lines to consume unit Bottle.

Good luck.

Was this reply helpful? Yes No
MiroV 40 on at

Like (0)

Report

Thank you for your respond.

I actually like your recommended approach much better. Seem to be cleaner for the future.

Question, there are obviously some transactions in the system (PO’s, transfers, invoices, production orders....), and I would assume these will not be affected, as long as all the transactions are closed, correct?

Also in order to change the unit of measurement, the inventory would need to be zeroed out first?

Was this reply helpful? Yes No
Verified answer

ColbyGallagher 3,666 on at

Like (1)

Report

Once you have inventory transactions, you can't change the inventory unit of measure on an item. The reason being InventTrans (and InventSum) don't store a unit on the transactions or totals, its all just a display of master data. There are performance reasons for this.

Some clients have done what you are describing, financially close all transactions, bring all inventory out, change the unit, and bring inventory back in, but that requires a developer and is not a recommended approach. The recommended approach is to create a new item.

Was this reply helpful? Yes No
Suggested answer

MiroV 40 on at

Like (0)

Report

Thank you.

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

The system will let you issue 0.5 of a box.

Was this reply helpful? Yes No
MiroV 40 on at

Like (0)

Report

So here is my solution, which worked fine for us:

Was this reply helpful? Yes No