Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

POP Return "The quantity returned can't exceed 0.00"

(0) ShareShare
ReportReport
Posted on by 725

Hi All,

I have entered a PO receipt and am now trying to return against it but I receive the message "The quantity returned can't exceed 0.00. This is the maximum available based on the item and receipt number. Please enter a smaller quantity on the return."  Initially there was an issue with my stock whereby I had a quantity allocated when there were in fact none allocated, an inventory reconcile resolved this but I am now getting the error message when trying to return the item in question. Any help or guidance will be much appreciated.

Thank you!

Kind regards,

Nia.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: POP Return "The quantity returned can't exceed 0.00"

    I would have done the following to analyze this issue:

    1. Confirm whether I indeed have quantity available (qty on hand less qty committed less qty allocated).

    2. Confirm whether I have allocated this product on some sales order / invoice.

    3. Confirm that I had not sold it to any customer, from this purchase receipt.

    Each GRN receipt you post, will get recorded on a table called Purchase Receipts (IV10200). This table will have many information, including the most critical ones, QTYRECVD (Quantity Received), QTYSOLD (Quantity Sold), RCPTSOLD (Receipt Fully Sold), etc.

    If on this table, for the receipt number & item in question, the QTYRECVD - QTYSOLD = 0, then you could never return. Which means, it's been sold fully. Following is the query, which might be helpful to start with:

    SELECT ITEMNMBR, TRXLOCTN, DATERECD, RCPTNMBR, RCPTSOLD, QTYRECVD, QTYSOLD

    FROM IV10200

    WHERE ITEMNMBR = [item number in question]

    AND TRXLOCTN = [location to which you purchased this item originally]

    AND RCPTNMBR = [receipt number in question]

    If the product is serialized or lot based, then your troubleshooting is further eased, by looking at Serial/Lot Trace in GP Application itself.

    If nothing from above works, Vinutha's query would give you a complete analysis of this product and you could drill down to the root from there.

  • Vinutha Holla Profile Picture
    Vinutha Holla 705 on at
    Re: POP Return "The quantity returned can't exceed 0.00"

    Hi Nia,

    Can you please run the below script on your company database where this error is occuring. This will give us all the info about the PO and receipt. Please edit the script by entering your PO number and then running the script.Once the script is run please send me the results for review.

    declare @PONUMBER char(20)

    select @PONUMBER = 'PO000000000016138'

    ----------------------------------------------------------------------------------

    set nocount on

    if exists (select * from tempdb..sysobjects where name = '##POPRCTNM')

    drop table dbo.##POPRCTNM

    create table ##POPRCTNM

    (POPRCTNM char(17))

    insert into ##POPRCTNM

    (POPRCTNM)

    select POPRCTNM from POP10310 where PONUMBER = @PONUMBER

    union select POPRCTNM from POP10500 where PONUMBER = @PONUMBER

    union select POPRCTNM from POP30310 where PONUMBER = @PONUMBER

    print 'POP PO info'

    print '=================================================================================='

    print ''

    if exists (select * from POP10100 where PONUMBER = @PONUMBER)

    Begin

    print 'POP10100 - Purchase Order Work'

    select * from POP10100 where PONUMBER = @PONUMBER

    End

    if exists (select * from POP10110 where PONUMBER = @PONUMBER)

    Begin

    print 'POP10110 - Purchase Order Line'

    select * from POP10110 where PONUMBER = @PONUMBER

    End

    if exists (select * from POP10150 where POPNUMBE = @PONUMBER)

    Begin

    print 'POP10150 - Purchase Order Comment (header)'

    select * from POP10150 where POPNUMBE = @PONUMBER

    End

    if exists (select * from POP10550 where POPNUMBE = @PONUMBER)

    Begin

    print 'POP10550 - Purchasing Comment (line)'

    select * from POP10550 where POPNUMBE = @PONUMBER

    End

    if exists (select * from POP10160 where PONUMBER = @PONUMBER)

    Begin

    print 'POP10160 - Purchase Order Tax'

    select * from POP10160 where PONUMBER = @PONUMBER

    End

    if exists (select * from POP30100 where PONUMBER = @PONUMBER)

    Begin

    print 'POP30100 - Purchase Order History'

    select * from POP30100 where PONUMBER = @PONUMBER

    End

    if exists (select * from POP30110 where PONUMBER = @PONUMBER)

    Begin

    print 'POP30110 - Purchase Order Line History'

    select * from POP30110 where PONUMBER = @PONUMBER

    End

    if exists (select * from POP30160 where PONUMBER = @PONUMBER)

    Begin

    print 'POP30160 - Purchase Order Tax History'

    select * from POP30160 where PONUMBER = @PONUMBER

    End

    print 'POP All apply info for PO'

    print '=================================================================================='

    print ''

    if exists (select * from POP10500 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10500 - Purchasing Receipt Line Quantites'

    select * from POP10500 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP10600 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10600 - Purchasing Shipment Invoice Apply'

    select * from POP10600 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    end

    print 'POP All work receipt info for PO'

    print '=================================================================================='

    print ''

    if exists (select * from POP10300 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10300 - Purchasing Receipt Work'

    select * from POP10300 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP10306 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10306 - Purchasing Receipt User-Defined'

    select * from POP10306 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP10310 where PONUMBER = @PONUMBER)

    Begin

    print 'POP10310 - Purchasing Receipt Line'

    select * from POP10310 where PONUMBER = @PONUMBER

    End

    if exists (select * from POP10330 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10330 - Purchasing Serial Lot Work'

    select * from POP10330 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP10360 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10360 - Purchasing Tax'

    select * from POP10360 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP10390 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10390 - Purchasing Distribution Work'

    select * from POP10390 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP10700 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP10700 - Purchasing Landed Cost'

    select * from POP10700 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    print 'POP All history receipt info for PO'

    print '=================================================================================='

    print ''

    if exists (select * from POP30300 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP30300 - Purchasing Receipt History'

    select * from POP30300 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP30310 - Purchasing Receipt Line History'

    select * from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP30330 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP30330 - Purchasing Serial Lot History'

    select * from POP30330 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP30360 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP30360 - Purchasing Tax History'

    select * from POP30360 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP30390 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP30390 - Purchasing Distribution History'

    select * from POP30390 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from POP30700 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'POP30700 - Purchasing Landed Cost History'

    select * from POP30700 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    print 'Inventory'

    print '=================================================================================='

    print ''

    if exists (select RCPTNMBR, * from IV10200 where RCPTNMBR in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'IV10200 - Inventory Purchase Receipts Work'

    select RCPTNMBR, * from IV10200 where RCPTNMBR in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from IV30300 where DOCTYPE = 4 and DOCNUMBR in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'IV30300 - Inventory Transaction Amounts History'

    select * from IV30300 where DOCTYPE = 4 and DOCNUMBR in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from IV30301 where DOCTYPE = 4 and DOCNUMBR in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'IV30301 - Inventory Transaction Detail History'

    select * from IV30301 where DOCTYPE = 4 and DOCNUMBR in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select * from IV30302 where DOCTYPE = 4 and DOCNUMBR in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'IV30302 - Inventory Transaction Bin Quantities History'

    select * from IV30302 where DOCTYPE = 4 and DOCNUMBR in (select POPRCTNM from ##POPRCTNM)

    End

    -- shouldn't be any records in IV30400 (Item Serial/Lot Hist)

    -- shouldn't be any records in IV30500 (INV Dist History)

    print 'Payables'

    print '=================================================================================='

    print ''

    if exists (select b.POPRCTNM, a.*

    from PM00400 a

    join POP30300 b on a.CNTRLNUM = b.VCHRNMBR

    where a.DOCTYPE = 1 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'PM00400 - PM Keys'

    select b.POPRCTNM, a.*

    from PM00400 a

    join POP30300 b on a.CNTRLNUM = b.VCHRNMBR

    where a.DOCTYPE = 1 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select b.POPRCTNM, a.DOCNUMBR, a.DOCTYPE, a.VCHRNMBR, 2 as Status, a.VENDORID, a.TRXSORCE, a.DOCDATE, a.DOCAMNT, a.CURTRXAM

    from PM20000 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.DOCTYPE = 1 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    union select b.POPRCTNM, a.DOCNUMBR, a.DOCTYPE, a.VCHRNMBR, 3 as Status, a.VENDORID, a.TRXSORCE, a.DOCDATE, a.DOCAMNT, a.CURTRXAM

    from PM30200 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.DOCTYPE = 1 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'PM20000/PM30200 - PM Open / PM History'

    select b.POPRCTNM, a.DOCNUMBR, a.DOCTYPE, a.VCHRNMBR, 2 as Status, a.VENDORID, a.TRXSORCE, a.DOCDATE, a.DOCAMNT, a.CURTRXAM

    from PM20000 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.DOCTYPE = 1 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    union select b.POPRCTNM, a.DOCNUMBR, a.DOCTYPE, a.VCHRNMBR, 3 as Status, a.VENDORID, a.TRXSORCE, a.DOCDATE, a.DOCAMNT, a.CURTRXAM

    from PM30200 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.DOCTYPE = 1 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    if exists (select b.POPRCTNM, a.VCHRNMBR, a.TRXSORCE, 2 as Status, a.DSTSQNUM, a.DEBITAMT, a.CRDTAMNT, a.DSTINDX

    from PM10100 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.CNTRLTYP = 0 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    union select b.POPRCTNM, a.VCHRNMBR, a.TRXSORCE, 3 as Status, a.DSTSQNUM, a.DEBITAMT, a.CRDTAMNT, a.DSTINDX

    from PM30600 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.CNTRLTYP = 0 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    Begin

    print 'PM10100/PM30600 - PM Dist open / PM Dist History'

    select b.POPRCTNM, a.VCHRNMBR, a.TRXSORCE, 2 as Status, a.DSTSQNUM, a.DEBITAMT, a.CRDTAMNT, a.DSTINDX

    from PM10100 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.CNTRLTYP = 0 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    union select b.POPRCTNM, a.VCHRNMBR, a.TRXSORCE, 3 as Status, a.DSTSQNUM, a.DEBITAMT, a.CRDTAMNT, a.DSTINDX

    from PM30600 a

    join POP30300 b on a.VCHRNMBR = b.VCHRNMBR

    where a.CNTRLTYP = 0 and b.POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    End

    print 'GL'

    print '=================================================================================='

    print ''

    if exists (select ORDOCNUM, JRNENTRY, 1 as Status, sum(DEBITAMT) as Sum_DEBITAMT, sum(CRDTAMNT) as Sum_CRDTAMNT from GL10001 where ORDOCNUM in (select POPRCTNM from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)) group by ORDOCNUM, JRNENTRY

    union select ORDOCNUM, JRNENTRY, 2 as Status, sum(DEBITAMT) as Sum_DEBITAMT, sum(CRDTAMNT) as Sum_CRDTAMNT from GL20000 where SERIES = 4 and ORDOCNUM in (select POPRCTNM from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)) group by ORDOCNUM, JRNENTRY

    union select ORDOCNUM, JRNENTRY, 3 as Status, sum(DEBITAMT) as Sum_DEBITAMT, sum(CRDTAMNT) as Sum_CRDTAMNT from GL30000 where SERIES = 4 and ORDOCNUM in (select POPRCTNM from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)) group by ORDOCNUM, JRNENTRY)

    Begin

    print 'GL10001/GL20000/GL30000 - GL work / GL open / GL history'

    select ORDOCNUM, JRNENTRY, 1 as Status, sum(DEBITAMT) as Sum_DEBITAMT, sum(CRDTAMNT) as Sum_CRDTAMNT from GL10001 where ORDOCNUM in (select POPRCTNM from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)) group by ORDOCNUM, JRNENTRY

    union select ORDOCNUM, JRNENTRY, 2 as Status, sum(DEBITAMT) as Sum_DEBITAMT, sum(CRDTAMNT) as Sum_CRDTAMNT from GL20000 where SERIES = 4 and ORDOCNUM in (select POPRCTNM from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)) group by ORDOCNUM, JRNENTRY

    union select ORDOCNUM, JRNENTRY, 3 as Status, sum(DEBITAMT) as Sum_DEBITAMT, sum(CRDTAMNT) as Sum_CRDTAMNT from GL30000 where SERIES = 4 and ORDOCNUM in (select POPRCTNM from POP30310 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)) group by ORDOCNUM, JRNENTRY

    End

    /* check if PA installed, if yes, check those tables */

    if exists (select * from sysobjects where name ='PA10600')

    begin

    print 'Project Accounting'

    print '=================================================================================='

    print ''

    if exists( select * from PA10600 where PApurordnum = @PONUMBER )

    begin

    print 'PA10600 - PA PO Work'

    select * from PA10600 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA10601 where PApurordnum = @PONUMBER )

    begin

    print 'PA10601 - PA PO Line Work'

    select * from PA10601 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA10602 where PApurordnum = @PONUMBER )

    begin

    print 'PA10602 - PA PO Tax Work'

    select * from PA10602 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA10702 where PApurordnum = @PONUMBER )

    begin

    print 'PA10702 - PA PO Receipt Line Work'

    select * from PA10702 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA10721 where PApurordnum = @PONUMBER )

    begin

    print 'PA10721 - PA PO Receipt Line Quantities Work'

    select * from PA10721 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA30600 where PApurordnum = @PONUMBER )

    begin

    print 'PA30600 - PA PO History'

    select * from PA30600 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA30601 where PApurordnum = @PONUMBER )

    begin

    print 'PA30601 - PA PO Line History'

    select * from PA30601 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA30602 where PApurordnum = @PONUMBER )

    begin

    print 'PA30602 - PA PO Tax History'

    select * from PA30602 where PApurordnum = @PONUMBER

    end

    if exists( select * from PA31102 where PApurordnum = @PONUMBER )

    begin

    print 'PA31102 - PA PO Receipt Line History'

    select * from PA31102 where PApurordnum = @PONUMBER

    end

    end

    /* Check if Encumbrance tables exist */

    if exists (select * from sysobjects where name ='ENC10500')

    begin

    print 'Encumbrance'

    print '=================================================================================='

    print ''

    if exists( select * from ENC10100 where PONUMBER = @PONUMBER )

    begin

    print 'ENC10100 - Encumbrance PO Header'

    select * from ENC10100 where PONUMBER = @PONUMBER

    end

    if exists( select * from ENC10110 where PONUMBER = @PONUMBER )

    begin

    print 'ENC10110 - Encumbrance PO Line'

    select * from ENC10110 where PONUMBER = @PONUMBER

    end

    if exists( select * from ENC10500 where PONUMBER = @PONUMBER )

    begin

    print 'ENC10500 - Encumbrance Received Transactions (POs)'

    select * from ENC10500 where PONUMBER = @PONUMBER

    end

    if exists (select * from ENC10500 where POPRCTNM in (select POPRCTNM from ##POPRCTNM))

    begin

    print 'ENC10500 - Encumbrance Received Transactions (Receipt)'

    select * from ENC10500 where POPRCTNM in (select POPRCTNM from ##POPRCTNM)

    end

    if exists( select * from ENCAA10110 where PONUMBER = @PONUMBER )

    begin

    print 'ENCAA10110 - Encumbrance AA PO Line'

    select * from ENCAA10110 where PONUMBER = @PONUMBER

    end

    end

    /* Check if HITB tables exist */

    if exists (select * from sysobjects where name ='SEE30303')

    begin

    print 'HITB'

    print '=================================================================================='

    print ''

    if exists (select * from SEE30303 where PONUMBER = @PONUMBER )

    begin

    print 'SEE30303 - HITB Transaction History Detail'

    select * from SEE30303 where PONUMBER = @PONUMBER

    end

    end

    set nocount off

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans