Automatic accounting instructions (AAIs) define the link between the Job Cost, Subcontract Management, and General Accounting systems.
Before defining new AAIs, you should first review the AAIs in your system to ensure that the AAIs you want to include are not already defined. You can then define your new AAIs.
The offset (contra) account when work-in-progress (WIP) needs to be transferred to the income statement. The system posts offset amounts to this contra asset account.
IS
The sequence numbers for AAIs related to the Job Cost system begin with 51.
The following categories of AAIs are relevant to the Job Cost system:
Profit recognition AAIs Use these AAIs to specify the accounts that the system uses to create journal entries for profit recognition.
Field progress
protection AAIs Use these AAIs to protect the actual unit amounts in certain accounts from being updated as a result of job progress calculations.
Draw reporting
selection AAIs Use these AAIs to specify the accounts that are eligible for construction costs related to draw reporting.
Budget balance ledger
AAIs Use these AAIs to force general ledger entries to always be in balance.
Job summarization
AAIs Use these AAIs to direct the system to summarize the detail information for existing accounts into a single summary account.
See Also
Working With AAIs in the General Accounting Guide for information on reviewing and revising automatic accounting instructions
Profit Recognition AAIs
Profit recognition AAIs specify the accounts that the system uses when it creates journal entries for profit recognition. The following table defines profit recognition AAIs:
BS
You can summarize the amounts into a single account (BS) or show detail for each account (BS1344 for cost type 1344, BS1380 for cost type 1380, and so on). The system
automatically uses BS when you do not specify a cost type in the item number.
The system does not require this AAI if you set up jobs on the income statement. However, for jobs on the balance sheet, the BS AAI must at least be defined for the default company 00000.
The account for revenue and cost of sales reported on the income statement. The system creates entries for costs and billings when it relieves WIP amounts, then uses this AAI to transfer those entries from the balance sheet to the income statement.
You can summarize the amounts into a single account (IS) or show detail for each account (IS1344 for cost type 1344, IS1380 for cost type 1380, and so on). The system automatically uses IS when you do not specify a cost type in the item number. The system does not require this AAI if you set up jobs on the income statement.
JCBE
This account is generally a liability account. The system reverses the amounts monthly.
JCAPO
The account for overbillings. Overbillings are billings in excess of costs and estimated earnings. You can also use it for the credit offset to JCLOSS, if BSLOSS is not set up.
JCCE The account for underbillings. Underbillings are costs and estimated earnings in excess of billings.
This account is generally an asset account. The system reverses the amounts monthly.
JCBOUA The account for adjustments to the income statement related to the cost of sales. The system posts over and under entries to this account when you base the percentage of completion on billings.
The account is the offset for entries posted to the accounts related to JCBE and JCCE. The system reverses the amount monthly.
JCCOUA The account for adjustments to the income statement related to revenue. The system posts profit and loss entries to this account when you base the percentage of completion on cost.
The account is the offset for entries posted to the accounts related to JCBE and JCCE. The system reverses the amount monthly.
JCLOSS The account for entries related to a provision for loss. The system creates such an entry when a job has a projected final loss. The system reverses the amount monthly.
BSLOSS The offset (contra) account for the provision for loss. It is the offset for entries posted to the account related to JCLOSS. The system reverses the amount monthly.
This AAI is optional. If it is not set up, the system uses JCCE.
JCAPC The account for accrued cost on the job account. The system automatically reverses the amounts in the next month.
JCSMJ The account for deferred cost on the job account. You typically use this AAI for stored materials. Any amounts are automatically reversed in the next month.
The offset (contra) account for accrued costs. It is the offset for entries posted to the account related to JCAPC.
JCSMI The offset (contra) account for deferred costs. It is the offset for entries posted to the account related to JCSMJ.
JCPFC The account for adjustments to the projected final cost. This AAI requires the object account.
The subsidiary is optional, and the system does not use the business unit.
JCPFP The account for adjustments to the projected final profit. You typically set up this AAI only if your company posts profit to an account and maintains balanced budgetary ledger types.
This AAI requires the object account. The subsidiary is optional, and the system does not use the business unit.
JCPFR The account for adjustments to the projected final revenue. This AAI requires the object account. The subsidiary is optional, and the system does not use the business unit.
JCCAxx -
JCCAxx+1 The beginning and ending object accounts for a range of revenue accounts. Profit recognition can include up to 49 ranges from JCCA01 - JCCA02 to JCCA97 - JCCA98.
JCSTxx -
JCSTxx+1 The beginning and ending object accounts for a range of cost accounts. Profit recognition can include up to 49 ranges from JCST01 - JCST02 to JCST97 - JCST98.
Field Progress Protection AAIs
Field progress protection AAIs protect the actual units in specific accounts from updates in related job progress entry programs. These AAIs prevent entering quantities when the actual quantities come from other J.D. Edwards systems.
JCxx -
JCxx+1 The beginning and ending object accounts for the range of labor accounts. Field progress protection can include the five ranges from JC01 - JC02 to JC09 - JC10.
This AAI requires the object account. The subsidiary is optional, and the system does not use the business unit.
Note
You should set up an AAI range of cost types for any actual quantities that are automatically posted from another J.D. Edwards system.
Draw Reporting Selection AAIs
Draw reporting selection AAIs specify the eligible construction cost accounts for draw reporting. The system does not process any other accounts for draw reporting.
DWxx -
DWxx+1 The beginning and ending object accounts for two ranges of eligible accounts. Draw reporting selection can include any ranges from DW01 - DW02 to DW49 - DW50.
This AAI requires the object account. The subsidiary is optional, and the system does not use the business unit.
Budget Balance Ledger AAIs
Budget balance ledger AAIs force the system to keep balanced ledger entries for accounts on the Combined Progress Entry form.
SM01
FPBAL The offset account used for maintaining balanced entries to ledgers defined on user defined codes table (09/LP).
Job Summarization AAIs
Job summarization AAIs direct the system to summarize the detail information from many existing accounts into one summary account. An asterisk (*) in either the Object Account or Subsidiary field specifies that the system keeps the account balances.
This AAI summarizes all object accounts within their respective subsidiaries. It also specifies an object account that the system creates to keep the summarized information.
The business unit, object account, and subsidiary are all optional for this AAI.