web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

how an Inventory Item gets entered as Non-Inventory Item while creating Purchase Orders

(0) ShareShare
ReportReport
Posted on by 4,156

we are using GP2010 and here is the situation which is leading nowhere

  • an Item is listed as Sales Inventory in Item Master
  • when a Buyer enters a PO and I look at the "Purchase Item Detail Entry" screen the Item Type is listed as " Non-Invnetory"
  • When I enter PO fo the same item, it is fine and listed as Inventory item.
  • Receiving receives that item as non-inventy but when we do the Invoice matching, it gives an error being an Inventory item it can't be matched as non-invnetory.

Questions

  1. Does this have to do soemthing with GL account attached to that item?
  2. From where this filed " Item Type" comes from ?
  3. is this from Item Master where Misc. gets translated as non-Invnetory ?
  4. I see this column in POP10100 table but nowhere else.
  5. Is there a way to manully adjust this field ?

Please help

Regards,

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Dan Liebl Profile Picture
    7,320 on at

    Could the other user be entering in a '0' instead of 'O', or even an upper case i instead of a 1?  In cases such as this it is generally the user just entering in data without using lookups.   Another similar issue I have seen is the PO getting entered before the item is entered.   As far as updating data, I think it is far easier to build a business process than to start editing tables.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Syrus Profile Picture
    4,156 on at

    Dan,

    thank you very much for your reply. User is not able to make any changes to that field neither makeing any change is not even aware of this field.

    Also, Not using lookup will have no impact, as the item already exists in item master and GP will error out if item being created as new.

    I wonder how this field in PO Entry screen is being populated and where it is. I am also not trying to updae the data but need to find out what is going on with field to correct the Business process.

  • Syrus Profile Picture
    4,156 on at

    Somehow I figured it out. Since we are not maintaining Inventory Module, the item do not exist and when User just types it without looking into Inventory, GP allows and considers it as NON Inventory.

    Thanks everyone

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans