Manually “Closed/Canceled” Purchase Order still shows in Inquiry as Open Purchase Order with "Closed/Canceled" Status.

When user “Closed or Canceled” the purchase Order from Transaction-->Purchasing-->Edit Purchase Order those Purchase Order still show in Inquiry--->Purchasing--->Purchase Order Documents as Open PO .

Remove the Completed PO from Tools-->Routines--->Purchasing ---> Removed the Completed Purchase Order.

Once the Completed Purchase Order Removed it won’t appear in Inquiry as Open Purchase Orders.

PS: Sometime I saw the fully Received Purchase Order still show in Purchase Order Inquiry as Open PO, Follow the above solution to resolve the issue.

Microsoft Mainstream support for GP

Microsoft Business Solutions Great Plains 8.0
Support for Microsoft Business Solutions Great Plains 8.0 Ends October 13, 2009

Microsoft Dynamics GP 9.0
Support for Microsoft Dynamics GP 9.0 End 1/11/2011
http://support.microsoft.com/lifecycle/?LN=en-us&p1=10479&x=9&y=8

Microsoft Dynamics GP 10.0
Support for Dynamics GP 10.0 End 10/10/2012 – Extended Support End at 10/10/2017
http://support.microsoft.com/lifecycle/?p1=12629

How to find the Table and Field Information in Dynamics GP

Following steps can help you to find the Table Information in Dynamics GP.

1) Goto-->Tools-->Resource Description-->Tables

Table Names screen shows all the Table information for the specific series in above example its shows the Display, Technical and Physical Name for the Sales Series

2)Let’s find the Table Information for specific screen say : Customer Maintenance
Open the customer Maintenance screen from (Cards-->Sales -->Customer)
Goto --> Tools -->Integrate -->Table Import

These are the Display Name of Table used for the for Customer Maintenance Screen.
You can use the "First Example" to find the Physical Name for Customer Maintenance Screen

1) User can find the Window specific table information from
GOTO-->Tools-->Resource Description -->Windows

Again it shows the “Display Name“of all tables for “Customer Maintenance”.. you can follow the first step to find the “Physical Name”.

4) Even from Dynamics GP Report user can find the Table information used for that Report
Print the Report on Screen-->Click on “Modify” button.

Select any field from Report Layout and on Right Hand Side “Toolbar” it will show the Table Name like “RM_Customer_MSTR”
Again.. to find the “Physical Name” .. you don’t have to goto Dynamics GP , on Report Window Click on “Tables-->Tables”

Search for “RM_Customer_MSTR” ---> select and click on “Open” and it will show the “Physical Name”.

Lots of screen shot... Hope it will help you to find the table information!!!

Budget with Date Range

Budgets in Finance (Cards-->Financial-->Budgets) is no longer limited for the specific year now we can span –give the date range.

On Dynamics GP 10.0 new field “Based On” is available which allow the user to decide the New Budget is based on Fiscal year or with Date Range.

When the Date Range is selected it allowed the user to enter the start Date and End Date.


Dynamics GP 9.0





Dynamics GP 10.0