Topic Thread

1.  A/P POSTING TO AIA LINE ITEMS

Posted 11 days ago
Was curious if anyone new of a software that a/p invoices could post back to AIA billings line items.
Thanks!

------------------------------
Jillane Brown
President
Browe Construction Company
Selma NC
------------------------------


2.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 11 days ago
Viewpoint does this - but not direct to the AIA line items like you indicate in your post. Instead, you code the AP invoice so a specific cost code and then the cost codes are designated/mapped to a specific AIA line item in the project set up. As such, when an AIA invoice is initialized, it does so based on percent complete on the job cost side. For example, if you have incurred $40k of an estimated $80k of cost, the system bills 50% of the contract value.

------------------------------
Arin Knudtson CPA, CCIFP
Chief Financial Officer
Journey Group Companies
Sioux Falls SD
(605) 332-5968
------------------------------



3.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 10 days ago
Hi Jillane,

Viewpoint Spectrum also handles this through the Draw Request Cost Selection feature as long as the Cost Codes (Phases in Spectrum) are mapped to the appropriate SOV line items. This function also assigns the Draw Request application number to the Job Cost history records.

All the best,

Ron

------------------------------
Ron Smith
Regional Manager
Strategies Group
www.strategiesgroup.com
(850) 982-9094
------------------------------



4.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 10 days ago
Depending on your ERP - Sage 300 CRE can post cost directly to AIA Schedule of Value Line Items.

------------------------------
William Kormoski
President, Sage 300 CRE Consultant
Kormoski & Associates LLC
Mount Juliet TN
(615) 351-4953
------------------------------



5.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 7 days ago
William,
Would you be willing to share how to do this in Sage 300?

------------------------------
Staci Hurst CCIFP
Controller
Ennis Electric Company, Inc.
Manassas VA
(703) 335-6700
------------------------------



6.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 7 days ago
I need to learn how to do this!

------------------------------
Megan Barnhart
CFO
Frank Schipper Construction Co.
Santa Barbara CA
(805) 963-4359
------------------------------



7.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 9 days ago
Jillane, are you asking for purposes of "pay when paid," T&M billing, or cost-to-revenue analysis? Most ERP systems associate costs and billings in the way Ron and Arin describe with Spectrum and Vista. But not all systems do that in an easy or straightforward manner. PWP also may require a different process.

Towner Blackstock
Blackstock Consulting
704-491-4010
Helping construction companies get the most from their software



8.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 7 days ago
Jillane,
Corecon Technologies offers multiple classifications systems each integrated with every transaction type.  Job Cost entries such as Accounts Payable Invoices/Bills, Subcontractor Invoices,  Labor Time Cards, Equipment Time Cards, Misc Expenses, Employee Reimbursements, Credit Card charges are entered to Job Cost Codes.  These Job Cost Codes are simultaneously mapped to Multi-tiered Master Cost Code list, to Internal Classifications, and to Owner Groupings (your Customers Schedule of Values).  Each of these classification systems tie to line items on the AIA Documents.  Maintaining these multiple mapped classification systems concurrently allows each user of the data to see the information in a format they prefer.  Accounting may prefer to see this at the Job Cost Code Level, Project Managers and Estimators may prefer data at the Master Cost Code level, and your Customers/Clients will see the data exactly as they have requested using the Owner Groupings.

In other words, Corecon allows Accounts Payable invoices/bills to post back to AIA billings line items.  Pre-billing logs are used to see which AP Bills incurred post to the which specific line items on the AIA Billing. Corecons Analytics and Dashboards also track transactions by Job Cost Code and by Master Cost Code lists which in turn tie back to the AIA Billing Line items.

I hope this helps.


------------------------------
David Holler
Construction Software Consultant and Trainer
Savage MD
dholler@softwarepro.construction
------------------------------



9.  RE: A/P POSTING TO AIA LINE ITEMS

Posted 6 days ago
Acumatica Construction Edition can handle the direct posting of AP to the AIA line items (schedule of values).

If you would like to review this process please let me know.

You can find more information at:

Acumatica Construction ERP Software | Acumatica Cloud ERP
Acumatica Cloud ERP remove preview
Acumatica Construction ERP Software | Acumatica Cloud ERP
Acumatica delivers broad, deep software solutions for construction project and accounting management on a modern business platform. Acumatica's Construction Edition is a full-featured Construction ERP that helps you improve margins and project control from estimating through close out on home, multi-family, commercial, mixed-use, land development, and government projects.
View this on Acumatica Cloud ERP >


------------------------------
Glen West
Partner
Cloud Contractor 360
(310) 570-0845
------------------------------