Skip to main content
Question

Combining shipment lines of the same inventory ID

K
Semi-Pro II
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!

    Kandy Beatty
    P
    2 people like this
    • Kandy Beatty
      Kandy Beatty
    • P
      PBSA

    6 replies

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+16
    • Kandy Beatty
    • Captain II
    • 2209 replies
    • August 11, 2022

    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?

    Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    K
    2 people like this
    • Chris Hackett
      Chris Hackett
    • K
      kokjietan
    K
    Semi-Pro II
    Forum|alt.badge.img
    • kokjietan
    • Author
    • Semi-Pro II
    • 81 replies
    • August 12, 2022

    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.

    angierowley75
    Acumatica Moderator
    Forum|alt.badge.img+3
    • angierowley75
    • Acumatica Moderator
    • 819 replies
    • August 17, 2022

    What version (Acumatica Build) are you running?

    If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
    K
    Semi-Pro II
    Forum|alt.badge.img
    • kokjietan
    • Author
    • Semi-Pro II
    • 81 replies
    • August 17, 2022

    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.

    angierowley75
    Acumatica Moderator
    Forum|alt.badge.img+3
    • angierowley75
    • Acumatica Moderator
    • 819 replies
    • August 17, 2022

    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.

    If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • 2754 replies
    • November 1, 2022

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

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved