Project:
| View Revisions: Issue #20068 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0020068: Products with different search key but same name are considered the same | ||
| Revision | 2012-03-21 17:00 by jecharri | ||
| Steps To Reproduce | 1. Create new product with search key =COM-FULLLEG-BLK-1 and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 2. Create new product with search key =COM-FULLLEG-BLK-1P and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 3. Create Goods Receipt from same organization and any BP. Add 2 lines: one per each product and any storage bin and with qty=1. 4.Go to the database and see that m_inoutline table records are correct(you can see that one line is for product COM-FULLLEG-BLK-1 and the other for product COM-FULLLEG-BLK-1P): select io.m_product_id,p.value from m_inoutline io left join m_product p on io.m_product_id=p.m_product_id order by io.created desc limit 2 5.After that, in window "Goods Receipt" and inside the tab "Lines", change the view type from grid to form in both lines. 6.Go again to the database and execute again the previous query.You will see that one product id and search key has change and both are the same product. The only product is the product whose search key is 'COM-FULLLEG-BLK-1' |
||
| Revision | 2012-03-21 16:59 by jecharri | ||
| Steps To Reproduce | 1. Create new product with search key =COM-FULLLEG-BLK-1 and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 2. Create new product with search key =COM-FULLLEG-BLK-1P and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 3. Create Goods Receipt from same organization and any BP. Add 2 lines: one per each product and any storage bin and with qty=1. 4.Go to the database and see that m_inoutline table records are correct(you can see that one line is for product COM-FULLLEG-BLK-1 and the other for product COM-FULLLEG-BLK-1P): select io.m_product_id,p.value from m_inoutline io left join m_product p on io.m_product_id=p.m_product_id order by io.created desc limit 2 5.After that, in window "Goods Receipt" and inside the tab "Lines", change the view type from grid to form in both lines. 6.Go again to the database and execute again the previous query.You will see that one product id and search key has change and both are the same product. The only product is the product whose search key is 'COM-FULLLEG-BLK-1' |
||
| Revision | 2012-03-21 16:58 by jecharri | ||
| Steps To Reproduce | 1. Create new product with search key =COM-FULLLEG-BLK-1 and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 2. Create new product with search key =COM-FULLLEG-BLK-1P and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 3. Create Goods Receipt from same organization and any BP. Add 2 lines: one per each product and any storage bin and with qty=1. Process. 4.Go to the database and see that m_inoutline table records are correct(you can see that one line is for product COM-FULLLEG-BLK-1 and the other for product COM-FULLLEG-BLK-1P): select io.m_product_id,p.value from m_inoutline io left join m_product p on io.m_product_id=p.m_product_id order by io.created desc limit 2 5.After that, in window "Goods Receipt" and inside the tab "Lines", change the view type from grid to form in both lines. 6.Go again to the database and execute again the previous query.You will see that one product id and search key has change and both are the same product. The only product is the product whose search key is 'COM-FULLLEG-BLK-1' |
||
| Revision | 2012-03-21 16:47 by jecharri | ||
| Steps To Reproduce | 1. Create new product with search key =COM-FULLLEG-BLK-1 and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 2. Create new product with search key =COM-FULLLEG-BLK-1P and name=CALF AND FORQUAD COMPRESS. Checked as Stocked. 3. Create Goods Receipt from same organization and any BP. Add 2 lines: one per each product and any storage bin and with qty=1. Process. 4. Create Physical Inventory header for product's warehouse. Press "Create Inventory Count List". Specify "Product Category" of your products and rest of fields empty. Press OK Realize that 2 lines for your products have been added. If you navigate to Product window you will see that both navigate to same product, instead of each line to each product |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |