This chapter contains these topics:
Section 47.2, "Setting Up AAIs for Labour, Billings, and Equipment Distribution"
Section 47.3, "Setting Up AAIs for Burden and Premium Labour Distribution"
Section 47.6, "Setting Up AAIs for Cash in Bank Account Distribution"
Section 47.11, "Reviewing the Accounting Distribution Rules Report"
Section 47.12, "Reviewing the Accounting Summarization Rules Report"
You set up automatic accounting instructions (AAIs) for payroll to automatically assign account numbers to the journal entries created in the payroll system. You can establish AAIs separately for each company. Always set up generic instructions in Company 00000. The system searches for a specific company first. If it finds no instructions for the specific company, it searches for Company 00000.
In addition to defining rules in the separate AAI tables, you can also set up rules for how the system summarizes journal entries.
You can have a line in an accounting instruction table that has no search criteria other than the journal type. This is a default line that uses the default journal type.
Setting up automatic accounting instructions consists of the following tasks:
Setting Up AAIs for Labour, Billings, and Equipment Distribution
Setting Up AAIs for Burden and Premium Labour Distribution
Setting Up Company Burden Rules
Setting Up Business Unit Burden Rules
Setting Up AAIs for Cash in Bank Account Distribution
Setting Up AAIs for Liabilities
Setting Up AAIs for Labour Billings
Setting Up AAIs for Accruals and Clearing
Setting Up Journal Summarization Rules
Reviewing the Accounting Distribution Rules Report
Reviewing the Accounting Summarization Rules Report
Entering Journal Type Defaults
You can have a line in an accounting instruction table that has no search criteria other than the journal type. This is a default line.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Debit-Direct Labour/Billings/Equipment
You set up AAIs for direct labour, billings, and equipment distribution to define accounts for transactions related to labour, labour billing (recharge), and the use of equipment. You do this by specifying search criteria for employee or timecard information and the account number information for the system to use in making the labour, billings, and equipment journal entries. All of these transactions are related directly to timecard entries.
When you set up direct labour, billings, and equipment distribution instructions, the minimum setup requirements for journal types are:
Type | Description |
---|---|
Equipment distribution (ED) | This is necessary only if you are creating equipment transactions. |
Payroll labour distribution (LD) | This is always required. |
Labour billing distribution (RD) | This is necessary only if you are using billing (recharge) rates. |
The system accesses this AAI table during time entry as well as during pre-payroll when it creates timecards for autopay employees. The system uses the values from the timecard which retrieves the values from the Employee Master table, other sources, or overrides that you supply. You use these search criteria fields to assign account numbers based on the specific timecard information.
The system uses the search criteria fields to determine the account distribution for the labour, billings, and equipment entries for your payroll. The system searches these accounting instructions in the following order, depending on the business unit and associated company used by time entry. The system uses the following search structure:
On the first pass compares the time entry record's business unit, union, job type, job step, and pay type to the rule's search criteria and attempts to match it to the appropriate journal type.
On each successive pass drops a value and uses a different combination of data fields for the search criteria.
Finally, if no matches exist in the rules for the specific company, it searches the rules for the default Company 00000.
The following list identifies the search criteria the system uses to match information from the timecard for a specific company:
Business Unit | Union | Job Type | Job Step | Payment Type | Journal Type |
---|---|---|---|---|---|
100 | 3000 | CARP | APPR | 1 | LD |
100 | 3000 | CARP | APPR | LD | |
100 | 3000 | CARP | 1 | LD | |
100 | 3000 | CARP | LD | ||
100 | 3000 | 1 | LD | ||
100 | 3000 | LD | |||
100 | CARP | APPR | 1 | LD | |
100 | CARP | APPR | LD | ||
100 | CARP | 1 | LD | ||
100 | CARP | LD | |||
100 | 1 | LD | |||
100 | LD | ||||
3000 | CARP | APPR | 1 | LD | |
3000 | CARP | APPR | LD | ||
3000 | CARP | 1 | LD | ||
3000 | CARP | LD | |||
3000 | 1 | LD | |||
3000 | LD | ||||
CARP | APPR | 1 | LD | ||
CARP | APPR | LD | |||
CARP | 1 | LD | |||
CARP | LD | ||||
1 | LD | ||||
LD |
The following list identifies additional search criteria the system can use to match information from the timecard for the default Company 00000:
Business Unit | Union | Job Type | Job Step | Payment Type | Journal Type |
---|---|---|---|---|---|
3000 | CARP | APPR | 1 | LD | |
3000 | CARP | APPR | LD | ||
3000 | CARP | 1 | LD | ||
3000 | CARP | LD | |||
3000 | 1 | LD | |||
3000 | LD | ||||
CARP | APPR | 1 | LD | ||
CARP | APPR | LD | |||
CARP | 1 | LD | |||
CARP | LD | ||||
1 | LD | ||||
LD |
To set up AAIs for labour, billings, and equipment distribution
On Debit - Direct Labour/Billings/Equipment
Figure 47-1 Debit - Direct Labour/Billings/Equipment screen
Complete the following fields:
Company
Journal Type (JT)
Distribution Account Object (Obj)
Complete the following optional fields
Employee or Time Card Basis Business Unit
Employee or Time Card Basis Union Code
Employee or Time Card Basis Job Type
Employee or Time Card Basis Job Step
Employee or Time Card Basis Pay Type
Distribution Account Business Unit
Distribution Account Subsidiary
Field | Explanation |
---|---|
JT | This field represents the type of transaction for which an account is to be derived.
Form-specific information For Equipment Billing: Enter the valid value ED to identify the accounting rules you want the system to use when distributing equipment costs to object accounts. The system changes the user defined code table you can access from the Type (Typ) field from the PDBA codes table to the Rate Groups table. When you associate an object account with journal type ED, the system applies accounting rules only to the equipment you specify in the Equipment Worked (EQPW) field on Equipment Time Entry forms in Payroll or Time Accounting. |
Employee or Time Card Basis Bus. Unit | Identifies the Business Unit the system searches to determine the accounting distribution. When defining the default rules (Company 00000), leave the Business Unit blank for the system to retrieve the Business Unit number entered on the Employee timecard, or from the Employee's Home Business Unit.
You can use the Skip to Business Unit field to specify the Business Unit to be displayed first in the lower part of the screen. Form-specific information For autopay employees, the system uses the labor distribution instructions, the employee's home business unit, or the lowest level of default. |
Topic | Description |
---|---|
Search criteria | Information coded on the timecard establishes the search argument. Codes in the Union, Type, and Step fields help to narrow the system's search. The system uses the following search criteria to determine which distribution account to debit:
|
Distribution account fields | To determine the distribution account, the system treats each distribution account as follows:
|
Business unit search for Company 00000 | You cannot specify a business unit search for Company 00000 because each business unit is attached to a unique company. To search by business unit, you must attach the business unit to a company specific table during setup. |
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Debit-Burden/Premium Labour Distribution
You set up AAIs to define accounts for actual burden, flat burden, and labour distribution premium time transactions. The hierarchy method in this table helps control account derivation.
Burden is defined as the direct expenses that a company incurs for an employee in addition to wages. These expenses include:
Payroll taxes and insurance (PTI) - Company-paid taxes and insurance, such as workers compensation insurance
Fringe benefits - Company-paid benefits, such as health insurance and company contributions to an RRSP plan
A company can choose to use flat burden, actual burden, or both.
The following graphic illustrates how expenses are distributed throughout an entire year according to flat burden and actual burden:
Figure 47-2 Burden and Premium Labour Distribution
When you set up actual burden distribution debit instructions you must, at a minimum, include the following default journal type codes:
Code | Description |
---|---|
BF - Burden fringe benefits for actual burden | Use this journal type for the burden fringe benefits you do not want to distribute separately. When the system does not find an entry for a specific fringe benefit, it uses the distribution account associated with journal type BF.
The DBA type field works with the Journal Type field. You must enter a value in one of the fields, but not both, for each accounting rule. Follow these guidelines to set up this journal type:
|
BT - Burden taxes for actual burden | Use this journal type for the burden taxes you do not want to distribute separately. When the system does not find an entry for a specific tax, it uses the distribution account associated with journal type BT. |
When you set up flat burden distribution debit instructions you must, at a minimum, include the following journal type codes:
FB - Flat burden
When you set up premium labour debit instructions you must, at a minimum, include the following journal type codes:
PR - Payroll premium labour distribution
You can have the system split the premium portion of overtime and create separate journal entries for straight time versus premium time.
When you set up recharge burden debit instructions you must, at a minimum, include the following journal type codes:
RB - Recharge (labour billing) burden
The following list illustrates the ways the system can match information from a timecard for a specific company for burden fringe:
Business Unit | Object | Subsidiary | DBA Type | Journal Type |
---|---|---|---|---|
1 | 1340 | 02200 | 1000 | |
1 | 1340 | 02200 | BF | |
1 | 1340 | 1000 | ||
1 | 1340 | BF | ||
1340 | 1000 | |||
1340 | BF |
The following list illustrates the ways the system can match information from a timecard for the default company.
Business Unit | Object | Subsidiary | DBA Type | Journal Type |
---|---|---|---|---|
1340 | 02200 | 1000 | ||
1340 | 02200 | BF | ||
1340 | 1000 | |||
1340 | BF | |||
00000 | 1000 | |||
00000 | BF |
To set up AAIs for burden and premium labour distribution
On Debit - Burden/Premium-Labour Distribution
Figure 47-3 Debit - Burden/Premium-Labour Distribution screen
Complete the following fields:
Company
Hierarchy Method (HM)
Object (Obj)
To set up Company 00000, enter 00000 or a valid object in the following field:
Time Card Basis Object
To set up a specific company, enter a valid object in the following field:
Time Card Basis Object
For tax types and journal types BT, FB, and PR, complete the following field:
Time Card Basis Journal Type
For DBAs, complete the following field:
Time Card Basis Type
For a specific company, complete the following optional field:
Time Card Basis Business Unit
Complete the following optional fields:
Time Card Basis Subsidiary
Distribution Account Business Unit
Distribution Account Subsidiary
Field | Explanation |
---|---|
Hierarchy Method | This code is used in retrieving the business unit and subsidiary accounts for burden distribution. The four methods available are:
1 – Business unit: Employee Home Business Unit unless a table override exists Subsidiary: No Subsidiary. Subledger/Type: No Subledger or Subledger Type. 2 – Business unit: Employee Home Business Unit unless a table override exists Subsidiary: Labor Distribution Subsidiary unless a table override. Subledger/Type: Labor Distribution Subledger and Type. 3 – Business unit: Labor Business Unit unless a table override exists. Subsidiary: No Subsidiary. Subledger/Type: Labor Distribution Subledger and Type. 4 – Business unit: Labor Business Unit unless a table override exists. Subsidiary: Labor Distribution Subsidiary unless a table override. Subledger/Type: Labor Distribution Subledger and Type. |
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Debit-Burden/Premium Labour Distribution
You can set up company burden rules to split the premium portion of overtime into a separate journal entry. You can choose to omit the creation of T3s.
You must set up company burden rules for a specific company. You cannot use Company 00000.
To set up company burden rules
On Debit - Burden/Premium-Labour Distribution
Figure 47-4 Company Burden Distribution Rules screen
On Company Burden Distribution Rules, complete the following fields.
Do you wish to split the premium portion of overtime on labor entries?
Do you wish to omit Actual Burden Distribution Journal Entries (Type T3)?
Field | Explanation |
---|---|
1) Do you wish to split the premium portion of overtime on labor entries? . .(Y/N) | A code which specifies whether the premium portion of overtime earnings is to be separated from 'Regular' earnings for accounting purposes. The valid codes are:
Y – The premium portion of overtime earnings will be separated from regular earnings during the Journal Entry step of the Payroll Cycle. N – The premium portion of overtime earnings will NOT be separated from regular earnings; Total earnings will be posted into the same account during the Journal Entry step of the Payroll Cycle. |
2) Do you wish to omit Actual Burden Distribution Journal Entries (Type T3)?. .(Y/N) | A code that specifies whether the Journal Entry program is to omit creation of Burden Distr. Detail(F0624) records and Distributed Actual Burden Amounts for all companies and business units. The valid values are:
Y – Omit the creation of F0624 records and any corresponding Actual Burden journal entries. N – Default to the Business Unit (F069056) level to determine whether any F0624 records are to be created and whether the corresponding Actual Burden journal entries are to be generated. |
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Debit-Burden/Premium Labour Distribution
You can create and store actual burden detail for every timecard. Typically, you need this information for government jobs or for auditing by an outside agency. When you set up business unit burden rules, you define a burden rule that applies to a single business unit. This AAI is useful for tracking detailed cost-plus burden expenses by job and business unit.
To set up business unit burden rules
On Debit - Burden/Premium-Labour Distribution
Choose the Business Unit Burden Rules function.
Figure 47-5 Business Unit Burden Rule Window
On Business Unit Burden Rule Window, complete the following field:
Burden Rule
Field | Explanation |
---|---|
Burden Distribution Rule | Actual Burden expenses are initially grouped into burden clearing accounts in the T1 section of the payroll journals. The user has the option of relieving these clearing entries and distributing burden expense based on where the direct labour was charged. This distribution of burden expense is done in the T3 section of the payroll journals. The user also has the option of creating a fixed audit trail for how each component of burden was distributed per individual timecard. This detail audit trail is maintained in the F0624 file which is used by the payroll system to produce Job Billing Registers. The rule codes listed below control the process:
0 – Do not create T3 Burden Expense entries for the Business Unit. 1 – Create T3 Burden Expense entries but not the F0624 audit records. 2 – Create T3 Burden Expense entries and associated F0624 audit records. 3 – Same as 1 but reverse out the Flat Burden posted thru the special timecard post. 4 – Same as 2 but reverse out the Flat Burden posted thru the special timecard post. |
Topic | Description |
---|---|
Business units displayed | You must set up a business unit in the payroll business unit constants if you want it to appear in Business Unit Burden Rule Window. |
No burden rule set up | If you do not access Business Unit Burden Rule Window, the system creates T3s, but does not write records to the Burden Distribution table (F0624). |
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Credit-Cash/Bank Account
You set up AAIs for cash in bank account distribution to define accounts for payroll disbursements. You can define different accounts for:
Cash disbursements
Computer cheques
Automatic deposits
Interim manual cheques
Interim computer cheques
When you set up cash in bank account distribution instructions, you must, at a minimum, set up the default journal type DP. You can use other codes when other types of payments are drawn on different bank accounts.
Journal Type | Description |
---|---|
DA | Auto deposits |
DC | Currency disbursement (cash) |
DI | Interim computer cheques |
DM | Interim manual cheques |
DP | Printed computer cheques from payroll cycle |
The employee's home business unit and the journal type determine the account. The journal type represents the type of payment.
The following list illustrates the ways the system can match the type of payment and the home business unit for a specific company:
Business Unit | Journal Type |
---|---|
1 | DA |
1 | DP |
DA | |
DP |
The following list illustrates the ways the system can match the type of payment for default Company 00000:
Business Unit | Journal Type |
---|---|
DA | |
DP |
To set up AAIs for cash in bank account distribution
Figure 47-6 Credit - Cash/Bank Account screen
Complete the following fields:
Company
Employee Basis Journal Type
Distribution Account Object
Complete the following optional fields:
Distribution Account Business Unit
Distribution Account Subsidiary
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Credit-Liabilities
You set up AAIs for liabilities to define accounts for the Payroll Disbursements Journal.
The minimum setup requirements for journal types when you set up liabilities instructions include the default journal type codes. They are:
Journal Type | Description |
---|---|
AL | Accrued liabilities for deductions and benefits |
AT | Accrued liabilities for payroll taxes |
The following list illustrates the search criteria for a specific company. For tax liabilities, the system matches the tax type and, optionally, the employee's home business unit. For DBA liabilities, the system matches the DBA code and, optionally, the employee's home business unit.
Business Unit | Type | Journal Type |
---|---|---|
1 | H | |
1 | AT | |
H | ||
AT | ||
1 | 5000 | |
1 | AL | |
5000 | ||
AL |
The following list illustrates the search criteria for default Company 00000. The system matches the tax type or the DBA code, or uses the default journal type if no match is found.
Business Unit | Type | Journal Type |
---|---|---|
H | ||
AT | ||
5000 | ||
AL |
To set up AAIs for liabilities
On Credit - Liabilities
Complete the following fields:
Company
Distribution Account Object
For deductions and benefits, complete the following field:
Employee Basis Type
For taxes, AL, and AT journal types, complete the following field
Employee Basis Journal Type
Complete the following optional field
Employee Business Unit
Distribution Account Business Unit
Distribution Account Subsidiary
Subledger
Subledger Type
Field | Explanation |
---|---|
Subledger | A value such as equipment number or work order number that you can attach to the end of an account number to further define an account and more easily track it. |
Subledger Type | A code identifying the type of subledger in the previous field. If you enter a subledger, you must also enter a subledger type. |
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Credit-Labour Billings
You set up AAIs for labour billings to establish accounts for labour billing offsets. These offsets are natural credit or revenue entries that offset labour billing charges or debits. Entries for labour billings are generally credit entries.
If your company does not use labour billings, you do not need to set up these instructions.
The following table represents the credit side only. It identifies the search criteria the system uses to match information from the timecard for a specific company.
Home Business Unit | Job Location | Pay Type | Journal Type |
---|---|---|---|
9 | 501 | 1 | RO |
9 | 501 | RO | |
9 | 1 | RO | |
9 | RO | ||
501 | 1 | RO | |
501 | RO | ||
1 | RO | ||
RO |
The following table represents the search criteria the system uses to match information from the timecard to the default Company 00000:
Home Business Unit | Job Location | Pay Type | Journal Type |
---|---|---|---|
501 | 1 | RO | |
501 | RO | ||
1 | RO | ||
RO |
To set up AAIs for labour billings
Figure 47-9 Credit - Labour Billings screen
Complete the following fields:
Company
Journal Type
Distribution Account Object
Complete the following optional fields:
Home Business Unit
Job Location
Pay Type
Distribution Account Business Unit
Distribution Account Subsidiary
Field | Explanation |
---|---|
Job Location | This business unit represents the location in which the employee worked. It can be used to indicate that an employee worked at this location, but charged the time to another business unit. This field is used for deriving rates from the Union Pay Rate table and is used exclusively by the Certified Payroll Register. |
Topic | Description |
---|---|
Search criteria | On the first pass, the system searches on the following fields:
On each successive pass the system searches on a different combination of data fields. The system can also search on the job location from the employee's timecard. This field, along with the optional Home Business Unit field, allows you to account for billing revenue. |
Distribution account fields | To determine the distribution account, the system treats each distribution account as follows:
|
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Dr/Cr-Accruals / Clearing
You set up AAIs for accruals and clearing to establish accounts for the following:
Accrued wages (T1, T2)
Actual burden clearing (T1, T3)
Flat burden clearing (T2)
Recharge flat burden clearing
Intercompany settlement (T1-T6)
When you set up the accrued wages account you must, at a minimum, include the following journal type code:
AW - Accrued wages for the Labour Distribution and Payroll Disbursements Journals
When you set up actual burden clearing accounts you must, at a minimum, include the following journal type codes:
CF - Burden clearing fringe for the Actual Burden Expense and Payroll Disbursements Journals
CT - Burden clearing tax for the Actual Burden Expense and Payroll Disbursements Journals
When you set up the flat burden clearing account you must, at a minimum, include the following journal type code:
FC - Flat burden clearing for the Labour Distribution Journal
When you set up intercompany settlement accounts you must, at a minimum, include the following journal type code:
IC - Intercompany settlements for the Actual Burden Expense, Labour Distribution, and Payroll Disbursements Journals
When you set up the recharge flat burden clearing account you must, at a minimum, include the following journal type code:
RC - Recharge burden relief for the Actual Burden Expense and Payroll Disbursements Journals
The following list identifies the search criteria that the system can use to match information from the timecard for a specific company for clearing tax burden:
Business Unit | Type | Journal Type |
---|---|---|
1 | H | |
H | ||
1 | CT | |
CT |
The following list identifies the search criteria that the system can use to match information from the timecard for Company 00000 for clearing tax burden:
Business Unit | Type | Journal Type |
---|---|---|
H | ||
CT |
The following list identifies the search criteria that the system can use to match information from the timecard for a specific company for clearing fringe burden:
Business Unit | Type | Journal Type |
---|---|---|
1 | 1000 | |
1000 | ||
1 | CF | |
CF |
The following list identifies the search criteria that the system can use to match information from the timecard for Company 00000 for clearing fringe burden:
Business Unit | Type | Journal Type |
---|---|---|
1000 | ||
CF |
The following list identifies the search criteria that the system can use to match information from the timecard for a specific company for accrued wages, flat burden clearing, intercompany settlements, or recharge flat burden clearing:
Business Unit | Type | Journal Type |
---|---|---|
1 | AW, FC, IC, or RC | |
AW, FC, IC, or RC |
The following list identifies the search criteria that the system can use to match information from the timecard for Company 00000 for accrued wages, flat burden clearing, intercompany settlements, or recharge flat burden clearing:
Business Unit | Type | Journal Type |
---|---|---|
AW, FC, IC, or RC |
To set up AAIs for accruals and clearing
On Debit/Credit - Accruals/Clearing
Figure 47-10 Debit/Credit - Accruals/Clearing screen
Complete the following fields:
Company
Distribution Account Object
Complete one of the following fields, as appropriate:
Employee Basis Type
Employee Basis Journal Type
Complete the following optional fields:
Employee Basis Business Unit
Distribution Account Business Unit
Distribution Account Subsidiary
Figure 47-11 Debit/Credit - Accruals/Clearing screen (Detail area)
Complete the following optional fields:
Subledger
Type
Description
Enhanced Subledger 1-4
Enhanced Subledger Types
Topic | Description |
---|---|
Search criteria | On the first pass, the system searches on the Employee Basis fields.
On each successive pass the system searches on a different combination of data fields. |
Distribution account fields | To determine the distribution account, the system treats each distribution account as follows:
|
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Journal Summarization Rules
You set up journal summarization rules to establish how the system summarizes pro forma journal entries before creating actual journal entries in the general ledger. Summarizing journal entries reduces the number of transactions in the general ledger.
Defining journal summarization allows you to:
Summarize journal entries for specific companies and for the default Company 00000
Create both summarized and detail journals
Define up to six different summarization rules for a specific range of object accounts and for a specific business unit
If the system does not find summarization rules for a specific company, it uses those established for the default company (Company 00000). If it finds no summarization rules for an account, it assumes full summarization.
Each additional variable (company, business unit, or summarization code) that you define requires additional computer resources, which lengthens processing time. Therefore, JD Edwards World recommends that you:
Set up summarization rules at the Company 00000 level when possible
Avoid setting up summarization rules at the business unit level
Specify the same summarization code for each object account range when possible
In the report illustrated below, five employees were processed, each of them having one timecard. An LD, BF, and BT journal type has been created for each employee for each type of expense. This Pay Period Journal Batch Proof reports lists pro forma journals with no summarization for the expense account.
Figure 47-12 Pay Period Journal Batch Proof report
Figure 47-13 Pay Period Journal Batch Proof report (cont'd.)
The following Pay Period Journal Batch Proof report lists pro forma journals with full summarization for the same payroll. All the LD and various BF and BT journals are summarized into single entries.
To set up journal summarization rules
On Journal Summarization Rules
Figure 47-14 Journal Summarization Rules screen
Complete the following fields:
Company
Summarization Code (SC)
Enter the business unit number, object account range, or both in the following fields:
Business Unit Number
Object Account Beginning Range
Object Account Ending Range
Field | Explanation |
---|---|
S C | The rules tell the system how to summarize the pro forma entries before creating the actual journal entries. The system looks for all documents that have the same value and summarizes them into one journal.
Valid codes for rules and journal entry descriptions are: 1 – Full summary : The system looks for the same values for the following: business unit, object, subsidiary, subledger, subledger type, fiscal year, general accounting period number, equipment or asset number, document type and journal reference (See data dictionary item PRJE.) First description in the journal entry - Document description Second description in the journal entry - Blank 2 – Same as Rule 1 and include pay type First description in the journal entry - Document description Second description in the journal entry - Pay type 3 – Same as Rule 1 and include pay type, job type, and job step First description in the journal entry - Document description Second description in the journal entry - Pay type 4 – Same as Rule 1 and include pay type, job type, job step, and employee First description in the journal entry - Employee Second description in the journal entry - Pay type 5 – Do not summarize First description in the journal entry - Document description Second description in the journal entry - Time entry comment and pay type 6 – Do not summarize and include employee name First description in the journal entry - Employee Name Second description in the journal entry - Time entry comment and pay type |
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Accounting Instructions
The Accounting Distribution Rules report provides a detailed listing of the information within the Accounting Distribution Rules table. You can review the report to verify that the information that you entered on any of the AAI tables is correct.
The report prints a separate page for each journal code or set of accounting rules. For example, all of the accounting rules for accruals print, then the rules for burden expenses print, and so on.
If you are using Enhanced Subledger Accounting, this information displays on the report. See Work with Enhanced Subledger Accounting in the JD Edwards World General Accounting I Guide for more information.
Figure 47-15 Accounting Distribution Rules report
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose Summarization Rules
The Accounting Summarization Rules report provides a detailed listing of the journal summarization rules that you set up. You review the report to verify that the journal summarization rules that you entered are correct.
Figure 47-16 Accounting Summarization Rules report
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Automatic Accounting Instructions
From Automatic Accounting Instructions (G7743), choose an option
Each AAI table can have a default line with a default journal type. For example, LD is the default journal type for the labor distribution table. When the timecard or employee criteria do not match any of the other lines, the system uses the default line, if one exists. You can use a default line for a specific company and for Company 00000.
The following lists the default journal types for default lines:
Journal Type | Tables |
---|---|
LD, ED, RD | Use in labour, billings, and equipment distribution tables |
BF and BT | Use in actual burden tables |
PR | Use in premium labour tables |
DP | Use in cash in bank account tables |
AL and AT | Use in liabilities tables |
RO | Use in labour billings tables |
AW | Use in accrued wages in accruals and clearings tables |
IC | Use in intercompany settlements in accruals and clearings tables |
You can also use a default line to indicate that you are missing instructions from a table.
For example, in your chart of accounts you have a separate and unique account for each tax calculated in payroll. In your credit liabilities AAIs you assign these accounts by tax type.
The following table illustrates how might set up a separate account for each tax calculated in payroll.
Business Unit | Type | Journal Type | Tax | Business Unit | Object |
---|---|---|---|---|---|
A | Federal Income | 100 | 4211 | ||
C | Federal - Employment | 100 | 4214 | ||
D | FICA withheld | 100 | 4212 | ||
E | FICA paid | 100 | 4212 | ||
P | Medicare withheld | 100 | 4213 | ||
Q | Medicare paid | 100 | 4213 | ||
CF | Provincial Income Tax | 77 | 4221 |
A default line with an invalid account informs you that a line is missing from your table. If you use a valid account, the system does not print a warning on the journal proof report.
To enter journal type defaults
On any accounting instructions form
Complete the following fields for the default journal type:
Journal Type
Distribution Account Object
Complete the following optional fields:
Distribution Account Business Unit
Distribution Account Subsidiary