What is the Algorithm used for selecting backflush location?



Solution ID = KB-75

Goal : Describes the algorithm the system uses to determine from which location a material should be backflushed.

Module : SLMFG

Fact 1 : SFC

Fact 2 : INV

Symptom 1 : Backflush hierarchy

Symptom 2 : The Algorithm used for selecting the Backflush Location

Database : Progress, SQL

Cause



Backflush field is checked but the backflush location is blank.

Fix



The following is the hierarchy used by the system for determining the location from which to backflush a material:

1) Job Material screen's Backflush Location (or production schedule materials screen)


If the Backflush Location on the Job Material screen is filled in, it uses that location. If the location does not exist for the item, the system creates it on-the-fly and then backflushes from it.

2) Item location that references the operation's Work Center

If the job material location is blank, the system then attempts to find an item location which references the work center used in the job operation to which the material is tied.

The location master table has a Work Center field as does the item location table. The item location work center (itemloc.wc) is a behind-the-scenes field that does not appear on the item location screen. If you enter a work center on the location master, that work center is put into the work center field in the item location table when you add that location to an item (if you change or fill in the location master's work center, the system will read through all item locations for that location and reset the work center).

The backflushing routine then looks for an item location for the item which references the work center used in the job's operation. Therefore, the location has to already exist for the item before backflushing based on work center will work. You can assign the same work center to multiple locations. If more than one location referencing the work center exists for the item, the system selects the highest ranked location

The algorithm does NOT first find a location master which references the work center and then backflush from the location, creating it for the item if it doesn't exist. It goes directly to the item location table looking for a location that references the work center.

3) Item Master Controls screen's Backflush Location

If the item has no locations which reference the operation's work center, it then uses the Backflush Location on the Item Master - Controls screen if it is filled in.

4) Inventory Control Parameters screen's Backflush Location

If that is blank, it then uses the location that is in the Backflush Location on the Inventory Control Parameters screen.

Print Email

Send KB to this email: