Project:
| View Revisions: Issue #32061 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0032061: No "Cost" information shown in Sales Invoice Dimensional Report in case there is no 1 to 1 relation between SO line and GS line | ||
| Revision | 2016-01-29 15:14 by psanjuan | ||
| Steps To Reproduce | In F&B España Create a new costing rule by making warehouse a costing dimension. Create a product named "A 24355 C", add a Purchase Price list "Bebidas Alegres" = 100.00; add a sales price list "Tarifa de Ventas" = 200.00 Create a purchase order for F&B España, today's date. Enter 10 units of Product "A 24355 C", price 100 and 10 units. Book the order. Create another purchase order for F&B España, today's date. Enter 10 units of Product "A 24355 C", price 150 and 10 units. Book the order. Create a Goods receipt to receipt 10 units in WH Norte (RN-1-0-0) at a price / cost of 100.00 and create another Goods receipt to receipt 10 units in WH Sur (RS-1-0-0) at a price/cost of 150.00. Complete Goods Shipments. - Run costing background process therefore vendor receipts above are cost calculated. Check that the cost in WH Norte is 100.00 (10 units) and the cost in WH Sur is 150.00 (10 units). Create a POS Sales Order with "Inmmediate" Invoice Terms for F&B España: - Add line with product "A 24355 C" Qty = 15 units, sales price 200 - Complete POS Sales Order. Run costing background process therefore customer shipment created as explained below is cost calculated. Check that a Goods Shipment is created with 2 lines one line for 10 units from RN-1-0-0 and the other line for 5 units from RS-1-0-0. Check that a Sales Invoice is created with only one line (15 units at a price of 200.00). From Sales order lines, navigate to Sales Invoice lines and check that Goods Shipment Line info in not shown in there as sales invoice line can not be related to two goods shipment lines. Run Sales Invoice Dimensional Report for today's date an check that "NO cost info is shown in there for the product". See image attached. |
||
| Revision | 2016-01-29 15:13 by psanjuan | ||
| Steps To Reproduce | In F&B España Create a new costing rule by making warehouse a costing dimension. Create a product named "A 24355 C", add a Purchase Price list "Bebidas Alegres" = 100.00; add a sales price list "Tarifa de Ventas" = 200.00 Create a purchase order for F&B España, today's date. Enter 10 units of Product "A 24355 C", price 100 and 10 units. Book the order. - Create another purchase order for F&B España, today's date. Enter 10 units of Product "A 24355 C", price 150 and 10 units. Book the order. - Create a Goods receipt to receipt 10 units in WH Norte (RN-1-0-0) at a price / cost of 100.00 and create another Goods receipt to receipt 10 units in WH Sur (RS-1-0-0) at a price/cost of 150.00. Complete Goods Shipments. - Run costing background process therefore vendor receipts above are cost calculated. Check that the cost in WH Norte is 100.00 (10 units) and the cost in WH Sur is 150.00 (10 units). - Create a POS Sales Order with "Inmmediate" Invoice Terms for F&B España: - Add line with product "A 24355 C" Qty = 15 units, sales price 200 - Complete POS Sales Order. - Run costing background process therefore customer shipment created as explained below is cost calculated. - Check that a Goods Shipment is created with 2 lines one line for 10 units from RN-1-0-0 and the other line for 5 units from RS-1-0-0. - Check that a Sales Invoice for just one line (15 units at a price of 200.00) has been created. - From Sales order lines, navigate to Sales Invoice lines and check that Goods Shipment Line info in not shown in there as sales invoice line can not be related to two goods shipment lines. - Run Sales Invoice Dimensional Report for today's date an check that "NO cost info is shown in there for the product". See image attached. Therefore, this bug is fixed in case there is a 1 to 1 relationship between a POS Sales Order Line and a Sales Invoice Line. A new issue is created as design defect to research on the solution to provide in case 1 to 1 relationship is not met. See issue: Existing workaround that is to set POS Sales Order Invoice Terms as "After Delivery". |
||
| Revision | 2016-01-29 15:11 by psanjuan | ||
| Steps To Reproduce | tbd | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |