Description
Cause
Resolution
There are two ways to process stored materials. Each method requires a different setting on the contract in the Contracts application, which determines whether or not stored materials billed are added to Previous Work Completed in Billing. Each method requires different data entry in Contract-Based Invoices in Billing. Use option A if stored materials are considered stored and complete when billed; use option B if stored and materials are considered stored, but not complete, when billed.
Please note: The stored materials setting applies when the Contract is created, and does not retroactively affect existing Contracts.
Option A:
Stored materials are considered stored and complete (used or incorporated into the project) when billed, and they are added to Previous Work Completed.
- Setting up: In the Contracts application, select the Add stored materials to previous work completed check box on the Contract (Billing tab).
- Entry: In Tasks , Contract-Based Invoices in the Materials Presently Stored column, enter the stored materials amount to bill this period. The stored materials amount accumulates in the Previous Work Completed amount, and replaces the Previously Stored Materials amount on the next worksheet that you enter for that contract item.
Option B:
Stored materials are considered stored, but not complete (not used or incorporated into the project) when billed, and they are not added to Previous Work Completed. This is the method outlined on the instruction sheet for AIA Document G703.
- Setting up: In the Contracts application, do not select the Add stored materials to previous work completed check box on the contract (Billing tab).
- Entry: In Tasks , Contract-Based Invoices in the Materials Presently Stored column, enter any new stored materials to bill this period that are not complete, plus any previously billed stored materials that are not complete. When previously billed stored materials are complete, enter both the completed stored materials amount plus all other work completed in the Work Completed this Period column, and reduce the amount in the Materials Presently Stored column.
Examples:
The following examples show the difference between how the two methods handle the same situations.
The contract item is entered with a contract amount of $7,500 ($6,500 is labor and $1,000 is materials):
- Draw 1: The general contractor completes $3,000 of labor and stores $1,000 of materials.
- Draw 2: An additional $2,250 of labor is completed with no change to the materials.
- Draw 3: $250 of the $1,000 of stored materials is used on the job. An additional $400 of labor is completed.
- Draw 4: Another $600 of labor is completed.
- Draw 5: A subcontractor finishes installation and uses the remaining $750 of stored materials.
- Draw 6: A change order is entered to cover an additional $200 of materials delivered to the site.
- Draw 7: The general contractor completes the last $250 of labor and uses the last $200 of stored materials.
- (Option A) Stored materials are considered stored and complete when billed, and they are added to Previous Work Completed
|
BL Draw ID |
CN Item Amount |
CN Item |
Prev Work Complete |
Work Complete this period |
Previous Stored Material |
Materials Presently Stored |
Total Work Complete & Stored |
Balance to finish |
Generate invoices billed amount |
|
1 |
7,500.00 |
1 |
0.00 |
3,000.00 |
0.00 |
1,000.00 |
4,000.00 |
3,500.00 |
4,000.00 |
|
2 |
7,500.00 |
1 |
4,000.00 |
2,250.00 |
1,000.00 |
0.00 |
6,250.00 |
1,250.00 |
2,250.00 |
|
3 |
7,500.00 |
1 |
6,250.00 |
400.00 |
0.00 |
0.00 |
6,650.00 |
850.00 |
400.00 |
|
4 |
7,500.00 |
1 |
6,650.00 |
600.00 |
0.00 |
0.00 |
7,250.00 |
250.00 |
600.00 |
|
5 |
7,500.00 |
1 |
7,250.00 |
0.00 |
0.00 |
0.00 |
7,250.00 |
250.00 |
0.00 |
|
6 |
7,700.00 |
1 |
7,250.00 |
0.00 |
0.00 |
200.00 |
7,450.00 |
250.00 |
200.00 |
|
7 |
7,700.00 |
1 |
7,450.00 |
250.00 |
200.00 |
0.00 |
7,700.00 |
0.00 |
250.00 |
- (Option B) Stored materials are considered stored, but not complete when billed, and they are not added to Previous Work Completed
|
Billing Draw ID |
CN Item Amt |
CN Item |
Previous Work Complete |
Work Complete this Period |
Previous Stored Materials |
Materials Presently Stored |
Total Work Complete & Stored |
Balance to Finish |
Generate Invoices Billed Amount |
|
1 |
7,500.00 |
1 |
0.00 |
3,000.00 |
0.00 |
1,000.00 |
4,000.00 |
3,500.00 |
4,000.00 |
|
2 |
7,500.00 |
1 |
3,000.00 |
2,250.00 |
1,000.00 |
1,000.00 |
6,250.00 |
1,250.00 |
2,250.00 |
|
3 |
7,500.00 |
1 |
5,250.00 |
650.00 |
1,000.00 |
750.00 |
6,650.00 |
850.00 |
400.00 |
|
4 |
7,500.00 |
1 |
5,900.00 |
600.00 |
750.00 |
750.00 |
7,250.00 |
250.00 |
600.00 |
|
5 |
7,500.00 |
1 |
6,500.00 |
750.00 |
750.00 |
0.00 |
7,250.00 |
250.00 |
0.00 |
|
6 |
7,700.00 |
1 |
7,250.00 |
0.00 |
0.00 |
200.00 |
7,450.00 |
250.00 |
200.00 |
|
7 |
7,700.00 |
1 |
7,250.00 |
450.00 |
200.00 |
0.00 |
7,700.00 |
0.00 |
250.00 |