Multi Inventory - Stock Reductions causing negative stock

Overtone

Hello - Thank you in advance for looking at this issue for me.

Currently we have ATUM multi inventory set up to manage stock.
The default setting on all products is - LIFO: Last added sells first.
All products are set as Backorder enabled so that clients can request items that are not yet in stock.

The issue is that we are ending up with negative stock in some inventories even when we have enough stock to supply the order from multiple inventories.

When we process an order we expect the stock to be taken from any inventory which has positive stock but we seem to be taking all the stock from the last inventory we have restocked regardless if there is actual availability in a different inventory.

Is there any way to force positive stock to be used first?

We only process orders when we have a positive stock level to supply the order.

thank you

Forum_Admin

Hi Overtone ,

Thank you very much for your post.

It actually makes sense that the inventory is taken from the last restocked. As the LIFO tells ATUM to use the last restocked.

You need to play with inventory priorities and itteration.

Pavel

Overtone

Heya thank you.

Yes.. the LIFO part makes sense.. the issue is that we want to use stock we have available in other inventories if we are short of stock in the Last Inventory used..

So.. how for example would we do the following:

Client Orders PRODUCT x 20 units..

We currently only have 10 units available in Main Inventory..
We order more stock and it is placed into SECOND Inventory.

We wait until we have brought the stock into the system.. and so now we have 10 in Main and 10 in Secondary inventory and a total of 20 stock items.

We now process the order automatically selecting the inventory via the FIFO setting.

I would expect the following result --

Product takes 10 stock first from Secondary inventory (as we had LIFO set) and then take 10 stock from Main inventory.

The total remaining stock will then be set as 0 in both inventories.

====

Currently we are only seeing stock deducted from Secondary inventory showing -10 stock for Secondary inventory while showing 10 available in Main Inventory.

rather than.. 0 stock in 2 inventories..

make sense ?

Forum_Admin

Hi Overtone ,

I am lost now, you set one inventory to to LIFO and the other to FIFO? that should not be possible as this is setting per product.

As I said before, check if your inventory iterration is set to "next in priority order".

Overtone

Sorry.. i dont think i explained correctly.

Both inventories for the product are the same set as LIFO and also "next in priority order"

See images attached:

The issue is.. that when the stock was deducted.. rather than using the next available inventory that has positive stock.. the system simply created negative stock in the Inventory it selected.. (ie the Last Inventory that had stock added)

So its selecting the correct inventory first.. but its not using available stock from other inventories automatically..

We want to automatically use any available stock from any inventory if we have it.. BUT use LIFO inventory first if that makes sense.

Is the issue that both inventories are set to allow Backorders ?

best

Tristan

Forum_Admin

Hi Overtone ,

It could be the reason yes, hmm let me discuss this with my team.

ok, create another inventory that will be the last in priority and call it back orders for example. That inventory set as backordereds allowed. All the others has to have a disallowed status.

Pavel

Overtone

OK thank you.. let me test and get back to you.