MRP Tests

From Opentaps Wiki

Jump to: navigation, search

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.

Contents


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:

ProductWarehouseMinimum StockReorder QuantityDays to Ship
GZ-1000Demo3PL100,0005,000180
GZ-1000WebStoreWarehouse25510
GZ-8544WebStoreWarehouse10501
PROD_COSTWebStoreWarehouse011
MAT_A_COSTDemo3PL1000250180
MAT_A_COSTWebStoreWarehouse051
MAT_B_COSTDemo3PL1000250180
MAT_B_COSTWebStoreWarehouse051
DEMO_STRGRP_PROD WebStoreWarehouse21015


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

ProductWarehouseQOH
GZ-1000Demo3PL110,000
GZ-1000WebStoreWarehouse50,000
GZ-8544Demo3PL0
GZ-8544WebStoreWarehouse18
MAT_B_COSTDemo3PL0
MAT_B_COSTWebStoreWarehouse1,000
DEMO_STRGRP_PRODWebStoreWarehouse0

Tests

ActionResults
Test 1: Verify Basic MRP
  1. Create a sales order in CRMSFA > Orders >> Create Order for 10 GZ-8544, 5 PROD_COST, 25 GZ-1000. Approve the order.
  2. Open Purchasing application for "Your Company Name Here" (Company).
  3. Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse.
  4. 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
  1. Go to Purchasing > Planning >> Open Requirements
  2. Approve all requirements created for GZ-8544, MAT_A_COST, PROD_COST
  3. Go to Purchasing > Planning >> Run MRP and run MRP for Web Store Warehouse again.
  4. 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
  1. Go to CRMSFA > Orders >> Create Order.
  2. Create a sales order for 50 GZ-1000 with "Offline Payment" method.
  3. Do not approve the order.
  4. Go to Purchasing > Planning >> Run MRP and run MRP again for Web Store Warheouse.
  5. 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
  1. Go to CRMSFA > Orders. Find last sales order, approve it.
  2. Go to Purchasing > Planning >> Run MRP and run MRP again for Web Store Warheouse
  3. 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
  1. Go to Warehouse > Inventory >> Inventory Transfers for Web Store Warehouse
  2. Cancel the inventory transfer for MAT_B_COST
  3. Go to Purchasing > Planning >> Run MRP and run MRP again for Web Store Warheouse.
  4. 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
  1. Run MRP for Third Party Warehouse
  2. 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
  1. Create sales order for 10,000 GZ-1000 and approve it
  2. Run MRP for Web Store Warehouse
  3. Run MRP for Third Party Warehouse
  4. 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
  1. Go to Open Requirements and approve the requirements for 25,000 GZ-1000 and 25 MAT_B_COST
  2. Create and approve PO for MAT_B_COST and GZ-1000 in Purchasing
  3. Run MRP again for Third Party Warehouse
  • No new proposed inventory events or requirements created.
Test 9: Verify Sales Order Allocation to Proposed Requirements
  1. Create a sales order in CRMSFA > Orders >> Create Order for 8 WG-9943, 3 WG-9943, 3 WG-9943. Approve the order.
  2. Open Purchasing application for "Your Company Name Here" (Company).
  3. Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse.
  4. Then click on [Open Requirements] and click on the WG-9943 proposed requirement link
You should see two Requirement/Order entries under "Allocated Orders"
  • Quantity of 1 for the second order
  • Quantity of 3 for the third order
Test 10: Product Store Specific MRP with no sales order creation
  1. Open Purchasing application for "Your Company Name Here" (Company).
  2. Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Demo Store #2.
  3. Then click on [View MRP] and select "Web Store Warehouse"
  • No new proposed inventory events or requirements created.
Test 11: Product Store Specific MRP with sales order creation #1
  1. Create a sales order in CRMSFA > Orders >> Create Order for 10 DEMO_STRGRP_PROD in Demo Group Store.
  2. Open Purchasing application for "Your Company Name Here" (Company).
  3. Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Demo Store #2.
  4. Then click on [View MRP] and select "Web Store Warehouse"
The following should be created on MRP:
  • Proposed Purchase Order for 12 DEMO_STRGRP_PROD
Test 12: Product Store Specific MRP with sales order creation #2
  1. Create a sales order in CRMSFA > Orders >> Create Order for 10 DEMO_STRGRP_PROD in Demo Group Store.
  2. Open Purchasing application for "Your Company Name Here" (Company).
  3. Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Ofbiz E-Commerce Store.
  4. Then click on [View MRP] and select "Web Store Warehouse"
  • No new proposed inventory events or requirements created for DEMO_STRGRP_PROD.
Test 13: Product Store Group Specific MRP
  1. Create a sales order in CRMSFA > Orders >> Create Order for 10 DEMO_STRGRP_PROD in Demo Store #2s
  2. Open Purchasing application for "Your Company Name Here" (Company).
  3. Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Demo Product Store Group.
  4. Then click on [View MRP] and select "Web Store Warehouse"
The following should be created on MRP:
  • Proposed Purchase Order for 32 DEMO_STRGRP_PROD


© Open Source Strategies, Inc. Development of this documentation site is sponsored by Open Source Strategies, Inc.
Help support opentaps with a subscription to this documentation site.