web
You’re offline. This is a read only version of the page.
close
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) / PO Line Status
Microsoft Dynamics GP (Archived)

PO Line Status

(0) ShareShare
ReportReport
Posted on by Palma Hirschfelder ... 565

Hello GP Folk,

I have a PO with open line items that we cannot receive against (there was a power outage in the midst of receiving the items). 

A query of POP10100 listed the PO status as "2".  A query of POP10110 listed the PO line item status as "2".  (Items received on prior days had a status of "4".)

Where can I find out what the status indicators mean?  I searched knowledgebase articles but couldn't come up with anything. 

If you can help, thanks in advance!

Palma

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Palma,

    There are 2 ways that you can find this information;

    • Tools - Resource Description - Tables - click on button with the 3 dots - choose the series you are trying to look up (in this case Purchasing)  - personally I then change the view to Physical Name - find the table you want and click on it.  In the next window find the field you are interested in (in this case PO Status) and click on the Field Info button and if it is in the system it will open and give you the definitions.
    • However, something I would suggest is that you look into purchasing Information Flow and Posting written by Accolade Publications (I do not work for them!! nor do I get any commission, etc.!), this book talks about what happens during the various steps of the transaction process including which tables are updated and when.  Plus at the back of the book it has a section that gives you a quick reference of a lot of these fields.  I bought ours in 2005, and I refer back to it on a regular basis.

    Hope this helps!

    Jennifer Pegg

    Engine Control Systems Limited

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Palma, have a look at this excellent reference from Victoria Yudin - http://victoriayudin.com/gp-reports/pop-tables/.

  • Palma Hirschfelder Wurzel Profile Picture
    Palma Hirschfelder ... 565 on at

    That is a very good reference, Frank, thanks.  I also wandered through the field info in the resource descriptions - I'd never gotten into that much detail before.

    Now that I've determined that the PO and PO Line status are as they should be, I think the problem may be a locked session.  I believe I'll need to follow the normal process to clear it: have all users logout, backup all databases, and query DEX_LOCK and DEX_SESSION in tempdb.  Delete if necessary.  Then do the same for ACTIVITY, SY0800 AND SY00801 in the Dynamics database.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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