Anahita Goljahani created OFBIZ-13362:
-----------------------------------------
Summary: There are invoice related issues for receipts with
accepted quantity equal to zero
Key: OFBIZ-13362
URL: https://issues.apache.org/jira/browse/OFBIZ-13362
Project: OFBiz
Issue Type: Bug
Components: accounting/invoice
Affects Versions: 24.09.05
Reporter: Anahita Goljahani
Assignee: Anahita Goljahani
Attachments: 10_viewInvoice_annotated.png,
1_new_shipment_for_ship_group_annotated.png, 2_edit_shipment_annotated.png,
3_receive_inventory_against_PO_annotated.png,
4_payment_information_annotated.png, 5_invoice_items_annotated.png,
6_entity_sql_processor_annoatated.png,
7_set_invoice_item_quantity_to_0_annotated.png,
8_select_invoice_item_quantity_0_annotated.png,
9_payment_information_annotated.png
I have identified two main issues regarding invoicing for receipts with an
accepted quantity equal to zero.
# When the system creates a receipt with an accepted quantity equal to zero,
the service createInvoiceItem erroneously set the item invoice quantity to 1,
leading to a wrong invoiced quantity.
# Even when the invoice item quantity is correctly set to zero in the
database, the screen viewInvoice erroneously ‘visualize’ an invoice item
reporting one unit of the product.
h2. The following steps allow to reproduce the issue #1
Create a purchase order for, e.g., 7 units of product GZ-1000. Approve the
order and click ‘New Shipment For Ship Group [00001]’
Screenshot_1
Then, click Receive Against PO
Screenshot_2
In the Receive Inventory Against PO screen, leave the Receive quantity at 0 and
click Receive Item(s)
Screenshot_3
An Invoice is automatically created, as visible in the Payment Information
section of the Order Details screen
Screenshot_4
By clicking the invoice number (10000 in our case), it can be assessed that the
invoice erroneously contains an invoice item with 1 unit of product GZ-1000,
because of a bug in the createInvoiceItem that set the quantity to 1 when it is
0.
Screenshot_5
By using the Entity SQL Processor of the OFBiz Web Tools, it can be assessed
that in the InvoiceItem table there is record for the invoice ‘10000’ with
productId ‘GZ-1000’ and quantity 1.
Screenshot_6
h2. The following steps allow to reproduce issue #2
Continuing the example above, by using the Entity SQL Processor of the OFBiz
Web Tools, set the quantity value of the Invoice Item to 0.
Screenshot_7
Screenshot_8
>From the Payment Information section of the Order Details page, click the
>invoice number 10000 and verify that there is an invoice item for the product
>GZ-1000 with quantity equal to 1, because of a visualization bug in the
>viewInvoice screen.
Screenshot_9
Screenshot_10
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
