Item Hierarchy file must be setup to indicate the various Stock Accounts to be used depending on the Hierarchy structure.
Where the General Ledger Stock Account is to be found is determined by the setup in TMSDS/IM-GLCVM – Item General Ledger code validation method. On the Item Masterfile there is a field General Ledger Code. The Stock Account to be used for all stock movement postings for this Item can be recorded in this field. TMSDS/IM-GLCVM determines whether or not the entry in this field should be validated and if so it is validated against the account listed in TMSDS/IM-IGLC. The General Ledger Code field can be left blank on the Title Masterfile and TMSDS/IM-GLCVM can be setup to derive the Stock Account from the Item Hierarchy. In which case, this Item Hierarchy file must be setup to indicate the various Stock Accounts to be used depending on the Hierarchy structure. So for example specific Divisions of product could each have their own Stock Account in the General Ledger.
If the General Ledger Interface is being used, none of the above is applicable.
Add an item hierarchy
- In the menu, expand Base Modules > Distribution > Masterfiles >Database Management > Database Management > Item Masterfiles > Item masterfiles and double-click IM Hierarchy Maintenance. DSM013 Item Hierarchy Maintenance panel appears.
| Note | To change the GL code for an item hierarchy, select the applicable hierarchy and click option GL code. |
- Click Add. DSM013 Item Hierarchy Maintenance panel appears in Add mode.
| Field | Description |
| Levels 1 – 5 | Level codes form part of the Item Classification hierarchy. This analysis code is important for on-line Sales Analysis, inquiries and reports. It is used, for example, in financials and purchase planning. There are 5 level hierarchy codes in the Title masterfile but not all levels have to be used. If a change is made to the hierarchy once processing has started, the Sales History files may need to be rebuilt. Level 1 - referred to as the Title class. Level 2 - referred to as Title division. Level 3 - referred to as the Title group. Level 4 - referred to as Title category. Level 5 - referred to as the Title sub category. |
| GL code |
If the account must be taken from the Item Hierarchy (D) this field becomes protected (no underline) as no entry is required. If No validation is required, an account can be entered without it validating to TMSDS/IM-IGLC even though F4 lists the accounts established in that control file. |
- Select the Levels required for the summarisation of data into different levels and enter the appropriate General Ledger Account.
- Click OK to confirm.
