Purchase Order 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 purchase order 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 purchase 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 purchase order number.

3. Edit the purchase order and change the status to Cancelled.

You may also like

What a Great A/R Approach Looks ...
on February 18, 2020
business software

Just like anything else in business, your accounts receivable process should be planned out, ...

commentIcon 0 Comments
Staff Author
Why You Should Use Templates for ...
on February 11, 2020
business software

When it comes to managing accounts receivable, asking for money is never easy – especially in ...

commentIcon 0 Comments
Staff Author
How to Write the Third Collection ...
on January 21, 2020
business software

Making collection calls is no fun. In fact, some companies let their past due accounts pile up ...

commentIcon 0 Comments
Staff Author
How to Write the Second Collection ...
on January 21, 2020
business software

It’s not exactly a newsflash ... making collection calls is no fun. In fact, some companies let ...

commentIcon 0 Comments
Staff Author
How to Write the First Collection ...
on January 21, 2020
business software

Let’s face it, making collection calls is no fun. In fact, some companies let their past due ...

commentIcon 0 Comments
Staff Author
How to Prepare for and Make ...
on January 29, 2020
business software

Wouldn’t it be great if every time you send a collection letter, your customers respond and pay the ...

commentIcon 0 Comments
Staff Author