Creating Accounting Lines
The Accounting Line Creation process retrieves costed transactions and finds the ChartFields to use for the debit and credit lines of each accounting entry. The results are stored in the CM_ACCTG_LINE table. The process always uses the date and time of the transaction and not the transaction date that was entered. Accounting entries can be manually back dated using the Edit Unposted Accounting Lines page.
The Accounting Line Creation process searches for the correct ChartField information to build the accounting entry lines. The system searches for the ChartFields based on this logic starting with the first step and continuing until a match is found:
-
If the transaction is an interunit transfer of inventory stock, then the ChartFields to define the intransit account, interunit receivables, and interunit payables balancing entries are derived from the method that you selected for interunit accounting.
The other parts of the accounting entries are derived from these pages.
-
If location accounting is used for the storage areas or production areas, the system first searches for the correct Storage Area Accounting page or Production Area Accounts page.
When the entries on these pages match the same key fields on the transaction, then the correct ChartFields are found to build the accounting entry. Often, these pages define just one side of the accounting entry and the other side is derived from the Accounting Rules page or the interunit transfer method. The system searches for the page by starting with the first rule and continuing until a match is found:
Rule Unit Area Cost Element 1
Business Unit
Storage Area or Production Area
Cost Element
2
Business Unit
Storage Area or Production Area
Blank
-
The Accounting Line Creation process uses the Accounting Rules page (Account Distribution page) with the most specific information matching the transaction. There are some situations where more than one Accounting Rules page can match the transaction. In this case, the search for the correct Accounting Rules page uses the logic in this table starting with the first rule and going through all twelve rules. The system uses the first rule encountered that matches the transaction.
Rule Unit Trans Group Item ID Item Group Distrib Type Cost Element 1
Business Unit
Transaction Group
Item ID
Blank
Distribution Type
Cost Element
2
Business Unit
Transaction Group
Item ID
Blank
Distribution Type
Blank
3
Business Unit
Transaction Group
Item ID
Blank
Blank
Cost Element
4
Business Unit
Transaction Group
Item ID
Blank
Blank
Blank
5
Business Unit
Transaction Group
Blank
Item Group
Distribution Type
Cost Element
6
Business Unit
Transaction Group
Blank
Item Group
Distribution Type
Blank
7
Business Unit
Transaction Group
Blank
Item Group
Blank
Cost Element
8
Business Unit
Transaction Group
Blank
Item Group
Blank
Blank
9
Business Unit
Transaction Group
Blank
Blank
Distribution Type
Cost Element
10
Business Unit
Transaction Group
Blank
Blank
Distribution Type
Blank
11
Business Unit
Transaction Group
Blank
Blank
Blank
Cost Element
12
Business Unit
Transaction Group
Blank
Blank
Blank
Blank
-
ChartFields entered directly on the transaction override these rules. Often, this is just one side of the accounting entry.
Note:
If the accounting pages have not been defined correctly, then the effected transactions are written to the error table. To view any errors occurring in the CM_ACCTG process, use the Accounting Line Errors page.