PO Commitments and Historical Sales Documents

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: 10.0/10 (1 vote cast)
VA:F [1.9.22_1171]
Rating: 0 (from 0 votes)
PO Commitments and Historical Sales Documents, 10.0 out of 10 based on 1 rating

September 23, 2010 ·  · No Comments
Tags: , , , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,020