Quants numbers skips some numbers in between and later fills the missed gaps while Putaway.

[Former Member]

Hi Guru

Issue :- Quants and TO numbers are skipped in between and not in the sequence.

Process:- We are having 4 Storage types for Food articles, namely HRF, MRF,LRF and BLF( BLF is used for internal purpose and not used in Putaway search), Please refer the screen shots below. We are following Next empty bin ( putaway) , with mixed and additional stock allowed(X) except HRF.

As we are following Strigent FIFO , The system pick the oldest Quant numbers from the LQUA table, where the logic is right but as the quant numbers fails to create in a sequence, Strigent FIFO goes for a Toss.

Same case with TO numbers, but it TO number dosn't impact buissness.

Please refer below example.

1 . Put away 40 Qty - Quants numbers 937,938,939 & 940 (HRF storage Type)

2.  Put away 40 Qty - Quants Numbers 947,948,949 & 950 ( MRF storage Type)

3.  Put away 40 Qty - Quants Numbers 941,942,943 & 944 ( LRF storage Type) this is the last stock which was in side stores.

Hence we are following Strigent FIFO , System Picks 937,938,,939,940,and picks 941 series leaving behind the MRF Quant numbers.

Please let me if you more clarification.

Thanks & Regards

Sasidhar

MMWM

[sushant_wanjari · Accepted solution]

Hi,

During the stringent FIFO strategy the system finds the oldest quant in the warehouse.

The system calculates the age of a quant using the date of the goods receipt posting that was set in the quant by the TR & TO.

For all the quants you have mentioned check the GR date in the table LQUA and confirm if the system is picking the quants as per the GR date. Here the no. of quant is irrelevant.

Regards,

Sushant

[Former Member · Accepted solution]

Hi Sushant,

Thanks for the thought,

During the stringent FIFO strategy the system finds the oldest quant in the warehouse.

As the quants numbers are not in the sequence order while creating TO, The LQUA table arranges the Quants in a ascendig order , ie, 1st numbers in the tablw will removed first.

Hence *** FIFO s question here.

Thanks & Regards

Sasidhar

[sushant_wanjari · Accepted solution]

Hi Sasi,

If you look at the LQUA table the results would be arranged as per the quant numbers only. I had asked you to check the GR date in that table.

The stringent FIFO strategy considers the GR date from this table and picks up the oldest quant based on this GR date.

May be you could try to sort the results of the LQUA table in ascending order as per the GR date and then compare the results with what your system is picking up. Hope this should be more clear now.

Regards,

Sushant

[Former Member]

The issue is closed.

[Former Member]

H Sasidhar,

The FIFO strategy picks the oldest qaunt based on the GR date and not on the quant number sequence.

We have three options for GR date to select which is assigned to the respective movement type in the folowing path

IMG->WM->Interfaces->IM->Define movement types->LE-WM interface to IM.

Also, it is not recommended to use the 'addition to stock' for putaway strategy if you wanted to remove the stock using FIFO strategy for the storage type. This is because let's say if you have received a quant for material 'A' with GR date as today and then tomorrow if you recieve the same material A (since addition stock is allowed) the system will create a different quant with tomorrow's date. And later when the system wanted to pick the material 'A' using FIFO it will always pick the today's GR date quant only and it will never pick the quant with latest (tommorow's GR date) date.

I think this could be the main reason for your issue, please check.

Regards

Vijay

[Former Member]

Hi Vijay,

Thanks for the reply and analyses time,

Please have a look on this table coloured in Pink where the same date, same timing, but there is a gap in Quants numbers,  Hence while *** strigent FIFO is followed it is missing the FIFO logic, Please advice.

[sushant_wanjari]

Hi Sasi,

The logic in stringent FIFO is not based on last movement. It is based on GR Date.

See the sreenshot below and see the last column. The GR date represents the date on which stock came to your warehouse. Once the stock comes, it moves within the warehouse in different storage types which is captured in the last movement type.

So, if there are different quants available on the same GR date, then, I believe system would fetch according to the quant numbers.

Please co-relate this with your observation. Hope this clarifies your doubt.

Regards,

Sushant

[Former Member]

Hi,

Have you removed the 'addition to stock' for putaway strategy for the storage type? if not do it and try again.

Regards

Vijay

[Former Member]

HI Vijay and Sushnat,

Thanks a million for your valuable inputs, great, As sushant said , the scenerio is multiple GR's in same date some time it is with one hr time, for examples Dairy products.

The Solution what we have done is :- Number buffering SNRO and changed from 10 to 0, so the gaps are withdrawn.

The issue is closed.

Please let me if you have queries.

Once again thanks

Sasidhar