Author: admin

Customization CR1196

MFG Auto-allocation from Multiple Bins

Description of Need:

When Manufacturing Allocates inventory it does so only from the Default Material Issue Bin set up on the Item-Site. If there is not enough inventory in that bin, the user must manually select one or more bins to meet the required quantity.

ACME would like manufacturing to automatically allocate from an many bins as needed, provided their business logic described below.

1. If the Site ID is not 0FI (zero F i ), use the default Item-Site Material Issue Bin.
2. Bins starting with “2-“
3. Bins starting with “3-“
4. Bins starting with a letter (A-Z) but not those starting with A, B, C, D, NW or RTL
5. Bins starting with a number (0-9)
6. Bins starting with A, B, C or D
7. Bins starting with NW
8. Bins starting with RTL

In all cases a bin “starting with” “A” can also just be “A”. So “starting with A” would retrieve A, AGG, A-123, and so on.

The rules should be processed in order. First try to allocate from “2-“ bins, then if more inventory is needed (or there are no 2- bins with inventory) check the 3- bins, and so on. For each rule, if there are multiple bins with inventory (i.e. there are multiple 2- bins with inventory), allocate by starting with the smallest quantity first (this should drive the system to consume small quantities thereby reducing the number of bins containing few items).

Description of Solution:

Navigation: Tools >> Setup >> Manufacturing >> Bin Allocation Setup

This window is used to define “rules” that govern how Manufacturing will locate bin inventory to allocate.

As shown above, all Bins beginning with “N” will be excluded, except those beginning with (or equal to) “NW”.

The Manufacturing module allocates inventory using a stored procedure called mmopAllocateBinQuantities. WilloWare will create a modified version of that stored procedure that will use the Bin Allocation Rules to direct how inventory is allocated.

mmopAllocateBinQuantities is used to allocate inventory in bins from several locations in Manufacturing, so the proposed change to that stored procedure will affect allocation from the following windows:

• Manufacturing Order Close
• Manufacturing Component Transaction Entry
• Edit Manufacturing Order Status
• Quick MOs
• Manufacturing Order Receipt Entry
• Picklist

Assumptions/Requirements:

1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
2. The functionality described above is intended for the GP Desktop client.

For information on this design, or any other WilloWare customization or product, please contact us:

Support@willoware.com

Customization DS1115

WIP Cost Reversal

Problem Definition:

ACME builds water dispensers. Some units contain high value assemblies which are treated as capital equipment, so the value is not in an inventory account. When these assemblies are used on a manufacturing order, the normal posting process will adjust the value of the item out of the capital equipment GL account and into the WIP account of the finished good.

When Manufacturing posts the Actual Cost finished good into inventory, it uses the value in WIP to determine the cost of the finished good.

ACME needs the value of these capital items to remain in the capital equipment GL account and not get added to the final cost of the finished good.

Design Features:

Reversing WIP

The customization will monitor the Manufacturing Issue and Reverse Issue posting process. When it detects certain capital items in the resulting Inventory Adjustment, it will create and post a Journal Entry to reverse the GL effects of the Inventory Adjustment.

An Issue transaction credits Inventory and debits WIP. In this case the Inventory account will be a capital equipment account (a regular inventory account is shown below):

The reversing transaction will debit Inventory and credit WIP for the value of the inventory item (using the same GL accounts as the original transaction).

The reversing entry will also show the Item Number in the Distribution Reference field.

A Reverse Issue with a capital item will cause the transaction above to occur in reverse. Manufacturing will Debit the Inventory Account and Credit the WIP Account, and the customization will reverse that.

Assumptions/Requirements:

• The functionality described in this document is intended for the Dynamics GP desktop client. Unless specified otherwise, all testing will occur in the desktop client only. Projects created in Dexterity should have a very high level of compatibility with the Web Client, but cannot be guaranteed without explicitly including additional time in the estimate for testing in the Web Client.