Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Unable to select the r...
Microsoft Dynamics GP (Archived)

Unable to select the receipt line for purchase return

(0) ShareShare
ReportReport
Posted on by Wong Henry 1,070

Hi,

I am having an issue where I am unable to select the receipt line for an item during the purchase return entry in GP 2013 - SP2.

Below is the receipt line which I can pick for the purchase return.

After selecting the 1st receipt line of 18 quantity, I am not able to select the remaining 2nd receipt line of 1 quantity as below:-

I have tried to run checklinks and inventory reconcile which did not help as I am still unable to pick the 2nd receipt line for the purchase return.

I have also check the item in the receipt is not allocated or sold.

Therefore, I would like to know what could be the cause of not allowing to pick the receipt line for purchase return.

Thank you,

Henry

*This post is locked for comments

  • Verified answer
    Wong Henry Profile Picture
    Wong Henry 1,070 on at
    RE: Unable to select the receipt line for purchase return

    Thank you for both your reply Thomas and Al Saadi,

    I managed to identified the cause of the issue.

    It was in the POP10500, the qtyreserved and qtyinvreserve for the item was not 0.

    In the end, I updated the qtyreserved and qtyinvreserve both to be 0 in POP10500. After that, I ran checklinks and I was able to select the item for the purchase return transaction entry.

    Thank you,

    Henry

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Unable to select the receipt line for purchase return

    This is a frequently asked question, it is definitely related to the original cost layer and whether it is consumed or available in your inventory module. I would like to add up one thing to what's mentioned above by Thomas, if the value returned for the RCPTSOL (receipt sold) field is 1, then you need to check the quantity sold field, which will give you an indicator of what's remaining in this cost layer.

    When someone asks about return, there is a comprehensive article which comes to my mind immediately, it is PO Returns Not Allowed by Richard L. Whaley. There are interesting and yet brief facts which will be of an added value to you in this case.

    Please never hesitate to share any further inquiries,

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Unable to select the receipt line for purchase return

    Hi Wong Henry!

    Thank you for this question, it could be that the receipt line item in the inventory tables has been sold completely so you wouldn't be able to create a POP Return for that line.

    select * from IV10200 where RCPTNMBR = XXX

    Please replace XXX with the Receipt number.

    What is the value of the RCPTSOLD Field?

    If the value is a 1 then it has been completely sold which would be why you are unable to select it.

    Please let us know!

    ~Thomas Newcomb

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

    Microsoft Dynamics GP Support

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

    This posting is provided "AS IS" with no warranties, and confers no rights

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans