Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Distinguishing between sellable and nonsellable inventory in GP

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all,

I am new to GP and was wondering if there would be a way to separate sellable and nonsellable inventory of the same product in GP (creating separate locations within a site)?

Currently both sellable and nonsellable inventory is grouped under Qty On Hand and is indistinguishable in the system. 

Would utilizing bin functionality to create separate locations within a site to separate this inventory work in this situation? How would I go about setting up this bin functionality?

Thanks!

Mark Lee

*This post is locked for comments

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Quantity Type is set from the Transaction entry screen (i.e. the screen before this one).  Did you set the quantity there?

    Ooops.  Just checked.  In-transit does not offer the Quantity Type button that a regular transfer offers.

    Tim

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Hi, there is one more thing holding us back from using the quantity types and I am wondering if there is a customizable solution. 

    In the In-Transit page, there is a button to select Serial/Lot. When I click the Serial/Lot Button, the "Transfer Line Entry - Serial" page opens up (screenshot below). In this page, I see a field that pulls from the "On Hand" quantity type below, but can't find a way to change the field to one of the other Quantity Types (for example, if we wanted to pull from the "Damaged" quantity type for this particular In-Transit Transaction). Would there be a way to customize this field in order to be able to pull from the different Quantity Types when performing an In-Transit transaction?

    6330.Screen-Shot-2015_2D00_06_2D00_22-at-4.50.04-PM.png_2D00_550x0.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Thanks Babu,

    That answered my question.

  • Verified answer
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Hi Mark,

    When you book return from customer you have option to qty to On hand, Returned, In use, In service, damaged.  So you have option where to put while qty return from the customer.  But once is the qty already gone into any of these qty type the  the transfer entry is the only way to move it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Thanks for the information Babu. One last question:

    Currently, when we receive returns, a decision is made whether to put the items into sellable or nonsellable (damaged, used, etc.) inventory.

    Would the inventory received in a "Return" transaction in the "Sales Transaction Entry" screen be placed in the "On Hand" quantity type? Is the only way to move this inventory to the other on hand quantity types (Returned, Damaged, etc.) be via a transfer entry? Or is there a way to place them into the other quantity types during the Return transaction without having to do a transfer entry?

    Regards,

    Mark

  • Verified answer
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Hi Mark,

    Please see below the difference between Item transfer entry and item transactions.

    1) Item transfer is used to move item your own location one site to another site and in this you have option to select quantity type from site to site and you can select on hand, returned, In use, In service and damaged.  this is available from site and to site.

    2) Item transaction entry will move the qty on hand to the site either issue or receive.  If you have enabled multiple bin you may select it otherwise it will increase or decrease depending on the transaction you are entering.  

    Let me know if you have any more questions.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Thanks everyone for the responses.

    In this case, a nonsellable item would be a physical item that is returned, damaged, etc. and would need to be tested and/or refurbished. We would not be able to stock them as a different inventory item number. They are stocked with a specific SKU with certain SKUs containing items that have their own unique serial number and certain SKUs containing items that do not.

    Our preference would be to set up separate locations within one site, as opposed to setting up a separate site for nonsellable items (unless we have no other option).

    Would that mean our only option would be to setup bins or would we be able to use the different on-site definitions at the same site?

    Am I correct to assume that if I use different on-site definitions, that we would be able to pull or place items from whichever specific quantity type we need (for example, pulling from Qty Damaged when shipping to be refurbished and pulling from QTY available for sales transactions)?

  • Romryan Profile Picture
    Romryan on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Mark Lee,

    If they are real items.One can create a site on GP and you call it non sellable but you need to change them from being on hand to either returned,damaged,In Use, in Service with the help of Item transfer entry (Transactions>>Inventory>>Transfer entry at the bottom you will see all these quantity type options)so that the item becomes non sellable but when its on hand then the item can be sold.

    Hope this helps

    ** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

    RomRyan

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Just a matter for clarification.

    What makes an item 'non-sellable'?

    Is it damaged, used, returned?

    If any of these, then you might consider moving the QTY to the different OnHand definitions.

    Second question, if they are returns, damage - could you stock them as a different inventory item number?  with similar number details, but with an extra character?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Distinguishing between sellable and nonsellable inventory in GP

    Tim, you might not be able to limit the choice, but you can set the default - and that might help.

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