Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / POP Return w/Credi...
Microsoft Dynamics GP (Archived)

POP Return w/Credit error - The quantity returned can't exceed 23

(0) ShareShare
ReportReport
Posted on by CP-Steve 285

Hi all,

Here's hoping someone can help me out on this error we receive.

A PO was received all good and well, however we now want to return one of the line items received (100 of), however, when I enter 100 in the Quantity Returned field and step off the field, I receive the following error;

The qunatity returned can't exceed 23. This is the maximum available based on the item and receipt number. Please enter a smaller quantity to return.

100 were received on the receipt, there are 160 on hand and I cannot work out where the 23 comes from??

Any ideas, suggestions or hopefully a solution would be most appreciated.

Knowledge Base search on "The quantity returned can't exceed" returned zero documents.

Google search returned three - but contained no answers.

Cheers, Steve

*This post is locked for comments

  • CP-Steve Profile Picture
    CP-Steve 285 on at
    Re: Re: Re: Re: POP Return w/Credit error - The quantity returned can't exceed 23

    Thanks, I am in North Melbourne, Victoria 3051 Australia

    Cheers, Steve

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: POP Return w/Credit error - The quantity returned can't exceed 23

    You will have to call the office to have them sent by mail.  Where are you located?  I will have them pre-calculate the postal charges.

    Office Phone -- 321-206-4690

     

  • CP-Steve Profile Picture
    CP-Steve 285 on at
    Re: Re: POP Return w/Credit error - The quantity returned can't exceed 23

    Thanks for your help. I did as suggested and thus applied the return against the opening IV transfer.

    Any chance of you being able to post me some of your books that I buy, instead of using UPS?

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: POP Return w/Credit error - The quantity returned can't exceed 23

    The FIFO/LIFO stack table maintains an entry for each receipt of each item and the PO number used to receive the item.  When you use the item, the quantity used is incremented for these lines.  You can only returned unused quantities using the Return with Credit option.

    For example, you received 100 off of PO x,  You then received another 100 off of PO y,   You issued 77 pieces and PO x was used to supply these.  When you try to return the item against PO x, only 23 that were received on that PO are available.  Now, the fact that all the items are identical and that you received both x and y from the same vendor is ignored.

    Use the other option on POs to return the items (Inventory w/ Credit)

    All of this is explained in our book, Understanding Purchase Order Processing. 

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans