ERROR: Could not complete the Issue OrderItemShipGrpInvRes to Shipment

[masionas]

Hi Guys,

I have an error outilned below when I try to ship an order. Here are the steps I take. First, I add the product which I do not have on hand and going to buy from supplier -  hence I do not create inventory item for it so far. Then I create sales order, create following purchase order, then I receive incoming shipment of purchase order (on this stage it automatically creates inventory item for this product and QOH =1 ). Then I receive (add)  payment for the sales order and finally I am ready to ship sales order to customer. But when I try to do it I get this error. What I am missing? Thanks for any ideas.

P.S. I searched the mailing lists but there was advise to switch off accounting and it would help. This is not the case for me as I use accounting.

 Error in Service [quickShipEntireOrder]: Error:ERROR: Could not complete the Issue OrderItemShipGrpInvRes to Shipment [file:/F:/ofbiz/applications/product/script/org/ofbiz/shipment/issuance/IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment] process [problem removing the orderItemShipGrpInvRes value: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service [createAcctgTransAndEntries] threw an unexpected exception/errororg.ofbiz.service.ServiceValidationException: The following required parameter is missing: [OUT] [createAcctgTransAndEntries.acctgTransId] (The following required parameter is missing: [OUT] [createAcctgTransAndEntries.acctgTransId])] calling service issueOrderItemShipGrpInvResToShipment in createShipmentForFacilityAndShipGroup

[Jacques Le Roux]

Did you try also to do it by hand (I mean not with Quick Ship option) ? This could show where the problem happens

Jacques

From: "JohnBrown" <[hidden email]>

>
> Hi Guys,
>
> I have an error outilned below when I try to ship an order. Here are the
> steps I take. First, I add the product which I do not have on hand and going
> to buy from supplier -  hence I do not create inventory item for it so far.
> Then I create sales order, create following purchase order, then I receive
> incoming shipment of purchase order (on this stage it automatically creates
> inventory item for this product and QOH =1 ). Then I receive (add)  payment
> for the sales order and finally I am ready to ship sales order to customer.
> But when I try to do it I get this error. What I am missing? Thanks for any
> ideas.
>
> P.S. I searched the mailing lists but there was advise to switch off
> accounting and it would help. This is not the case for me as I use
> accounting.
>
> Error in Service [quickShipEntireOrder]: Error:ERROR: Could not complete
> the Issue OrderItemShipGrpInvRes to Shipment
> [file:/F:/ofbiz/applications/product/script/org/ofbiz/shipment/issuance/IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment]
> process [problem removing the orderItemShipGrpInvRes value: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Service
> [createAcctgTransAndEntries] threw an unexpected
> exception/errororg.ofbiz.service.ServiceValidationException: The following
> required parameter is missing: [OUT]
> [createAcctgTransAndEntries.acctgTransId] (The following required parameter
> is missing: [OUT] [createAcctgTransAndEntries.acctgTransId])] calling
> service issueOrderItemShipGrpInvResToShipment in
> createShipmentForFacilityAndShipGroup
> --
> View this message in context:
> http://www.nabble.com/ERROR%3A-Could-not-complete-the-Issue-OrderItemShipGrpInvRes-to-Shipment-tp19768177p19768177.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[masionas]

Hi Jacques,

The problem is coupled with inventory type id - serialized or not. When I create Sales Order, it triggers the creation of inventory item for the product being sold. It auto creats inventory item id with type "not serial" item. Then, when I receive the PO order for this item I can choose the inventory type on that stage. If I choose - serial type, then it causes quick ship error ( because the inventoryItem record is not get stored on receive PO). If I choose not serial type - then inventoryItem is created and quick ship goes smoothly.

So here are some further questions. Why it auto creates inventory item on sales order create? And why it creates it as non serial? In the facility settings the default type is set as serial.

jacques.le.roux wrote

Did you try also to do it by hand (I mean not with Quick Ship option) ? This could show where the problem happens

Jacques

From: "JohnBrown" <[e-mail]>
>
> Hi Guys,
>
> I have an error outilned below when I try to ship an order. Here are the
> steps I take. First, I add the product which I do not have on hand and going
> to buy from supplier -  hence I do not create inventory item for it so far.
> Then I create sales order, create following purchase order, then I receive
> incoming shipment of purchase order (on this stage it automatically creates
> inventory item for this product and QOH =1 ). Then I receive (add)  payment
> for the sales order and finally I am ready to ship sales order to customer.
> But when I try to do it I get this error. What I am missing? Thanks for any
> ideas.
>
> P.S. I searched the mailing lists but there was advise to switch off
> accounting and it would help. This is not the case for me as I use
> accounting.
>
> Error in Service [quickShipEntireOrder]: Error:ERROR: Could not complete
> the Issue OrderItemShipGrpInvRes to Shipment
> [file:/F:/ofbiz/applications/product/script/org/ofbiz/shipment/issuance/IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment]
> process [problem removing the orderItemShipGrpInvRes value: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Service
> [createAcctgTransAndEntries] threw an unexpected
> exception/errororg.ofbiz.service.ServiceValidationException: The following
> required parameter is missing: [OUT]
> [createAcctgTransAndEntries.acctgTransId] (The following required parameter
> is missing: [OUT] [createAcctgTransAndEntries.acctgTransId])] calling
> service issueOrderItemShipGrpInvResToShipment in
> createShipmentForFacilityAndShipGroup
> --
> View this message in context:
> http://www.nabble.com/ERROR%3A-Could-not-complete-the-Issue-OrderItemShipGrpInvRes-to-Shipment-tp19768177p19768177.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>