# Infor M3 Chart of Accounts and Accounting Dimensions Worksheet > Source: https://netray.co/tools/infor-m3-accounting-dimensions-chart-of-accounts-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Plan the M3 chart of accounts and the other accounting dimensions (AIT1 to AIT7) row by row before setting up accounting identities in CRS630. ## Category infor-cloudsuite ## Erp Infor M3 ## Audience - M3 finance consultant - Controller - M3 administrator ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Dimension **Key:** dim **Type:** select **Options:** - AIT1 - AIT2 - AIT3 - AIT4 - AIT5 - AIT6 - AIT7 #### Accounting identity **Key:** code **Type:** text #### Description **Key:** desc **Type:** text #### Balance sheet or P&L **Key:** acct_type **Type:** select **Options:** - Balance sheet - P&L - Not an account (AIT2-7) #### Normal sign **Key:** sign **Type:** select **Options:** - Debit - Credit - Either #### Mandatory dimensions **Key:** mandatory **Type:** text #### Valid from **Key:** valid_from **Type:** date #### Owner **Key:** owner **Type:** text #### Notes **Key:** notes **Type:** text **Rows:** **Dim:** AIT1 **Code:** 1510 **Desc:** Inventory raw material **Acct type:** Balance sheet **Sign:** Debit **Valid from:** 2027-01-01 **Owner:** Group finance **Notes:** Inventory postings from receipts and issues **Dim:** AIT1 **Code:** 2410 **Desc:** Accounts payable trade **Acct type:** Balance sheet **Sign:** Credit **Valid from:** 2027-01-01 **Owner:** Group finance **Notes:** Supplier invoices **Dim:** AIT1 **Code:** 3010 **Desc:** Sales domestic **Acct type:** P&L **Sign:** Credit **Mandatory:** AIT3 **Valid from:** 2027-01-01 **Owner:** Group finance **Notes:** Product group required for margin **Dim:** AIT1 **Code:** 5010 **Desc:** Material consumption **Acct type:** P&L **Sign:** Debit **Mandatory:** AIT2 **Valid from:** 2027-01-01 **Owner:** Plant controller **Notes:** Cost center required **Dim:** AIT1 **Code:** 6110 **Desc:** Maintenance spare parts **Acct type:** P&L **Sign:** Debit **Mandatory:** AIT2 **Valid from:** 2027-01-01 **Owner:** Plant controller **Dim:** AIT2 **Code:** CC100 **Desc:** Production line 1 **Acct type:** Not an account (AIT2-7) **Sign:** Either **Valid from:** 2027-01-01 **Owner:** Plant controller **Notes:** Cost center **Dim:** AIT2 **Code:** CC200 **Desc:** Maintenance **Acct type:** Not an account (AIT2-7) **Sign:** Either **Valid from:** 2027-01-01 **Owner:** Plant controller **Notes:** Cost center **Dim:** AIT3 **Code:** PG10 **Desc:** Hydraulic components **Acct type:** Not an account (AIT2-7) **Sign:** Either **Valid from:** 2027-01-01 **Owner:** Sales controller **Notes:** Product group **Summary:** #### Accounting identities listed **Key:** rows **Expr:** count **Format:** integer **Notes:** Dimension 1 (AIT1) is the account; dimensions 2 to 7 are free to define per company, for example cost center and product group. Accounting identities are maintained in CRS630 (Accounting Identity. Open). Posted general ledger lines in FGLEDG carry the identities in EGAIT1 to EGAIT7. The meaning of AIT2 to AIT7 in the examples is a design choice, not an M3 default. ## Content **Intro:** This worksheet designs the chart of accounts and the other accounting dimensions for Infor M3 13.x, one accounting identity per row, before anyone enters them in CRS630. It keeps account type, sign, mandatory dimension rules and ownership in one place for finance and IT to agree. **Sections:** #### How to use it **Body:** Pick the dimension, enter the accounting identity code and description, and for accounts (AIT1) mark whether it is balance sheet or P&L and its normal sign. In the mandatory column list the other dimensions a posting on that account must carry, for example AIT2 for cost-driven expense accounts. Add a valid-from date and an owner who approves changes. Export the sheet, review it with controllers in each company, then use it as the entry list for CRS630. **Bullets:** - Decide what AIT2 to AIT7 mean before coding any values - Keep code lengths and patterns consistent per dimension - Record who may open new identities after go-live #### Where this lives in M3 **Body:** M3 accounts with up to seven accounting dimensions. Dimension 1 is the account; dimensions 2 to 7 are defined per company for whatever the business needs to analyse, such as cost center, product group, project or market. Every value in any dimension is an accounting identity, maintained in CRS630 (Accounting Identity. Open). When transactions post, the general ledger table FGLEDG stores the identities in EGAIT1 to EGAIT7, which is where reports and extracts read them. #### Worked example **Body:** A manufacturer uses AIT2 for cost center and AIT3 for product group. Sales account 3010 requires AIT3 so margin can be reported by product group; material consumption 5010 and maintenance 6110 require AIT2 so costs land on a line or department. Balance sheet accounts such as inventory 1510 and payables 2410 need no extra dimension. With eight rows the design is small, but the same structure scales to a few hundred accounts and cost centers. #### Common mistakes **Body:** Using a dimension for two meanings in different companies makes group reporting painful. Making too many dimensions mandatory forces users to guess values. Creating accounts directly in CRS630 without a reviewed list leads to duplicates such as two spare parts accounts. Changing what a dimension means after go-live breaks history in FGLEDG. Agree the dimension meanings, the mandatory rules and the owner first, then load. **Cta:** If controllers want to ask M3 finance questions by account and dimension in plain English, on your own servers, we can set up a private assistant over FGLEDG. **Faq:** #### How many accounting dimensions does Infor M3 have? **Answer:** Seven. Dimension 1 (AIT1) is the account and dimensions 2 to 7 are defined per company for analysis such as cost center or product group. Each value is an accounting identity, and the general ledger table FGLEDG stores them in EGAIT1 to EGAIT7. #### Where is the chart of accounts maintained in M3? **Answer:** Accounts and other dimension values are accounting identities maintained in CRS630 (Accounting Identity. Open). Design the list first, for example with this worksheet, then enter or load it and check that the dimension rules behave as expected in a test company. #### Should every account require a cost center? **Answer:** No. Balance sheet accounts usually do not need one. Require cost center on expense accounts where cost responsibility matters and product group on revenue and cost of sales accounts where margin analysis matters. Too many mandatory dimensions slow entry and invite guessed values. #### How do I report on M3 dimensions? **Answer:** Posted lines in FGLEDG carry EGAIT1 to EGAIT7, so reports can group by any dimension. Keep the meaning of each dimension consistent across companies so group reporting can combine them without mapping tables. ## Search terms infor m3 chart of accounts, infor m3 finance module pdf, m3 accounting dimensions, m3 accounting identity crs630, m3 ait1 ait7, m3 fgledg dimensions --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json