Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Error 6678 "Qty w...
Microsoft Dynamics SL (Archived)

Error 6678 "Qty will go negative for item xxx" when confirming a shipper

(0) ShareShare
ReportReport
Posted on by Laura_Barber 230

Hello,

A client running SL 2011 SP1 has reported this error occurring intermittently when confirming shippers, since their upgrade.  I found a Hot fix for SL 2011 which is similar, but our situation differs from the fixed problem.  First, we are already on the SP1.  Second, the fixed bug dealt with lot numbered items; our is a serial-numbered item.  third, the fixed bug dealt with decimals and we are selling a whole number of the item, 1.

I reviewed quantities in the following tables: lotsert, location, itemsite, itemcost. Also compared to a 'good' order in soshipline and soshipheader.

If we receive in 1 of the item with a different serial number, change the Shipper to point at the new serial number, we can confirm the shipper and it releases.  Then we can immediately go and adjust 1 of the original serial number out of the same site with no trouble.

So, what is causing the 6678 in the first place??

Thanks!

Laura Barber

*This post is locked for comments

  • DavidHodapp Profile Picture
    DavidHodapp 5 on at
    RE: Error 6678 "Qty will go negative for item xxx" when confirming a shipper

    I have the same problem except the numbers in the inventory tables (loc Lot, Site) have correct values.

    The item is only allocated in one shipper leaving qty available equal to 0. I adjusted in the equal amount and still get the error. SL 2011

  • Suggested answer
    Dana Nelson Profile Picture
    Dana Nelson 5 on at
    Re: Error 6678 "Qty will go negative for item xxx" when confirming a shipper

        We also have this problem when confirming from the shipper. There is a Shipment Confirmation screen under Order Management  > Input > Shipper Confirmation. If you put the Shipper ID from the shipper in the Shipper ID field, it populates the shipper info onto this screen, click on the Finish button and shipper should be confirmed. This does not fix every time but I would guess most of the time. If you get the error message again then the Sales Order Integrity check needs to be run then it should confirm.

         Dana

  • Jennifer Spitler Profile Picture
    Jennifer Spitler on at
    Re: Error 6678 "Qty will go negative for item xxx" when confirming a shipper

    Laura,

    I agree - I don't see it listed in any schema editions either.  From a low level perspective - I can tell you it is supposed to be a place holder of quantity on open confirmed shippers - when the shipper updates to closed, it should move that quantity into the QtyShipNotInv bucket and clear it from the ShipConfirmQty field in both tables.  I have written a doc bug for the field to be added to the schema for the Location and Lotsermst tables - I've also asked development for their definition that will be publicized - I'll send that off to you when I get it.

    Thanks,

    Jennifer

  • Laura_Barber Profile Picture
    Laura_Barber 230 on at
    Re: Error 6678 "Qty will go negative for item xxx" when confirming a shipper

    Hello Jennifer,

    I wanted to look up the definition of ShipConfirmQty.  I noticed it is in the Location table, but it's missing in the schema documentation in the Help.  Thanks.

    Laura

  • Laura_Barber Profile Picture
    Laura_Barber 230 on at
    Re: Error 6678 "Qty will go negative for item xxx" when confirming a shipper

    Thank you!  It's helpful to know the formula.  We did not consider all of the related fields.

    Best,

    laura

  • Jennifer Spitler Profile Picture
    Jennifer Spitler on at
    Re: Error 6678 "Qty will go negative for item xxx" when confirming a shipper

    Laura,

    You are correct, all known causes of the sys msg 6678 during Confirm Shipping have been included in sp1 for SL 2011, however, that's not to say there are other unknown bugs lurking until identified.  The system will be doing for following calculation on the location and lotsermst table when the user tries to confirm the shipper:

    Sum(QtyOnHand - QtyShipNotInv - QtyAllocProjIN - ShipConfirmQty + PrjINQtyShipNotInv)

    It's possible the ShipConfirmQty is not getting cleared properly, if that's the case, running the following options in the OM Integrity Check will correct the value:

    Check Shippers

    Correct Totals (Open Orders/Shippers only)

    Some partners/customers have chosen to modify the stored procedure and remove the ShipConfirmQty from the calculation - knowing, by making this change, the client could end up 'over confirming' their quantity on hand and result in a suspended IN Issues batch from the Sales Journal, however, they determine that out weighs the ongoing 6678.  Those stored procedures duing the calculation are:

    DMG_Location_GetQOH

    DMG_LotSerMst_GetQOH

    Regards,

    Jennifer Spitler

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,027 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans