Search Sequence for AAIs

You set up AAI tables so that the system can assign account numbers to sales order transactions and account for the amounts that are associated with those transactions in the general ledger. Most organizations set up separate account numbers for each company within their organization. However, some organizations use the same account numbers for each company. If you do not want to set up separate accounts for each company, you can set up account information for the default company, company 00000. The system searches for account numbers in this order:

1. The system first searches for a match on order company, order type, and general ledger category code.

2. If no match is found, the system searches for a match on order company, order type, and general ledger category code of **** (wildcard).

3. If no match is found, the system searches for a match on company 00000, order type, and general ledger category code.

4. If no match is found, the system searches for a match on company 00000, order type, and general ledger category code of **** (wildcard).

5. If no match is found, the system produces an error notifying the user that the AAI is not set up.

If an organization uses product detailed costing in addition to the fields Order Company, Order Type, and the G/L Category Code, then the system also includes Cost Type in the search for an account. This applies to the sales AAIs 4220 and 4240.

In addition, the Flexible Sales Accounting Setup menu (G4241) enables further flexibility in defining the Business Unit, Subsidiary, and Subledger fields based on other driver fields in the Sales Order Detail table (F4211).