Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

PO Line Item Status - Reason Closed

PO Line Item Status - Reason Closed

PO Line Item Status - Reason Closed

Is there a way to determine how/why a PO line item got closed?

I had gotten a response from barbola at one time that:


The only way a PO/line can be closed is after the receiving has been matched against OR someone has manually cancelled/closed the PO or its lines.

We can't enter/match an invoice because the items HAVE been closed - now I'm trying to find out WHY so we can enter the invoice for them.

Any ideas?


RE: PO Line Item Status - Reason Closed

Here is a possible scenario:
- Someone starts entering a matching invoice, which updates the statuses on the PO.
- That user crashes out before the invoice entry is completed, however, so the invoice is not accessible in the UI.
- To fix the issue the invoice is deleted directly in SQL. However, the PO line item statuses are still updated.

I am not saying this happened in your case, in fact there is really no way to prove this unless you are doing some independent tracking at the SQL level, just giving you one scenario where this is possible.  

Typically, when researching this kind of issue, I look at all unposted POP invoices that might be affecting this PO, and all possible documents linked to this PO in the POP tables.  I also look at each line item's Purchasing Quantity Status (click on the item on the PO, then click the icon with the i in a circle.  Sometimes Reconcile Purchasing Documents will fix issues with line items and statuses, but often you need to fix these directly in SQL.

Victoria Yudin
Dynamics GP MVP 2005 - 2011
Use Crystal Reports and SSRS with GP:
blog: http://victoriayudin.com

RE: PO Line Item Status - Reason Closed

Thanks Victoria.

That does make a lot of sense, and while the user says it didn't crash on them - I've had people deny it before when it most definitely has.  That does sound like a likely scenario.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close