PO Commitments and Historical Sales Documents

| 09/23/2010 | 0 Comments

A couple of my clients have experienced an interesting issue lately. Purchase order are tied to sales documents that are already moved to history. This puts the PO in a limbo state where it cannot be closed or cancelled. I don’t know for sure the exact sequence of events that causes this but here is how it can be resolved:

1. Delete the records in the SOP60100 table related to the offending PO number. (Standard disclaimer about modifying SQL data applies here. If you are unfamiliar with SQL queries and/or Dynamics GP table structure, please call your partner for assistance.)

2. Reconcile the offending PO number.

3. Edit the PO and change the status to Cancelled.

Read the rest here:
PO Commitments and Historical Sales Documents

VA:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VA:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , , , , , , , , , , , ,

Category: Blogs I Follow

About the Author ()