Standard Crystal Report - AIA Invoice Reports
Issue/Symptom/Question
Standard Crystal Report - AIA Invoice Report
Applies To
Penta for Windows
Crystal Report - AIA Invoice Report
Billing & Accounts Receivable
Resolution/Fix/Answer
Use the American Institute of Architects (AIA) Application and Certificate for Payment form to issue an invoice using official AIA forms.
Prerequisites
- System Option 56 is set to 7.
- On the Contract Information window’s Cost Plus Line Items pop-up window, enter Y or N in the On Invoice? field. If you enter Y, the invoice displays details information; if you enter N, the invoice displays summary information.
Report Code: in_pymtApplAutoForm_p153_cr11.rpt
Available Parameters:
Example Report Results:
Fields
Unit of Measure
If the On Invoice? field is N, this column is blank for cost plus line items.
For cost plus and unit price line items, this is the billed unit. For payroll-related transactions, the Unit of Measure is an Hours Type, which is Reg, OT1, or OT2. Cost plus lines also display the date of the charge.
For lump sum line items, this column is blank.
Quantity
If the On Invoice? field is N, this column is blank for cost plus line items.
For cost plus and unit price line items, this is the amount of the invoiced unit.
For lump sum line items, this column is blank.
Rate
If the On Invoice? field is N, this column is blank for cost plus line items.
For cost plus and unit price line items, this is the rate at which the unit is invoiced.
For lump sum line items, this column is blank.
Extended Amount - This is the invoice amount of the line item. This report totals all line items on the Total Amount Due This Invoice row.