This program is used to update selected Item masterfile fields and Item classification records, based on selection criteria which include sales figures, released date and Item hierarchy, for a range of items.
Update item master fields
- In the menu, expand Base Modules > Distribution > Masterfiles >Database Management > Database Management > Item Masterfiles > Other Item Maintenance and double-click IM Item Mass Maintenance. DSM028 Title Mass Maintenance panel appears.
| Field | Description |
| Sales period from | This is the sales date from which items should be considered for fields update. |
| Sales period to | This is the sales date till which items should be considered for fields update. |
| Sales quantity | The Sales quantity accumulated over a period range. This has two field entries. The first is a greater than > sign or a less than sign < and the second is the actual sales quantity. |
| Released before | You can select titles that were published before a specified time, enter the applicable date. |
| Customer Group |
Customer groups are defined in TMSDS/CC-ICG. Stock status, Release date, Cease date, Firm sale and Item links are defined by Customer Group. Those customers that do not belong to one of the defined Customer Groups will have their items dealt with according to the global definition. |
| Item classification type | Items can be categorized into several classification types. Prompt to select a valid classification type from TMSDS/IC-TYPES. |
| Item classification code | Once a classification type has been selected, an individual code belonging to the Type is selected |
| Item classification Eff. Date | This is the date from which classification value is to be updated. |
| Stock status | This code identifies the reason why a particular order has been placed on backorder. Prompt to select a valid stock status code from TMSDS/IM-IBOR. |
| Brand code | This is user defined codes used in Item masterfile. This is imprint. Prompt to select a valid brand name from TMSDS/IM-BRND. |
| Packaging | This field defined various types of packaging defined in item masterfile. Prompt to select a valid packaging value from TMSDS/IM-PKG. |
| Item 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. |
| ABC classification | This code classifies the item relative to its usage and/or value like slow moving, high value. ABC classifications can be updated automatically based on average unit costs and annual usage to provide a dollar value and a corresponding classification (based on user-defined, percentage rankings). A report, with an optional update of this field, is run at month end and shows Cost movement in descending order for each item along with the current ABC Class and the suggested ABC Class. The last 12 months movement in and out of the warehouse is accumulated. The percentage of warehouse movement is calculated as Item Cost Movement divided by Whole Warehouse Cost Movement. The ABC class is updated based on stock movement percentage as defined in TMSDS/IM-ABCS. Refer to WHS Stock Take documentation for more information. |
| Profile code |
- Enter the required information.
- Click OK to confirm. The background processor then updates the fields specified .
