Project:
| View Revisions: Issue #28983 | [ Back to Issue ] | ||
| Summary | 0028983: Returning a sale causes the invoice to use an already existing c_invoice.documentno | ||
| Revision | 2015-02-18 21:34 by Orekaria | ||
| Steps To Reproduce | Log into WebPOS 1. In a new receipt Add a product In the menu, select 'invoice this receipt' Pay and finish the sale 2. In the menu, select Verified returns Select the previous sale In the menu, select 'invoice this receipt' Remember the document number of the receipt Finish the sale 3. Execute this query (change 'VBS1/0000089' with the remembered document number): SELECT m_product.name, c_invoiceline.linenetamt, c_invoiceline.taxamt, c_invoiceline.line_gross_amount, c_invoiceline.qtyinvoiced, c_invoiceline.priceactual, c_invoiceline.gross_unit_price FROM c_invoiceline INNER JOIN c_invoice ON c_invoiceline.c_invoice_id = c_invoice.c_invoice_id INNER JOIN c_orderline ON c_invoiceline.c_orderline_id = c_orderline.c_orderline_id INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id INNER JOIN m_product ON c_orderline.m_product_id = m_product.m_product_id WHERE c_invoice.documentno IN ( SELECT c_invoice.documentno FROM c_invoice INNER JOIN c_order ON c_invoice.c_order_id = c_order.c_order_id WHERE c_order.documentno = 'VBS1/0000089' ) 4. Verify that there are lines in the invoice that do not correspond to the invoiced receipt |
||
| Revision | 2015-02-18 21:34 by Orekaria | ||
| Description | Returning a sale causes the invoice to use an already existing c_invoice.documentno |
||
| Revision | 2015-02-18 16:29 by Orekaria | ||
| Steps To Reproduce | Log into WebPOS In a new receipt Add a product In the menu, select 'invoice this receipt' Pay and finish the sale In the menu, select Verified returns Select the previous sale In the menu, select 'invoice this receipt' Remember the document number of the receipt Finish the sale Execute this query (change 'VBS1/0000089' with the remembered document number): SELECT m_product.name, c_invoiceline.linenetamt, c_invoiceline.taxamt, c_invoiceline.line_gross_amount, c_invoiceline.qtyinvoiced, c_invoiceline.priceactual, c_invoiceline.gross_unit_price FROM c_invoiceline INNER JOIN c_invoice ON c_invoiceline.c_invoice_id = c_invoice.c_invoice_id INNER JOIN c_orderline ON c_invoiceline.c_orderline_id = c_orderline.c_orderline_id INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id INNER JOIN m_product ON c_orderline.m_product_id = m_product.m_product_id WHERE c_invoice.documentno IN ( SELECT c_invoice.documentno FROM c_invoice INNER JOIN c_order ON c_invoice.c_order_id = c_order.c_order_id WHERE c_order.documentno = 'VBS1/0000089' ) Verify that there are lines in the invoice that do not correspond to the invoiced receipt |
||
| Revision | 2015-02-18 16:29 by Orekaria | ||
| Description | Returning a sale causes the invoice to use an already existing documentno |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |