Example: Set Up Posting Accounts

Use the Posting Criteria Maintenance (XPC) program to set up posting criteria and accounts that programs use to post to the general ledger and test where sample transactions post. See Background and Road Map for more information.

This example sets up both a default account and posting criteria for the A/R (Accounts Receivable) posting name and the AR Invoice Register (RR) program. The posting criteria are Organization, Branch, Department, and Currency exchange, in that order. The reason for ranking the criteria in this order is:

  • An organization can have many branches.

  • A branch can have many departments.

  • A department can receive payments in many currencies.

This example assumes these codes and accounts are set up. Your codes and accounts will be different.

Type

Code

Description

Program used to set up

Organization

*0

Corporate Headquarters

GL Account Maintenance (GMM)

Account number

100

Accounts Receivable

GL Account Maintenance (GMM)

Account number

101

Accounts Receivable - US Dollars

GL Account Maintenance (GMM)

Account number

102

Accounts Receivable - Canadian Dollars

GL Account Maintenance (GMM)

Branch

10

PowerShift Corporation

Branch Maintenance (TBM)

Department

AR

Accounts Receivable

Department Codes Maintenance (TDP)

Currency

US

US Dollars

Currency Codes Maintenance (TCU)

Currency

CD

Canadian Dollars

Currency Codes Maintenance (TCU)

  1. Select AR (Accounts Receivable) and click Select. The program displays the programs that use this posting.

  1. Select RR, AR Invoice Register, and click Select.

  2. Enter or change data in these fields:

Field Name

Type / Max Length

Action / Description

Posting name

Display only

AR (the posting you selected)

Program name

Display only

RR (the program you selected)

Default GL org

Required
2 alphanumeric

Select organization *0.

Default acct no

Required
10 alphanumeric

Select account number 100.

Consolidation code

Optional
1 numeric

Leave blank.

Organization

Optional
1 numeric

Enter 1 to rank Organization as the most important criterion of the hierarchy.

Branch

Optional
1 numeric

Enter 2 to rank Branch as the next most important criterion of the hierarchy.

Department

Optional
1 numeric

Enter 3 to rank Department as the third most important criterion of the hierarchy.

Currency

Optional
1 numeric

Enter 4 to rank Currency exchange as the least most important criterion of the hierarchy.

Memo reason code

Optional
1 numeric

Leave blank.

  1. Click Accounts to enter specific posting accounts. Existing accounts are listed.

  2. Click Add to set up a new account. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Org

Optional
2 alphanumeric

Select *0 as the organization code.

Branch

Optional
4 alphanumeric

Select 10 as the branch.

Department

Optional
5 alphanumeric

Select AR (Accounts Receivable) as the department.

Currency

Optional
2 alphanumeric

Select US (US Dollars) as the currency.

  1. Click OK and enter data in these fields:

Field Name

Type / Max Length

Action / Description

GL org code

Required
2 alphanumeric

Select *0 as the GL organization code.

GL account no

Required
10 alphanumeric

Enter 101 (Accounts Receivable - US Dollars) as the account number.

  1. Click OK. The program prompts you to add another record.

  2. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Org

Optional
2 alphanumeric

Select *0 as the GL organization code.

Branch

Optional
4 alphanumeric

Select 10 (PowerShift) as the branch.

Department

Optional
5 alphanumeric

Select AR (Accounts Receivable) as the department.

Currency

Optional
2 alphanumeric

Select CD (Canadian Dollars) as the currency.

  1. Click OK and enter data in these fields:

Field Name

Type / Max Length

Action / Description

GL org code

Required
2 alphanumeric

Select *0 as the GL organization code.

GL account no

Required
10 alphanumeric

Enter 102 (Accounts Receivable - Canadian Dollars) as the account number.

  1. Click OK. The program prompts you to add another record. Leave the fields blank to exit add mode.

  2. Click Test to test how sample transactions post. The program prompts Org, Branch, Department, and Currency.

  3. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Org

Optional
2 alphanumeric

Select *0 as the GL organization code.

Branch

Optional
4 alphanumeric

Select 10 (PowerShift) as the branch.

Department

Optional
5 alphanumeric

Select AR (Accounts Receivable) as the department.

Currency

Optional
2 alphanumeric

Select US (US Dollars) as the currency.

When you press Return, the program displays GL organization *0  Account 101 Accounts Receivable - US Dollars. This means that a transaction for organization *0, branch 10, department AR in US currency will post to account 101.

  1. Click Close and enter the same data in the first three fields, but clear the Currency field.

    The program displays GL organization *0  Account 100 Accounts Receivable.

    This means that a transaction for organization *0, branch 10, department AR that is not in US or Canadian currency will post to the default account.

  2. Click OK and leave the fields blank to end the test.

  3. Click OK to exit the posting accounts for this program.

  4. Click Quit to exit the program.