Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Palma Hirschfelder Wurzel Profile Picture
    Palma Hirschfelder ... 565 on at
    Re: Re: Re: PO Line Status

    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.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: PO Line Status

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: PO Line Status

    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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans