How to allocation goods of sales order by location, ignoring LOT, FIFO, FEFO, LIFO?

The customer has several shelves as stock location.

The problem is that the customer does not work with FIFO rules to allocate sales orders, he needs that when allocating a product the system takes all the available quantity in that location ignoring FIFO rules.

Ex:

LOCATION PRODUCT LOT ENTER DATE QTY
A1D02 ABC123 L0023 2020/02/14 20
A1D02 ABC123 L0002 2020/01/15 10
E1A03 ABC123 L0023 2020/02/14 10
E1A03 ABC123 L0005 2020/01/30 20

If I need allocate 30 units, the Sage X3 will use the FIFO rule and will take products from the location:

A1D02 = 10
E1A03 = 20

I would like the system allocate all the quantity availible in the location A1D02 or E1A03.

I tried different configurations and it didn't work

Is it possible?

Thanks

  • 0

    Hi,

    1) Your current result give only stock from lot L0023

    => single lot is probably checked on your allocation rule

    2) In your example, you have only 10 on E1A03.

    => How X3 could choose 20 on E1A03 ? Slight smile

    3) You could use two entry points (MTOLINK_PRP, MTOLINK_RULES) to apply more filters and rules on allocation