Finance | Project Operations, Human Resources, ...

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

(1) Share

Report

Posted on by IT Analyst

?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?

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (0)

Suggested answer

Isaac Olson on at

Like (0)

Report

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

ORDST2258

16384

DROPSHIPITEM

drop ship sales order item

each

WAREHOUSE

100

150000

444

137

113

128

449

141

1500

00:00.0

LOCAL DELIVERY

TERRITORY 1

PAUL W.

RETAIL

1007

0x00000000

PRIMARY

Aaron Fitz Electrical

Bob Fitz

One Microsoft Way

Redmond

98052-6399

USA

4.26E+13

3.13E+13

00:00.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

16384

PO2200

16384

0x00000000

150000

1500

00:00.0

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 on at

Like (0)

Report

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.
Suggested answer

Isaac Olson on at

Like (1)

Report

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 on at

Like (0)

Report

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

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 on at

Like (0)

Report

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.

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