Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Item Master IN Use Account

Posted on by 280

Good afternoon,

I have a question in regards to the in-use account on the Item Class Accounts screen and the Item Accounts Screen.  Currently I have not been able to find any documentation on this field and the on-line help within GP is not the most intuitive.

Currently the organization that I work for is running GP2010 R2.  We have been looking into using this field to hold an account that we require for a modification that we are looking into.  Before we decide on whether this is the correct location to store this account we would like to know what this account is used for within the application. 

If it turns out that there is functionality within GP that may require in the future then we would need to re-look at where we could store the data.

 

Any help on this would be greatly appreciated.

 

Thanks

Don

 

 

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Item Master IN Use Account

    The functionality that uses this account just allows you to seperate your stock quantities. Only On Hand quantities can be sold. You could use one of the user defined fields to record the account code (although you would need to mask the field for account format to prevent mistakes - plus there would be no account master validation).

    It might be better to consider creating a new window and table to store this info - and validate all inserts against the account master.

    Ian.

  • Don Craig Profile Picture
    Don Craig 280 on at
    Re: Item Master IN Use Account

    Thank you for the help on this.

    Don

  • Suggested answer
    Bron Profile Picture
    Bron 4,887 on at
    Re: Item Master IN Use Account

    Don - GP allows users to put inventory into 'buckets'. If you go to Inquiry > Inventory > Item - there will be fields that store quantity values - 'Returned', 'Damaged' 'In Service' 'In Use'.

    In the Inventory Transfer entry screen = you can choose 'Quantity Type' as a transfer - thus 'transferring' a qty 'On Hand' to 'In use'. During SOP returns - I think you can also return items into the various 'buckets'.

    MBS designed the functionality in order to keep inventory accurate while giving the user ability to 'separate' usable saleable inventory from non usable saleable inventory.

    The GL JE would use that account as a posting account.

    Hope this makes sense.........

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans