BOM Bins

HelpID: 497022146, 497022143

Dynamics GP with multi-bins provides the ability to record one Default Material Issue Bin at the Item-Site level. There are many circumstances where this single bin is not sufficient to meet real world inventory management requirements. The BOM Bins module provides the ability to record a Default Material Issue bin for a Component within a specific BOM. When a BOM Component Bin is specified, Manufacturing will use that bin to Allocate and Backflush, otherwise it will use the normal Item-Site Default Material Issue Bin.

BOM Bins also adds “MO Bins” to allow providing a Material Issue Bin and MO Receipt Bin on the MO.

Setup

Navigation: Tools >> Setup >> Manufacturing >> MFG PowerPack Setup

You must be logged in as SA to enable or disable this module.

To enable BOM Bins, mark the box next to “MODULE: BOM Bins”.

Click DONE.

Close GP then log-in again to activate it.

Using BOM Bins

Navigation: Cards >> Manufacturing >> BOM Bins Maintenance

Use BOM Bins Maintenance to assign BOM Component specific Material Issue Bins. Records can be added or updated manually by entering data into the window, or you can copy & paste from Excel.

The layout is shown above. You must have all the columns. The column names are not important. DO NOT COPY THE COLUMN NAMES when copy-pasting into GP. Select only the data. Each row will import if the following validations pass:

• Parent Item is the correct length and exists in the Item Master
• BOM Type is 1, 2, 3 or 4 (MFG, ENG, CONFIG, ARCH)
• If BOM Type is 3 or 4 then BOM Name must be provided.
• The BOM specified by A, B and C must exist
• Component Item is the correct length and exists in the Item Master. It does not need to exist on the specified BOM, which allows for cases where users manually substitute items. The Component also does not need to be assigned to the Site.
• Site is the correct length and exists in the Site Setup
• Bin exists and is assigned to Site.

When Manufacturing Allocates or Backflushes inventory it will see if a BOM Bin exists for the component. If there is not a BOM Bin the regular Item-Site Default Material Issue Bin will be used. The BOM Bin assignment can therefore be used to specify EXCEPTIONS—“When Component X is used to make Finished Good 2, using this special bin, for everything else use the normal default bin.”

MO Bins

Navigation: Manufacturing Order Entry >> Additional >> MO Bins Entry

MO Bins provide the ability to specify an Issue Bin and Receipt Bin specific to the MO. This can be used together with BOM Bins or by itself. The Issue Bin must be valid for the Issue From site on every line on the Picklist.

If BOM Bins and MO Bins are both used the bin selection logic will be:

• Use BOM Bin if present
• Use MO Bin if present
• Use Item-Site Material Issue Bin

The Finished Good Receipt Bin will be used if present.

BOM Bin Custom Logic

The BOM Bin/MO Bin selection logic is contained in a SQL function: wfnAllocationBin

The inputs are MO Number, Component Item, Draw From Site. You can modify this function to provide any custom bin selection logic you need. If this function returns an empty value for Bin, the default Manufacturing logic will apply where it uses the Item-Site Default Material Issue Bin.