Inventory Management—To-Be process

This section provides the proposed "To-Be" process for Inventory Management. The following recommended solutions are the suggested solutions for Inventory Management implementation.

Branch/Plant address and search types

It is suggested that Address Book Numbers should be defined for all branch/plants to maintain detail information in the system. Each store must have an address book number to register all relevant information, such as storekeeper, other contact person, phone number, and store classification (if required).

Note

Address Book — Search Type (for branch/plants) should be entered as F.

Item master

The item master information can be defined for both stocked and non-stocked items. The item master information includes the item number, item name, description, and general information related with the item.

Item coding

Client material is represented by three numbers:

First identification—short number

This is a system-generated numeric counter for all items.

Second identification—product number

This is an alpha-numeric number. It is agreed during the business analysis to use the current item number for the client.

Third identification—catalog number

This is an alpha-numeric number and it will be used to maintain the supplier item number as the reference number.

Costing level

This is suggested that all stock items should have a costing level set at the store level and not by location. In the Item Master Costing Method, you should specify 2, which is the Item Cost at Branch/Plant Level.

Average cost

The average cost will be calculated online during the processing of inventory receipts, adjustments, and transfer receipts. Average cost will be maintained at the store level.

Costing method

The client will use Average Costing Method (02) for all inventory transactions of purchased items, and this will be calculated automatically. Last Purchase Price Method (01) will be used for purchase requests and purchase orders. However, the following costing method will be defined for each item in the system:

  • Last in
  • Weighted average
  • Purchasing cost
  • Standard cost (this may not be required)
  • Manufacturing last (for manufactured items only)
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset