Storage Location Determination Rule by Qty & then Storage Location Priority.


This concept is used in most of the Industry where stock of a material is available in multiple storage loaction & there is a requirement that during Receipt or Issue system should consider the Qty as well as Storage location based on the business requirement.

In the below Screen Shot we can see the stock of a raw material available at 4 different Storage Location.

Stock.jpg

As in this case we are determining the stock based on Qty first & then Storage Location

Step01:-Firstly we create a Stock Determination Group with T code OSPX,

Stock Determination Group.jpg

Step02:-Assign the Stock determination group to material master

Material master.jpg

Step03:-Create a Stock Determination Rule & do the assignment of Plant, Stock Determination group & stock determination rule T-code OSPX


OSPX.jpg

We define the Priority of Storage Location as shown below.

Based on this priority of storage location will be determined.

Step04:-Now we assign the Stock determination rule to the respective Movement type

  1. Path:-SPROàMaterials ManagementàInventory management & Physical InventoryàStock DeterminationàAssign Stock Determination Rule in the ApplicationsàInventory Management

Movement Type.jpg

This completes the configuration Part.

Now for example we issue this Raw material to check how system determines the storage location priority.

Issue.jpg

As we press Enter system determines the stock based on Qty & then storage location as below

Storage Loc 201.jpg

This is how we can manage the stock of material based on Qty, Storage Location for all respective Movement types (i.e. receipt & issue).

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply