Have you ever encountered a Purchase Order in Microsoft Dynamics GP that was still open but should be closed? I had a customer run into this problem recently. Here’s what I did to fix it.
First, I reviewed the Purchase Order process the client used. We entered a PO like this one.
Next, we entered the Receipt in Dynamics GP.
Then we entered the matching invoice.
In this example, the Purchase Order was for a quantity of 10, the received quantity was 10, and the invoice matched for 10. The PO automatically closes after the invoice match is posted.
Now, let’s take a look at the problem PO. Under the Edit Purchase Order screen, you can see it is not closed.
The process the client used was as follows. Enter PO as below.
The PO Receipt was created for 5.
The PO Invoice was then entered. Do you see the problem yet?
Notice, only 4 items were received. This meant that 5 were ordered, 5 were received, but only 4 were invoiced. An easy way to find this information is by running a “Purchase Order Received Not Invoiced” report.
For my customer, we found they had received a separate invoice for the one piece and entered this as a straight AP invoice. This prevented the loop from closing.
So, we manually closed the PO using Edit Purchase Order. While working with my customer, I found that due to their business process, they had a lot of other open Purchase Orders that should be closed. To eliminate this error and reduce extra manual work, I developed a Macro to automatically close the Purchase Order when this happened. It saved them lots of time and mistakes, and in the future, they now have a way to easily close their Purchase Orders.
If you’d like more information or need assistance with your Dynamics GP system, email us at firstname.lastname@example.org.