Question

How to get invoices attached to the AIA report?

  • 13 January 2022
  • 4 replies
  • 410 views

Userlevel 2
Badge

Invoices are often needed provided as backup for the AIA Report. Is there a way to select invoices to be attached to the report?


4 replies

Userlevel 4
Badge

@bjeter94 I believe this could be possible if you add a SUBREPORT after the continuation sheet. The subreports could be of a single invoice or list multiple. To better familiarize with subreports, see below

Subreport lesson (Session Two)

https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/

Userlevel 5
Badge +1

Hello @bjeter94

 I believe this is what you are looking for. These reports are on the construction workspace. If you are emailing the AIA out of the system, you could attach this report or even manually add the downloaded invoices if you wanted. 

 

Substantiated Billing

Form ID: (PM650000)

This report is used as a proof of project costs. By using this report, you can review, print, and email a list of costs from payable invoices, labor, and other project expenses for a specific billing period.

See below for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form.

Substantiated Billing - Consolidated

Form ID: (PM650050)

This report is used as a proof of project costs. By using this report, you can review, print, and email a list of costs from payable invoices, labor, and other project expenses. The generated report includes all scanned or uploaded images of the PNG, JPG, JPEG, BMP, GIF, TIFF, or TIF format attached to the corresponding cost records of a project for a specified billing period. When the report is generated, PDF copies of the images are attached as separate pages within the same PDF. In addition, the generated PDF includes hyperlinks to the attached files that could not be included directly in the report file (such as encrypted PDF files).

See below for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form.

 

Regards,

Mike Gillum

Userlevel 2
Badge

Hello Mike,

Thank you for the answer.

 

Is there any way to remove a subcontract invoice that was attached to the Substantiated Consolidated Report if it was processed in error or is it attached for good?

 

Also, this report in our world will be provided to the lender let’s say on a quarterly basis to get refunded for the costs incurred in the project thus far. Once those AP invoices on the report have been refunded by the lender, are they able to be “cancelled out/washed with a negative transaction” from the Substantiated Consolidated report, in order for the lender to see the next batch of AP invoices and costs that are due for the following quarter when the new Substantiated Consolidated Report is sent?

I appreciate your help!

 

Thank you,

Barbie

Userlevel 1

Hello @bjeter94 

All transactions flow to the substantiated billing report, so yes, a negative transaction will appear on the report.  

Colette

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved