FIFO method validation

[Former Member]

Hi MM Folks

In order to follow and maintain FIFO, while doing MB1A - SAP system should follow the BATCH sequence in FIFO, follow FIFO method with out following FIFO method material document should not posted. It should throw an error message.

I have tried many scenarios to keep the validation when user tries to post the material document with latest batch system is allowing to create a material document. I have searched many forums but i could not find solution for this.

EX: Material in stock our storage location.

When user tries to do material document posting with latest BATCH it is allowing to post, but my requirement is It should an error message as user not maintained FIFO method.

Your help will be highly appreciable... Thanks in Advance...!!!

Thanks & Regards

Vinay

[former_member233510 · Accepted solution]

Please activate batch determination and make the following settings,

1) Create characteristics with table name MCH1 and the required field in CT04 (or) use standard characteristics .

2) Create class and assign the characteristics in CL01.

3) Create sort sequence and assign the characteristics in CU70.

4) Create batch search strategy and assign the sort rule & selection criteria in MBC1.

Results:

1) I used standard characteristic LOBM-VFDAT (Shelf life expiration date) for sorting.

2) I used my own characteristic MCH1-CHARG (batch number) for sorting.

Note : If you've activated batch determination then the system displays the screen for batch determination and if you not activated batch determination then the system displays the screen for storage location and batch selection.

[Former Member · Accepted solution]

Hi Rosh

I have tried whatever you have given steps. But i could not get the validation.

I want to keep the validation when user gives latest Batch it should not post Material document. It should follow FIFO method, which batch material comes first that Qty will be issued first.

1. Created Characteristic with MCH1-CHARG.

2. Created a class and assigned the characteristics in CL01 (BLR1-BATCH).

3. Created sort sequence and assign the characteristics in CU70 (MCH1-BTCH) with ascending sequence.

4. Created batch search strategy and assign the sort rule & selection criteria in MBC1- i have selected Movement Type/ Plant combination and give my plant and ticked Changes allowed & Dialog Batch Determination also ticked & Display UoM as B & Quantity Proposal given as 1.

click on Selection creteria button and given class name & clicked on Sort and given which sort was created and saved.

But when I am trying to Issue the goods with latest batch still it is allowed to create material document. Please guide me where I have missed any step.

My requirement is FIFO method should be allowed based on Batch Number.

Your guidance will be highly appreciable ...

Regards

Vinay

[former_member233510 · Accepted solution]

Hi,

It seems that you've missed few configuration, please check the following settings highlighted in the below screenshot.

Note:

1) Please check whether you've assigned the class with strategy type

2) Please check whether you've assigned the strategy type with the Inventory Management search procedure

3) Please check whether you've activated the search procedure for the movement types where you need the FIFO rule to be apply.

[Former Member · Accepted solution]

Hi Rosh

Good Valuable points you have given including config.

But i have maintained "Define Inventory Management Strategy Types"as Stype (ME01) and Description (Movt type /Plant)

2. Conigured in Define Inventory Management Search Procedure- path " ME0001 - Standard Search Procedure" and in the control Data - Condition type also maintained as ME01 with mvt type / Plant.

3. Check box ticked in Check box column in  Allocate IM Search Procedure/Activate Check and checked with 201, 311, 313, 315 movt types but not maintained Search column in Standard Batch procedure as "ME0001". Does it give any impact?

I have only maintained Characterstic based on BATCH (MCH1-CHARG field). Do i need to created any other characterstic to maintain FIFO method should work based on Batch ?

Still I am able to do material documents with latest batch instead of giving earlier batch. Still any configuration missed out by me.

Your help will be highly appreciable...

Regards

Vinay

[JL23 · Accepted solution]

Does your material have a batch classification 022 or 023?

Do your existing batches have a batch classification?

FIFO is usually based on GR date, not on the batch number itself and not on shelf life expiration date (this is called FEFO - first expire, first out)

Please search SCN with have many wikis and documents and discussions that explain step by step with pictures how to setup batch determination.

[Former Member · Accepted solution]

Hi Rosh,

1. Created Characteristic with MCH1-CHARG.

2. Created a class and assigned the characteristics in CL01 (ZBATCH_CLS)

3.Created sort sequence and assign the characteristics in CU70 (ZMCH1-CHARG) with ascending sequence

4.Created batch search strategy and assign the sort rule & selection criteria in MBC1.

and done configuration through Batch Management ->Batch Determination and Batch Check ->Strategy Types->Define Inventory Management Strategy Types.

[Former Member · Accepted solution]

Remaining Process:

Batch Management ->Batch Determination and Batch Check ->Batch Search Procedure Definition->Define Inventory Management Search Procedure.

Batch Management ->Batch Determination and Batch Check ->Batch Search Procedure Allocation and Check Activation->Allocate IM Search Procedure/Activate Check

Changed as Batch Management ->Define Attributes of System Messages

Changed from Warning message to Error message.

and i am trying to Post the goods against 201 movement with FIFO method. but when i am giving as latest batch while issuing above error message should trigger and it is triggering.

But when i am giving First Batch which is to be allowed to be post the goods but still same error message is showing, please let me know if i missed any configuration part.

YOur help will be appreciable

YOur help will be highly appreciable ..

as per my requirement when i am entering 10Q3 batch should be allowing me to post the Goods Issue other than 10Q3 if i give (15Q1, 15Q2 & 15Q3) it will not allow.

Please let me know if i have missed any configuration as for FIFO method