MRP Tests

These are tests of the Material Resources Planning feature. Note that MRP is extremely complex and sensitive to small changes in data, so it is recommended that you try these tests from a fresh install of the database.

Setup the Tests

In Demo3PL (Third Party Warehouse), use the Warehouse > Inventory >> Receive an Item screen to receive the following quantities:

• 1000 of MAT_B_COST at $7
• 110000 of GZ-1000 at $5

In WebStoreWarehouse, use Warehouse > Inventory >> Receive an Item screen to receive:

• 50 GZ-1000 at $5

Verify Initial Conditions

Use the Catalog Manager's Products > Facilities tabs to verify the following initial warehouse settings:

Product	Warehouse	Minimum Stock	Reorder Quantity	Days to Ship
GZ-1000	Demo3PL	100,000	5,000	180
GZ-1000	WebStoreWarehouse	25	5	10
GZ-8544	WebStoreWarehouse	10	50	1
PROD_COST	WebStoreWarehouse	0	1	1
MAT_A_COST	Demo3PL	1000	250	180
MAT_A_COST	WebStoreWarehouse	0	5	1
MAT_B_COST	Demo3PL	1000	250	180
MAT_B_COST	WebStoreWarehouse	0	5	1

Verify the following quantity on hand using Catalog > Product >> Inventory tab:

Product	Warehouse	QOH
GZ-1000	Demo3PL	110,000
GZ-1000	WebStoreWarehouse	50,000
GZ-8544	Demo3PL	0
GZ-8544	WebStoreWarehouse	18
MAT_B_COST	Demo3PL	0
MAT_B_COST	WebStoreWarehouse	1,000

Tests

	Action	Results
Test 1: Verify Basic MRP	Create a sales order in CRMSFA > Orders >> Create Order for 10 GZ-8544, 5 PROD_COST, 25 GZ-1000. Approve the order. Open Purchasing application for "Your Company Name Here" (Company). Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse. Then click on [View MRP] and select "Web Store Warehouse"	The following should be created on MRP: Proposed Purchase Order for 50 GZ-8544 Proposed Purchase Order for 10 MAT_A_COST Proposed Inventory Transfer for 15 MAT_B_COST Proposed Manufacturing Receipt for 5 PROD_COST In [Open Requirements] if you click on the PROD_COST manufacturing requirement link, you should view the PROD_COST sales order in the Allocated Orders list with an allocated quantity of 5
Test 2: Verify Approved Requirements for MRP	Go to Purchasing > Planning >> Open Requirements Approve all requirements created for GZ-8544, MAT_A_COST, PROD_COST Go to Purchasing > Planning >> Run MRP and run MRP for Web Store Warehouse again. Then click on [View MRP] and select "Web Store Warehouse"	No new proposed inventory events should be created. Going to Open Requirements again should show no new requirements.
Test 3: Verify Approved Sales Orders for MRP	Go to CRMSFA > Orders >> Create Order. Create a sales order for 50 GZ-1000 with "Offline Payment" method. Do not approve the order. Go to Purchasing > Planning >> Run MRP and run MRP again for Web Store Warheouse. Then click on [View MRP] and select "Web Store Warehouse"	No new proposed inventory events or requirements should be created: the sales order was not approved.
Test 4: Verify Approving Sales Orders for MRP	Go to CRMSFA > Orders. Find last sales order, approve it. Go to Purchasing > Planning >> Run MRP and run MRP again for Web Store Warheouse Then click on [View MRP] and select "Web Store Warehouse"	A new proposed inventory transfer of 50 GZ-1000 from Third Party Warehouse to Web Store Warehouse is created.
Test 5: Canceling Inbound Inventory Transfers	Go to Warehouse > Inventory >> Inventory Transfers for Web Store Warehouse Cancel the inventory transfer for MAT_B_COST Go to Purchasing > Planning >> Run MRP and run MRP again for Web Store Warheouse. Then click on [View MRP] and select "Web Store Warehouse"	A new proposed inventory transfer is shown on MRP results A new inventory transfer is created in the Requested state in the Warehouse > Inventory >> Inventory Transfers screen.
Test 6: Third Party Warehouse MRP	Run MRP for Third Party Warehouse View MRP results for Third Party Warehouse	New Purchase Order Requirement created for MAT_B_COST
Test 7: Inventory Transfer triggers Third Party Warehouse Orders	Create sales order for 10,000 GZ-1000 and approve it Run MRP for Web Store Warehouse Run MRP for Third Party Warehouse View MRP results for both warehouses	Inventory transfer of 10,000 GZ-1000 from Third Party Warehouse to WebStoreWarehouse created and proposed PO proposed for 25,000 GZ-1000 in Third Party Warheouse
Test 8: PO's meet MRP proposed needs	Go to Open Requirements and approve the requirements for 25,000 GZ-1000 and 25 MAT_B_COST Create and approve PO for MAT_B_COST and GZ-1000 in Purchasing Run MRP again for Third Party Warehouse	No new proposed inventory events or requirements created.