Information about a billing invoices report that is similar to AIA reporting for construction billing for Microsoft Dynamics GP


RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

INTRODUCTION

The PA Invoice Format Project Summary Page 1 billing invoice and the PA Invoice Format Contract Summary Page 1 billing invoice in Project Accounting can be modified to display the necessary information for a report similar to AIA reporting.

Use the following links to download sample package files :

PA Invoice Format Project Summary Page 1 billing invoice

The following file is available for download from the Microsoft Dynamics File Exchange Server:

       https://mbs.microsoft.com/fileexchange/?fileID=00578598-5215-4d42-870a-435bfe849346

Release Date: June 24, 2009

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

PA Invoice Format Contract Summary Page 1 billing invoice

The following file is available for download from the Microsoft Dynamics File Exchange Server:
 

       https://mbs.microsoft.com/fileexchange/?fileID=043b142d-fb74-43f6-8ed7-9319d5a35298

Release Date: June 24, 2009

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Note The package file can be used for Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0, and Microsoft Business Solutions - Great Plains 8.0.

MORE INFORMATION

The following computations are made for the AIA fields for downloaded reports from the Reports Library:

Contractor's Application for Payment

 

 • Original Contract Sum 

PA Project Amount - PA Total Change Order Amount

 Note The PA Total Change Order Amount field contains unapproved change order amounts and approved change order amounts. 

• Net change by Change Orders 

 PA CO Baseline Project Amount + PA CO Baseline Fee Project Amount 

The fields in the calculation exist in one of the following tables: 

     • Project level report: PA Project CO Periodic Totals MSTR table (PA01222)

     • Contract level report: PA Contract CO Periodic Totals MSTR table (PA01122) 

The PA CO Baseline Project Amount field contains one of the following: 

     • Approved change order baseline budget amounts for FP projects

     • Approved change order forecast budget amounts for CP and T&M projects 

The PA CO Baseline Fee Project Amount field contains the approved change order fee amount for Project and Service Fees. 

Note The periodic table range is the current billing period based on the billing cutoff date. 

• Contract Sum to Date 

Original Contract Sum + Net Change by Change Orders 

• Total Completed Stored to Date 

Previous actual billings + current billable amount 

     • current billable amount 

     T&M Billable Amount + CP/FP Billable Amount + Project Fees + Service Fees 

     • previous actual billings 

     PA Actual Billings field (PAPostedBillingsN) from the PA Project Periodic Totals MSTR table or the PA Contract Periodic Totals MSTR table

     Note The periodic table range is from the current billing period based on the billing cutoff date.

 • Retainage 

Previous actual retention amount + the current retention amount 

     • previous actual retention amount PA Actual Retention Amount field (PAPOSTRETAMT) from the PA Project Periodic Totals MSTR table or the PA Contract Periodic Totals MSTR table 

     Note The periodic table range is from the current billing period based on is computed as previous actual retention amount plus the current retention amount. 

• Total Earned less Retainage

 Total Completed Stored to Date - Retainage 

• Less Previous Certificates for Payment 

 Actual billings - actual retention amount.

 • Current Payment Due 

Total Earned Less Retainage - Less Previous Certificates for Payment. 

Note This amount will match the total amount due for the project or contract because it does not include taxes, retention fees, and retainer fees. 

• Balance to Finish, including Retainage 

Contract Sum to Date - Total Earned Less Retainage. 

 

Change Orders Summary 

 

• Total approved this month 

PA CO Baseline Project Amount + PA CO Baseline Fee Project Amount 

The Total Approved this month field is the approved change order budget and fee amount for the current billing period based on the billing cutoff date. 

The fields in the calculation exist in one of the following tables:

      • Project level report: PA Project CO Periodic Totals MSTR table (PA01222) 

     • Contract level report: PA Contract CO Periodic Totals MSTR table (PA01122) 

• Total changes approved in previous months by Owner

 Net change by Change Orders - Total approved this month.

 • Net changes by Change Order 

Total changes approved in previous months by Owner + Total approved this month. 

 

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

 THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Query:  replaces KB 872190