Information about when to run file maintenance routines in Project Accounting

Applies to: Dynamics GP 2013Dynamics GP 2010

INTRODUCTION


This article contains information that can help you determine when to run file maintenance routines and which ones to run in Microsoft Dynamics GP Project Accounting.

More Information


Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the company database that you can restore if a problem occurs. 

The PA Check Links routine will validate data between tables within a table group. For example if you have a timesheet transaction that exists in the line detail table, but no record for it is in the header table, PA Check Links will likely remove that document from the tables where it exists.

PA Check Links should not need to be run very often, however if you have experienced an interruption in posting it may be beneficial to run it to clear out any orphaned records. 

1. To run the Project Accounting Check Links process, follow the appropriate step:

In Microsoft Dynamics GP 10.0 or later, point to Maintenance on the Microsoft Dynamics GP menu, and then click PA Check Links.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Maintenance on the File menu, and then click PA Check Links.

2. In the Logical Tables area, click to highlight a selected table group. Click Insert to select the table, and then click OK.

3. Choose the destination for your File Maintenance Error Log Report.

Note It is recommended to print a hard copy (either to the printer or a file) for review since there is no opportunity to reprint this report.



The PA Reconcile utility will compare the values in the detail or transactional tables to the summary master records. The values in the detail tables are used to change the summary values if there is a discrepancy. Therefore, if you notice that summary values on a contract, on a project, or on a budget are incorrect, this process will correct those values.

You may want to run this process on a monthly basis to ensure your values are correct for reporting purposes. If no changes are made, then run the process quarterly or yearly. If many changes are made, you may need to increase the frequency in which you run it.

1. To run PA Reconcile, follow the appropriate step:

In Microsoft Dynamics GP 10.0 or later, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Project, and then click PA Reconcile.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Utilities on the Tools menu, point to Project, and then click PA Reconcile.

2. Click the following items in the Reconcile Totals area, and then click Process after you click each item.

Note The sequence in which these processes are run is not important. However, for items that have the Posted check box or the Unposted check box available, make sure that both check boxes are selected for the item.

Budgets and fees

Cost Transactions

Committed Costs

Billing Transactions

RR Transactions

Cash Apply

Earnings and Cost of Earnings

Change Orders

3. Choose the destination for your PA Reconcile Log Report. 

Note It is recommended to print a hard copy (either to the printer or a file) for review since there is no opportunity to reprint this report.



The PA Recreate Periodic utility has 2 functions. The Options drop-down allows you to choose Recreate Periodics or Delete Periodic Records Outside Fiscal Years. The Recreate Periodics process will create missing periodic records for your customer (PA00511), contract (PA01121), project (PA01121) and budgeted cost categories (PA01304). You should have a record for each period in your year, as well as a summary record. Your periodic records should exist for however many periods your budgeted cost category spans taking the earliest of your budget or actual start date and latest of your budget or actual end date.

You should run PA Recreate Periodic when you find there are missing or incorrect periodic records. You should run the option to Delete Periodic Records Outside Fiscal Years if a budget was first set up with an incorrect date and you want to remove invalid periodic records after the date has been corrected.

1. To run PA Recreate Periodic, follow the appropriate step:

In Microsoft Dynamics GP 10.0 or later, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Project, and then click PA Recreate Periodic.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Utilities on the Tools menu, point to Project, and then click PA Recreate Periodic.

2. Select the customer or range of customers to run the utility for.

Note The PA Recreate Periodic process can be time consuming so plan accordingly or choose to run it for only the customers necessary.

3. In the Options drop-down, select Recreate Periodic or Delete Periodic Records Outside Fiscal Years, and then click Process.

4. Choose the destination for your PA Recreate Periodic Log Report.

Note It is recommended to print a hard copy (either to the printer or a file) for review since there is no opportunity to reprint this report.



The PA Reconcile Periodic utility must be run after you complete the PA Recreate Periodic process to fully populate the new periodic records that have been created. The reconcile uses the transactional tables to compare, and change if necessary, the summary periodic records. It is also recommended to run PA Reconcile Periodic prior to creating revenue recognition transactions to ensure the values used for revenue recognition are accurate. Several reports, including the Performance reports, pull information from the periodic records so you may want to run Periodic Reconcile prior to printing these reports as well.

1. To run PA Reconcile Periodic, follow the appropriate step:

In Microsoft Dynamics GP 10.0 or later, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Project, and then click PA Reconcile Periodic.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Utilities on the Tools menu, point to Project, and then click PA Reconcile Periodic.

2. Select the customer or range of customers to run the utility for, and then click Process.

Note The PA Reconcile Periodic process can be time consuming so plan accordingly or choose to run it for only the customers necessary.

3. Choose the destination for your PA Reconcile Periodic Log Report.

Note It is recommended to print a hard copy (either to the printer or a file) for review since there is no opportunity to reprint this report. Review the Table and Record information on the report to see what changes have been made. If the information is on the report, a change has been made. The Before Reconcile and After Reconcile values will always show $0.00.



The PA Reconcile Inventory Quantities utility must be run after the Inventory Reconcile completes. This is because the Inventory (IV) Reconcile does not look at the Project Accounting data files. For example an allocation that was created from a Project transaction would be removed after the IV Reconcile completes. Running PA Reconcile IV will add that allocation back.

1. To run PA Reconcile Inventory Quantities, follow the appropriate step:

In Microsoft Dynamics GP 10.0 or later, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Project, and then click PA Reconcile IV.

In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Utilities on the Tools menu, point to Project, and then click PA Reconcile IV.

2. Select the item or range of items to run the utility for, and then click Process.

3. Choose the destination for your Inventory Reconcile Report.

Note It is recommended to print a hard copy (either to the printer or a file) for review since there is no opportunity to reprint this report.

References


For more information about the PA Reconcile IV process, see KB article 864622.

864622 Information about the order in which the reconcile procedures should be run in Microsoft Dynamics GP
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-US;864622