?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?
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
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.
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.
Thanks,
Isaac Olson
Microsoft Support
There is no fulfilment . User was trying to fulfil this order . Also note that there is no sales Invoice yet
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148