Skip to main content
Solved

Combining shipment lines of the same inventory ID

  • Aug 11, 2022 8:25 AM UTC
  • 11 replies
  • 415 views
  • Translate All

Forum|alt.badge.img

Hi,

Have noticed that when it comes to shipping our manufactured items, the Shipment document will split one shipped item ID into multiple lines, which corresponds to one for each quantity we produced under Move/Labor under Manufacturing.

I presume this is because an allocation is created for each Move/Labor document, as opposed to the gross produced quantity as a whole.

Needless to say, this can get rather messy when shipping, if for example we manufacture 1 units per day for 60 days. When we ship the 60 units, we end up with a long Shipment document of 60 lines of the identical item with 1 qty each and a puzzled freight carrier.

Is there any way of consolidating the Shipment document to present this as one shipment line based solely on the Inventory ID?

Thanks in advance!

Best answer by aiwan

​@bruno71 

 

I wouldn’t say this is something that needs a solution but rather customisation for your case.

We much prefer having items split for purposes like ISO, which allows us to track when each shipment line was manufactured in case of any defects.

 

As a workaround, you can unmark the sales order lines for production, then remove the line details, re-input the original quantity then ship as one line.

View original

11 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi @kokjietan 

I tested this in my local because I was curious as I’ve never seen that. I was able to ship with just the one line item. I looked for a setting and could not find one.

Do you have any customizations with regards to the manufacturing in your instance?

Translate

Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • Aug 12, 2022 12:31 AM UTC

Hi @kbeatty21

We do have some customizations, but none which should affect the Shipment and Manufacturing modules as far as I’m aware.

May I ask if your SO Line Details appears similar to ours, ie. one for each Move/Labor document? 

 This seems to result in the multiple shipment lines.

For information, our settings are - Average item valuation, no lot tracking, regular Sales Order, Back Order allowed and Marked for Production.

Translate

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • Aug 17, 2022 11:46 AM UTC

What version (Acumatica Build) are you running?

Translate

Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • Aug 17, 2022 11:55 AM UTC

We're currently on the initial release build of Acumatica 2022R1, but I've asked our VAR to schedule an update to the latest build this week to resolve some known issues.

Anything in mind? I did peruse the build release notes earlier, but haven't found anything related to this.

Translate

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • Aug 17, 2022 1:16 PM UTC

From what I can tell the labor/move creating multiple allocations has been standard for many versions.  Perhaps how Shipments are created has changed - Let’s see the if the Distribution thread can provide guidance.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Nov 1, 2022 7:22 PM UTC

Hi @kokjietan - were you able to find a solution? Thank you!

Translate

Forum|alt.badge.img
  • Jr Varsity III
  • Oct 29, 2025 4:59 PM UTC

We are getting the exact same with 2025 R1 build with no customizations.

 

Translate

Forum|alt.badge.img
  • Jr Varsity II
  • Jan 12, 2026 6:07 PM UTC

Same issue here.  Has there been any solution?

Translate

Forum|alt.badge.img
  • Jr Varsity III
  • Jan 12, 2026 6:50 PM UTC

Acumatica Support did not have a permanent solution, only to work around the issue since the invoice and shipment reports group items with the same details.

Translate

Forum|alt.badge.img
  • Jr Varsity II
  • Jan 12, 2026 8:02 PM UTC

OK...Thanks for the update.  I’m creating shipments through the API.  When I consolidate the line items, it won’t release the shipment because the “order qty is greater than the allocated qty”.  I need to find a way to reset the allocated qty to match the single line shipment qty.

Translate

Forum|alt.badge.img+11
  • Captain II
  • Answer
  • Jan 13, 2026 2:06 PM UTC

​@bruno71 

 

I wouldn’t say this is something that needs a solution but rather customisation for your case.

We much prefer having items split for purposes like ISO, which allows us to track when each shipment line was manufactured in case of any defects.

 

As a workaround, you can unmark the sales order lines for production, then remove the line details, re-input the original quantity then ship as one line.

Translate