Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

MS GP ERROR YOU CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY

Posted on by

?Hello,

We are facing an issue on MS Dynamics Great Plains when users try to fulfill the sales order . we get error message  :"You CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY".

Note this is a dropship sales order . In this regard, I checked releveant Purchase orders , There are Purchase receipt  and Purchase Invoices too. The quantity on hand is still 1500 units  in Inventory module inquiry window for this specific line item on that specific location but GP Sales order don't let users to fulfill sales order. Note that ONHAND quantity on this sales order is showing as 0 . Sales order number is ORD00138918. Can some one help what exactly is making this issue ?

. I opened sales order table SOP10200 in SQL for this specific order and ran following query: (Note that we are facing issue on ORD00138918.)

SELECT QTYREMAI, QTYONHND,QTYONPO,QTYRECVD,QTYREMAI,EXTQTYAL , * FROM SOP10200 WHERE SOPNUMBE IN ('ORD00138918.','ORD00142979.1')

The result is following, I think the error is lying within Various quantity fields like QTYREMAI, QTYONHND,QTYONPO,QTYRECVD,QTYREMAI,EXTQTYAL in SOP10200 table. Any idea where to check?

pastedimage1656084649501v1.png

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: MS GP ERROR YOU CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY

    There is a difference between if the Sales Order is a Drop Ship Sales Order and whether or not the Item on the Purchase Order side was also Drop Ship or not.  If you had originally created this Sales Order as a Drop Ship, and you had the 1500 quantity Back Ordered, and then you Purchased those items via the Actions>Purchase button from the Sales Order, it would have created a Drop Ship Purchase Order to invoice (since its drop ship you are not receiving it).  Once that completes, then your quantity fulfilled should have updated by itself on the Sales Order.    

    To answer your question, the QTYONHND should still be 0 since it is drop ship Sales Order regardless of if you linked it to a PO or not.  In my example above I used a Drop Ship Item and my QTYONHND is 0 and I can fulfill it without issue. So there has to be another field on your SOP10200 line that is holding this up, unless there is an issue with your SOP to POP link table SOP60100, if you have a SOP to POP link on this Sales Order.    

    Below I have my SQL results for executing the following query with my Sales Order using a Drop Ship Item that was Purchased.  

    SELECT * FROM SOP10200 WHERE SOPNUMBE IN ('ORDST2258')

    SOPTYPE SOPNUMBE LNITMSEQ CMPNTSEQ ITEMNMBR ITEMDESC NONINVEN DROPSHIP UOFM LOCNCODE UNITCOST ORUNTCST UNITPRCE ORUNTPRC XTNDPRCE OXTNDPRC REMPRICE OREPRICE EXTDCOST OREXTCST MRKDNAMT ORMRKDAM MRKDNPCT MRKDNTYP INVINDX CSLSINDX SLSINDX MKDNINDX RTNSINDX INUSINDX INSRINDX DMGDINDX ITMTSHID IVITMTXB BKTSLSAM ORBKTSLS TAXAMNT ORTAXAMT TXBTXAMT OTAXTAMT BSIVCTTL TRDISAMT ORTDISAM DISCSALE ORDAVSLS QUANTITY ATYALLOC QTYINSVC QTYINUSE QTYDMGED QTYRTRND QTYONHND QTYCANCE QTYCANOT QTYONPO QTYORDER QTYPRBAC QTYPRBOO QTYPRINV QTYPRORD QTYPRVRECVD QTYRECVD QTYREMAI QTYREMBO QTYTBAOR QTYTOINV QTYTORDR QTYFULFI QTYSLCTD QTYBSUOM EXTQTYAL EXTQTYSEL ReqShipDate FUFILDAT ACTLSHIP SHIPMTHD SALSTERR SLPRSNID PRCLEVEL COMMNTID BRKFLD1 BRKFLD2 BRKFLD3 CURRNIDX TRXSORCE SOPLNERR ORGSEQNM ITEMCODE PURCHSTAT DECPLQTY DECPLCUR ODECPLCU QTYTOSHP XFRSHDOC EXCEPTIONALDEMAND TAXSCHID TXSCHSRC PRSTADCD ShipToName CNTCPRSN ADDRESS1 ADDRESS2 ADDRESS3 CITY STATE ZIPCODE CCode COUNTRY PHONE1 PHONE2 PHONE3 FAXNUMBR Flags BackoutTradeDisc OrigBackoutTradeDisc GPSFOINTEGRATIONID INTEGRATIONSOURCE INTEGRATIONID CONTNBR CONTLNSEQNBR CONTSTARTDTE CONTENDDTE CONTITEMNBR CONTSERIALNBR BULKPICKPRNT INDPICKPRNT ISLINEINTRA SOFULFILLMENTBIN MULTIPLEBINS Print_Phone_NumberGB DEX_ROW_TS DEX_ROW_ID
    2 ORDST2258             16384 0 DROPSHIPITEM                    drop ship sales order item                                                                            0 1 each      WAREHOUSE   100 100 0 0 0 0 0 0 150000 150000 0 0 0 0 444 137 113 128 449 27 18 141                 2 0 0 0 0 0 0 0 0 0 0 0 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 1500 0 0 1500 0 1500 1500 1 0 0 00:00.0 00:00.0 00:00.0 LOCAL DELIVERY  TERRITORY 1     PAUL W.         RETAIL                      0 0 0 1007               0x00000000 0                 5 3 3 3 0 0 0                 0 PRIMARY         Aaron Fitz Electrical                                             Bob Fitz                                                      One Microsoft Way                                                                                                                                                                         Redmond                             WA                            98052-6399          USA                                                           4.26E+13 0                       3.13E+13 0 0 0                                 0                                             0 00:00.0 00:00.0                                                       0 0 0                 0 0 59:22.4

    2717

    SELECT * FROM SOP60100 WHERE SOPNUMBE IN ('ORDST2258')

    SOPNUMBE SOPTYPE LNITMSEQ CMPNTSEQ PONUMBER ORD RCTINVCERRORS RCPTCOST RCPTPRIORITY QTYONPO QTYONPOBASE QTYRECVD QTYRECINBASE RQSTFFDATE QTYBSUOM LOCNCODE ITEMDESC DOCDATE UOFM DEX_ROW_ID
    ORDST2258             2 16384 0 PO2200            16384 0x00000000 150000 0 0 0 1500 1500 00:00.0 1 WAREHOUSE                                                                                                         00:00.0           1022

    You may want to set up a test company with a copy of live in your own system and attempt this same process with your item and a drop ship sales order so that you can compare your data side by side and verify that a new sales order works without issue. 

    If you are still having issues or have additional questions, I would recommend opening a support case so that we can look at the data and dig into this closer. 

    Thanks,

    Isaac Olson

    Microsoft Support

  • IT Analyst Profile Picture
    IT Analyst on at
    RE: MS GP ERROR YOU CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY

    Hello Isaac,

    Thanks for your feedback. I ran reconcile -Remove Sales Documents in GP . Print option was also marked on , It Calculated tax on this sales order. . Note that we use AVATAX for tax, Also Tax is calculated at the time of Sales Invoice so I am assuming that TAX was not right as we use Sales Pad where we have setup for AVATAX. Note that User enter sales order by using Sals Pad as we do have workflow define there . Right now , sales order is showing 0 (ZERO Tax) on this order but when i ran reconcile, it calculated the tax.

    Looking at this I have a question:   Don't you think so that ONHANDQTY should be 1500 units as we have already received 1500 Units through relevant PO / vendor . Even tough this is drop ship sales order but we record Inventory on our site as well . so Please don't  get confuse as in dropship orders , Inventory is not recorded but we had this requirement.

    pastedimage1656366568900v1.png

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: MS GP ERROR YOU CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY

    Hello,

    The reconcile can be restricted to a single Sales Order by entering your Sales Order above in the From and To Range.  You can also mark the 'Print Only' option to see if any changes would be made before actually processing it.  Otherwise, any time you are troubleshooting issues, it's best to set up a test company with a copy of live to verify your results before processing in the live company.

    KB - Set up a test company that has a copy of live company data for Microsoft Dynamics GP by using Microsoft SQL Server

    Thanks,

    Isaac Olson

    Microsoft Support

  • IT Analyst Profile Picture
    IT Analyst on at
    RE: MS GP ERROR YOU CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY

    There is no fulfilment . User was trying to fulfil this order . Also note that there is no sales Invoice yet

    pastedimage1656360153911v1.png

    If we run Reconcile  as you suggested , question is , Would Reconcile be fine and it would not delete any record as Database admin take back up at the day end and every day we have huge number of transactions 

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: MS GP ERROR YOU CAN'T FULFILL AQUANTITY THAT IS GREATER THAN THE LINE ITEM'S REMAINING QUANTITY

    Hello, 

    From your SQL Results, I can't see how much quantity has already been fulfilled on your order.  That would be the QTYFULFI column in the SOP10200 or you can expand the Sales Order Line to see what it is in GP.  This number cannot be greater than what you have set to invoice.   

    pastedimage1656355551242v1.png

    You could also try running Reconcile on this Sales Order too, to see if any amounts change on the document. 

    (Sales >> Utilities >> Reconcile-Remove Sales Documents)

    I hope this helps!

    Isaac Olson

    Microsoft Support

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans