Information about a billing invoices report that is similar to AIA reporting for construction billing for Microsoft Dynamics GP
This article provides information about a billing invoices report that is similar to AIA reporting for construction billing for Microsoft Dynamics GP.
Applies to: Microsoft Dynamics GP
Original KB number: 952221
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
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
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, reliability or accuracy of the information contained in the documents and related graphics published on this website (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.