Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

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
Powered by Mantis Bugtracker