Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RMA Site RETURN qty go...
Microsoft Dynamics GP (Archived)

RMA Site RETURN qty goes to OnHand

(0) ShareShare
ReportReport
Posted on by Community Member

Hello, I setup a RETURNS site to be used by the RMA process however it seems like when items are received into the RETURNS site they go into On-Hand qty.  Not Returned.  So when you go into Item Quantities Maintenance screen and select All sites it looks like you have more sellable inventory then you actually have for that item and the Returned Qty is not reflective of the items that are returned.  Any way to have the items returned via RMA to be put into the Returned Qty until we can check them out?

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: RMA Site RETURN qty goes to OnHand

    First, Thanks!

     

    Second, we also need to ensure that the "QUANTITY" columns in IV00102 are addressed as well as flipping the "QTYTYPE" in iv00112. The above scripts didn't address that table. Also, I will be doing the add returned to on-hand in our case. I think I have the SQL syntax figured out for that!

     

    Thanks again,

    Sheldon

    our reconciles take forever. So, we are going to be running our Inventory reconcile over the 4 day Christmas break

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    Re: RMA Site RETURN qty goes to OnHand

    A little SQL script would do the trick . . .

    -- Step 1 - make quantity on hand = quantity returned

    UPDATE IV00102

    SET  QTYONHND = QTYRTRND

    WHERE QTYRTRND > 0

    -- Step 2 - set quantity returned to zero

    UPDATE IV00102

    SET QTYRTRND = 0

    Now, bear in mind. this will make the quantity on hand = to the quantity returned, it won't add the quantity returned to the current quantity on hand.  If you need the latter, let us know, you'll need a different scripting process.

    Also, you'll want to run the Inventory Reconcile Routine after executing the scripts.

  • Community Member Profile Picture
    Community Member on at
    Re: RMA Site RETURN qty goes to OnHand

    Any way any of you know how to mass update the QTYTYPE field from type 2 (returned) to type 1 (on-hand). We had many users who did not realize that they were supposed to return the stock to on hand. (We don't use the RMA module). So now I have hundreds of items sitting in quantity type 2 and the only way I know of move them to "on hand" is to literally "transfer" them from "returned" to "On-hand". which if you have done this for more than one part you will realize it is a total pain...

    HELP

    Sheldon

  • Ken Roy Profile Picture
    Ken Roy 490 on at
    Re: RMA Site RETURN qty goes to OnHand

    Sorry for the confusion and thanks for figuring it out..

    I didn't even know there was an RMA system.  

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    Re: RMA Site RETURN qty goes to OnHand

    Ahhh, that's not in the RMA system.  It's a Sales Return Entry, not a Returned Materials Authorization Entry.  Mystery partially solved.  Thanks Ken!

  • Ken Roy Profile Picture
    Ken Roy 490 on at
    Re: RMA Site RETURN qty goes to OnHand

    Frank,

    They must have changed it after GP 10.  As soon as I tab off the QTY entered it pops up for me.  

    Here's what it looks like:

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    Re: RMA Site RETURN qty goes to OnHand

    I tested this Ken and I don't get the Returned Quantities Entry screen when entering the Qty.  This is on GP2010.  I checked RMA Setup but couldn't find anything that would turn that window on . . .

  • Ken Roy Profile Picture
    Ken Roy 490 on at
    Re: RMA Site RETURN qty goes to OnHand

    Jimmy,

    I just did this in my test site to confirm when I return parts using an RMA.  I enter the Item qty in the RMA and the Sales Returned Qantities Entry screen pop's up.  I  put the QTY in RETURNED instead of ON HAND and posted.  My Total Stock went up but my ON HAND and AVAILABLE stayed the same.  RETURNED now shows the returned parts QTY.  

    I'm running GP 10.  Is this not how your system is working?  

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    Re: RMA Site RETURN qty goes to OnHand

    I agree Jimmy.  You should submit a suggestion to Connect to have this change made.  They're working on GP "12" now and perhaps could get this in prior to release.  I'll vote for the change.  https://connect.microsoft.com/.

  • Community Member Profile Picture
    Community Member on at
    Re: RMA Site RETURN qty goes to OnHand

    Frank, I believe you are right, the only way is to do an inventory transfer and transfer from on-hand in Returns site to returned status into Main site then evaluate the items and if ok, do another inventory transfer from returned to oh-hand. Kind of a bummer rma inventory goes into on-hand when you would think it would go into returned.  GP does provide a shortcut if you know the items can be resold by providing a Return to Stock button.  But I still think the items should be returned into returned status until you get a chance to evaluate it.  Thanks!

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,850 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans