AP GL Account Generation Hierarchy
This section details the hierarchy followed to generate the initial general ledger account for a general ledger line on these documents:
- AP Invoice
- AP Credit Note
- Purchase Order
When entering a general ledger line on these documents the general ledger account is determined from a combination of:
- GL Account Segment Sequence defaults
- Supplier Expense Account
- Branch GL Account structure
- GL Account Segment persistent setting
- GL Account Segment visibility and default value
The Supplier Suspense Account and Branch GL Account structure can contain wildcards.
The order of precedence is
- If the GL Segment is not visible this is used
- For GL Lines after the first line, if the GL Segment is persistent then the value from the previous line is used for that segment
- Values contained in the Supplier Expense Account
- Values contained in the Branch Gl Account Structure
If a complete GL Account is generated and it is not valid then the GL Account filed will be blank.
Example
The highlighted cells in the table below show the values being used:
GL Segment |
Branch |
Supplier |
Account No |
|||||||
Brch |
Dept |
Account |
Brch |
Dept |
Account |
Brch |
Dept |
Account |
Generated |
Returned |
10 |
10 |
* |
* |
* |
1000 |
10.10.1000 |
10.10.1000 |
|||
10 |
* |
* |
* |
10 |
1000 |
10.10.1000 |
10.10.1000 |
|||
20 |
10 |
* |
* |
* |
1000 |
20.10.1000 |
20.10.1000 |
|||
10 |
10 |
* |
* |
20 |
1000 |
10.20.1000 |
10.20.1000 |
|||
10 |
10 |
* |
20 |
* |
1000 |
20.10.1000 |
20.10.1000 |
|||
10 |
* |
* |
* |
10 |
1000 |
10.10.1000 |
10.10.1000 |
|||
* |
* |
* |
* |
* |
* |
*.*.* |
.. |
|||
* |
* |
* |
* |
* |
1000 |
*.*.1000 |
..1000 |
|||
* |
* |
* |
* |
10 |
* |
*.10.* |
.10. |
|||
* |
* |
* |
* |
10 |
1000 |
*.10.1000 |
.10.1000 |
|||
10 |
* |
* |
* |
* |
* |
10.*.* |
10.. |
|||
* |
10 |
* |
* |
* |
* |
*.10.* |
.10. |
|||
* |
* |
1000 |
* |
* |
* |
*.*.1000 |
..1000 |
|||
20 |
10 |
* |
* |
2000 |
10.20.2000 |
10.2000 |
||||
1000 |
10 |
10 |
* |
* |
10.10.1000 |
10.10 |
||||
10 |
* |
* |
* |
* |
10.*.* |
10.. |
||||
10 |
10 |
* |
1000 |
10.10.1000 |
1000 |