Difference between revisions of "MRP Tests"

From Opentaps Wiki
Jump to navigationJump to search
(New page: 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 fr...)
 
(→‎Tests)
 
(13 intermediate revisions by 2 users not shown)
Line 35: Line 35:
 
|-
 
|-
 
||MAT_B_COST||WebStoreWarehouse||0||5||1
 
||MAT_B_COST||WebStoreWarehouse||0||5||1
 +
|-
 +
||DEMO_STRGRP_PROD ||WebStoreWarehouse||2||10||15
 
|}
 
|}
  
Line 54: Line 56:
 
|-
 
|-
 
||MAT_B_COST||WebStoreWarehouse||1,000
 
||MAT_B_COST||WebStoreWarehouse||1,000
 +
|-
 +
||DEMO_STRGRP_PROD||WebStoreWarehouse||0
 
|}
 
|}
−
 
  
 
==Tests==
 
==Tests==
Line 74: Line 77:
 
* Proposed Inventory Transfer for 15 MAT_B_COST
 
* Proposed Inventory Transfer for 15 MAT_B_COST
 
* Proposed Manufacturing Receipt for 5 PROD_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
 
||Test 2: Verify Approved Requirements for MRP
Line 138: Line 142:
 
*No new proposed inventory events or requirements created.
 
*No new proposed inventory events or requirements created.
 
|-
 
|-
−
 
+
||Test 9: Verify Sales Order Allocation to Proposed Requirements
 +
||
 +
#Create a sales order in CRMSFA > Orders >> Create Order for 8 WG-9943, 3 WG-9943, 3 WG-9943.  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 [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
 +
||
 +
#Open Purchasing application for "Your Company Name Here" (Company).
 +
#Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Demo Store #2.
 +
#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
 +
||
 +
#Create a sales order in CRMSFA > Orders >> Create Order for 10 DEMO_STRGRP_PROD in Demo Group Store.
 +
#Open Purchasing application for "Your Company Name Here" (Company).
 +
#Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Demo Store #2. 
 +
#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
 +
||
 +
#Create a sales order in CRMSFA > Orders >> Create Order for 10 DEMO_STRGRP_PROD in Demo Group Store.
 +
#Open Purchasing application for "Your Company Name Here" (Company).
 +
#Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Ofbiz E-Commerce Store.
 +
#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
 +
||
 +
#Create a sales order in CRMSFA > Orders >> Create Order for 10 DEMO_STRGRP_PROD in Demo Store #2s
 +
#Open Purchasing application for "Your Company Name Here" (Company).
 +
#Run MRP from Purchasing > Planning >> Run MRP for Web Store Warehouse and Demo Product Store Group. 
 +
#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
 
|}
 
|}

Latest revision as of 16:19, 11 December 2007

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
DEMO_STRGRP_PROD WebStoreWarehouse 2 10 15


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
DEMO_STRGRP_PROD WebStoreWarehouse 0

Tests

Action Results
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
Retrieved from "https://docs.opentaps.org/docs/index.php?title=MRP_Tests&oldid=1931"