Project:
View Revisions: Issue #29539 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0029539: Issues in Reservations related to Reallocate Stock functionality | ||
Revision | 2015-04-09 09:49 by dmiguelez | ||
Steps To Reproduce | 1. Create new Product Go to Product Window and create a new record Organization: F&B US SearchKey: Test Product Name: Test Product Tax Category: Exempt Sale: Checked Product Type: Item Stocked: Checked Attribute Set: Lot Go to Price Tab and create a new record Price List Version: General Sales Unit Price: 10 List Price: 10 2. Add Stock Go to Physical Inventory Window and create a new record Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0001 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count Create another record in Physical Inventory Window Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0002 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count 3. Create Sales Orders with Reservations Go to Sales Order Window and create a new record Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 5 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Sales Order Line and click on Manage Reservations button Select the Line with Attribute Set Value L0001 and set Quantity to 5 and click on Done Create another record in Sales Order Window Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 10 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Line and click on Manage Reservations button Select the Line with Attribute Set Value L0002 and set Quantity to 10 and click on Done 4. Check the data before moving forward This query can help, just replace productid with the m_product_id desired select l.value, sd.m_storage_detail_id, a.lot, a.m_attributesetinstance_id, qtyonhand, reservedqty, allocatedqty from m_storage_detail sd join m_locator l using (m_locator_id) join m_attributesetinstance a using (m_attributesetinstance_id) where m_product_id = productid and l.em_obwhs_type IS NULL OR l.em_obwhs_type <> 'OUT'; It should return something like this Lot ------ qtyonhand ----- reservedqty ----- allocatedqty 0001 ----- 10 ------------ 5 --------------- 0 0002 ----- 10 ----------- 10 -------------- 0 5. Generate PickList Back in Sales Order Window, select the Sales Order that has 10 as the Ordered Quantity Click on the Generate PickList button and generate a PickList using Outbound Locator By launching the previous query it will return something like Lot ------ qtyonhand ----- reservedqty ----- allocatedqty 0001 ----- 10 ------------ 15 -------------- 10 0002 ----- 10 ------------ 0 --------------- 0 Where it should be something like Lot ------ qtyonhand ----- reservedqty ----- allocatedqty 0001 ----- 10 ------------ 10 -------------- 5 0002 ----- 10 ------------ 5 --------------- 5 |
||
Revision | 2015-04-09 09:40 by dmiguelez | ||
Steps To Reproduce | 1. Create new Product Go to Product Window and create a new record Organization: F&B US SearchKey: Test Product Name: Test Product Tax Category: Exempt Sale: Checked Product Type: Item Stocked: Checked Attribute Set: Lot Go to Price Tab and create a new record Price List Version: General Sales Unit Price: 10 List Price: 10 2. Add Stock Go to Physical Inventory Window and create a new record Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0001 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count Create another record in Physical Inventory Window Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0002 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count 3. Create Sales Orders with Reservations Go to Sales Order Window and create a new record Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 5 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Sales Order Line and click on Manage Reservations button Select the Line with Attribute Set Value L0001 and set Quantity to 5 and click on Done Create another record in Sales Order Window Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 10 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Line and click on Manage Reservations button Select the Line with Attribute Set Value L0002 and set Quantity to 10 and click on Done 4. Check the data before moving forward This query can help, just replace productid with the m_product_id desired select l.value, sd.m_storage_detail_id, a.lot, a.m_attributesetinstance_id, qtyonhand, reservedqty, allocatedqty from m_storage_detail sd join m_locator l using (m_locator_id) join m_attributesetinstance a using (m_attributesetinstance_id) where m_product_id = productid and l.em_obwhs_type IS NULL OR l.em_obwhs_type <> 'OUT'; It should return something like this Lot ------ qtyonhand ----- reservedqty ----- allocatedqty 0001 ----- 10 ------------ 5 --------------- 0 0002 ----- 10 ----------- 10 -------------- 0 5. Generate PickList Back in Sales Order Window, select the Sales Order that has 10 as the Ordered Quantity Click on the Generate PickList button and generate a PickList using Outbound Locator By launching the previous query it will return something like Lot qtyonhand reservedqty allocatedqty 0001 10 15 10 0002 10 0 0 Where it should be something like Lot qtyonhand reservedqty allocatedqty 0001 10 10 5 0002 10 5 5 |
||
Revision | 2015-04-09 09:38 by dmiguelez | ||
Steps To Reproduce | 1. Create new Product Go to Product Window and create a new record Organization: F&B US SearchKey: Test Product Name: Test Product Tax Category: Exempt Sale: Checked Product Type: Item Stocked: Checked Attribute Set: Lot Go to Price Tab and create a new record Price List Version: General Sales Unit Price: 10 List Price: 10 2. Add Stock Go to Physical Inventory Window and create a new record Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0001 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count Create another record in Physical Inventory Window Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0002 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count 3. Create Sales Orders with Reservations Go to Sales Order Window and create a new record Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 5 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Sales Order Line and click on Manage Reservations button Select the Line with Attribute Set Value L0001 and set Quantity to 5 and click on Done Create another record in Sales Order Window Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 10 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Line and click on Manage Reservations button Select the Line with Attribute Set Value L0002 and set Quantity to 10 and click on Done 4. Check the data before moving forward This query can help, just replace productid with the m_product_id desired select l.value, sd.m_storage_detail_id, a.lot, a.m_attributesetinstance_id, qtyonhand, reservedqty, allocatedqty from m_storage_detail sd join m_locator l using (m_locator_id) join m_attributesetinstance a using (m_attributesetinstance_id) where m_product_id = productid and l.em_obwhs_type IS NULL OR l.em_obwhs_type <> 'OUT'; It should return something like this Lot\t qtyonhand reservedqty allocatedqty 0001 10 5 0 0002 10 10 0 5. Generate PickList Back in Sales Order Window, select the Sales Order that has 10 as the Ordered Quantity Click on the Generate PickList button and generate a PickList using Outbound Locator By launching the previous query it will return something like Lot qtyonhand reservedqty allocatedqty 0001 10 15 10 0002 10 0 0 Where it should be something like Lot qtyonhand reservedqty allocatedqty 0001 10 10 5 0002 10 5 5 |
||
Revision | 2015-04-09 09:37 by dmiguelez | ||
Steps To Reproduce | 1. Create new Product Go to Product Window and create a new record Organization: F&B US SearchKey: Test Product Name: Test Product Tax Category: Exempt Sale: Checked Product Type: Item Stocked: Checked Attribute Set: Lot Go to Price Tab and create a new record Price List Version: General Sales Unit Price: 10 List Price: 10 2. Add Stock Go to Physical Inventory Window and create a new record Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0001 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count Create another record in Physical Inventory Window Organization: F&B US Warehouse: US East Coast Go to Lines Tab and create a new record Product. Click on the magnifing glass. Click on the funnel icon. Filter Search Key by Test Product. Pick the record that has no Attribute defined Attribute Set Value: Create new one. 0002 Storage Bin: EC-0-0-0 Quantity Count: 10 Click on Process Inventory Count 3. Create Sales Orders with Reservations Go to Sales Order Window and create a new record Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 5 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Sales Order Line and click on Manage Reservations button Select the Line with Attribute Set Value L0001 and set Quantity to 5 and click on Done Create another record in Sales Order Window Organization: F&B US Business Partner: Healthy Food SuperMarkets Warehouse: US East Coast Invoice Terms: Immediate Go to Lines Tab and create a new record Product: Test Product Ordered Quantity: 10 Go to Basic Discounts Tab and delete the existing record Book the Order Select the Line and click on Manage Reservations button Select the Line with Attribute Set Value L0002 and set Quantity to 10 and click on Done 4. Check the data before moving forward This query can help, just replace productid with the m_product_id desired select l.value, sd.m_storage_detail_id, a.lot, a.m_attributesetinstance_id, qtyonhand, reservedqty, allocatedqty from m_storage_detail sd join m_locator l using (m_locator_id) join m_attributesetinstance a using (m_attributesetinstance_id) where m_product_id = productid and l.em_obwhs_type IS NULL OR l.em_obwhs_type <> 'OUT'; It should return something like this Lot qtyonhand reservedqty allocatedqty 0001 10 5 0 0002 10 10 0 5. Generate PickList Back in Sales Order Window, select the Sales Order that has 10 as the Ordered Quantity Click on the Generate PickList button and generate a PickList using Outbound Locator By launching the previous query it will return something like Lot qtyonhand reservedqty allocatedqty 0001 10 15 10 0002 10 0 0 Where it should be something like Lot qtyonhand reservedqty allocatedqty 0001 10 10 5 0002 10 5 5 |
Copyright © 2000 - 2009 MantisBT Group |