[
https://issues.apache.org/jira/browse/OFBIZ-5352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13797075#comment-13797075
]
Christian Carlow commented on OFBIZ-5352:
-----------------------------------------
On second thought, I suppose a shipment could be shipped and invoiced
afterwards.
I think the Shipment statusId should be ignored if corresponding invoice items
are changed.
What is needed is a widget that lists shipment items that have yet to be
invoiced.
> Invoice Item Removal doesn't work when billing records exist
> ------------------------------------------------------------
>
> Key: OFBIZ-5352
> URL: https://issues.apache.org/jira/browse/OFBIZ-5352
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: Release Branch 12.04
> Reporter: Christian Carlow
>
> Invoice Items cannot be removed if the billing records have been created for
> the item. Billing records in tables such as orderItemBilling are created
> when a Shipment statusId is changed to Pick or Pack which triggers the
> invoice to be created.
> For such cases, after clicking the "Remove" button for an item on the Invoice
> Items page, a primary key violation error occurs due to the invoice item
> being referenced in orderItemBilling.
> It seems the "removeInvoiceItem" service in InvoiceServices.xml should be
> improved to delete billing records or any other records that would prevent
> the invoice item from being removed.
> The shipmentItemBilling table may also cause a primary key violation so it
> should be handled also.
> It also seems that the billing information should be displayed and that is
> should be able to be edited. It seems that picking/packing a shipment is the
> only way to associate an orderItem with an invoiceItem.
> Shouldn't there exist a way to associate an invoice item with an order item
> through some invoice editor? Perhaps this should be a separate issue as an
> Improvement.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
