Exercise 1: Creating a Report COA
Use a chart of account to create a sales report for North America that shows the opening balance, activity, and closing balance for entities 10USACO, 11CANCO, and 12MEXCO.
1 Log in to the training database using the following details:
User: demo
Password: qad
2 Ensure that you are in entity 10USACO.
3 Create default COA elements that allow you to use incomplete mappings in the COA cross references:
a Create a catch-all GL account 1994 of type Standard. Accept all defaults in GL Account Create (25.3.13.1).
b Create a catch-all sub-account, FRWSA. Accept all defaults in Sub-Account Create (25.3.17.1).
c Create a catch-all cost center, FRWC. Accept all defaults in Cost Center Create (25.3.20.1).
d Create a catch-all project code, FRWP with a status of Open. Accept all defaults in Project Create (25.3.11.1.1).
4 Use Report Chart of Accounts Maintenance (25.16.1) to create a common reporting chart of accounts.
Field | Value |
Report Chart | NAmerica |
Description | North American Chart of Accounts |
a In the Shared Sets and SAF Concepts frame, specify 10USA in the Defaults from Domain field.
b In the Shared Sets and SAF Concepts frame, accept the GL account, cost center, sub-account, and project shared sets that default for domain 10USA. Do not include any SAF concepts.
c Click Next.
d In the Default Accounts frame, specify the default COA elements you created previously:
• GL account: 1994
• Sub-account: FRWSA
• Cost center: FRWC
• Project: FRWP
• CTA account: 1994
e Click Next.
f In the Add or Remove Entity frame, add entities 10USACO, 11CANCO, and 12MEXCO.
g Click Next.
h In the next frame, note that no COA cross references is needed because all entities share the same COA. Specify all COA cross references as “Not Needed”.
i Click Next to complete the setup.
