This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
module:masterfile:item:list [2014/07/10 15:24] target |
module:masterfile:item:list [2017/05/04 17:26] (current) target |
||
---|---|---|---|
Line 10: | Line 10: | ||
Item Master File/List - database of company items | Item Master File/List - database of company items | ||
- | Item - company materials held for sale/trade or consumed | + | Item - company materials held for sale/trade or used as raw material of another item for possible revenue |
- | Item Record | + | Item Profile |
- | + | ||
- | System item Code - unique code produced by system for monitoring item | + | |
| | ||
**User Involve** | **User Involve** | ||
+ | |||
Supply Chain is the main responsible for maintaining a quality item master file; any memo for changes should be followed and applied by PM, Accounting officer, Warehouse Manager, Material Manager to their corresponding records and scope of responsibility. | Supply Chain is the main responsible for maintaining a quality item master file; any memo for changes should be followed and applied by PM, Accounting officer, Warehouse Manager, Material Manager to their corresponding records and scope of responsibility. | ||
+ | |||
+ | Registration, | ||
+ | |||
+ | **Related Forms** | ||
+ | |||
+ | Item Maintenance Form - a documentation record to track item master file history | ||
+ | |||
+ | note: you may download the form by clicking "Excel Forms" button found on the menu bar of Item Master File Profile | ||
**General Procedure/ | **General Procedure/ | ||
Line 23: | Line 30: | ||
**A. Registration of New Item ** | **A. Registration of New Item ** | ||
- | a.1. Identify and ensure the item/s to add in item master file (avoid duplication) | + | a.1. Identify and ensure the item/s to add in item master file (check format;avoid duplication) |
a.2. List the items in MS Excel Item Maintenance form and discuss with the group | a.2. List the items in MS Excel Item Maintenance form and discuss with the group | ||
- | a.3. Fill-up system | + | a.3. Finalize MS Excel Item Maintenance form and print |
- | a.4. Finalize MS Excel Item Maintenance form and print (system item code is now available) | + | a.4. Have the printed |
- | a.5. Have the printed Item Maintenance form approved by department head (deactivate/ | + | a.5. Disseminate copy of approved Item Maintenance form to concerned department |
- | + | ||
- | a.6. Disseminate copy of approved Item Maintenance form to concerned department | + | |
* this copy can be used as future reference for backtracking | * this copy can be used as future reference for backtracking | ||
* this copy will be used for reference when new item is encountered | * this copy will be used for reference when new item is encountered | ||
Line 39: | Line 44: | ||
* other records to be updated: cost sheets, excel running inventory, quick books SKU, actual item labels, etc,. | * other records to be updated: cost sheets, excel running inventory, quick books SKU, actual item labels, etc,. | ||
+ | a.6. Fill-up system Item Master File Profile and save record (you now have an active new item) | ||
+ | |||
a.7. File copy of Item Maintenance form in Item Maintenance Folder | a.7. File copy of Item Maintenance form in Item Maintenance Folder | ||
- | |||
**B. Modification of Item ** | **B. Modification of Item ** | ||
Line 51: | Line 57: | ||
b.4. Disseminate copy of approved Item Maintenance form to concerned departments | b.4. Disseminate copy of approved Item Maintenance form to concerned departments | ||
+ | * other records should be updated at this point too | ||
+ | * other records to be updated: cost sheets, excel running inventory, quick books SKU, actual item labels, etc., | ||
+ | |||
b.5. Modify affected item in system Item Master File Profile | b.5. Modify affected item in system Item Master File Profile | ||
- | | + | |
- | * other records to be updated: cost sheets, excel running inventory, quick books SKU, actual item labels, etc., | + | |
b.6. File copy of Item Maintenance form in Item Maintenance Folder | b.6. File copy of Item Maintenance form in Item Maintenance Folder | ||
Line 61: | Line 67: | ||
c.1. Identify item/s to deactivate in item master file (note: item should have/ | c.1. Identify item/s to deactivate in item master file (note: item should have/ | ||
+ | *see [[module: | ||
c.2. List the item/s in MS Excel Item Maintenance form and discuss with the group | c.2. List the item/s in MS Excel Item Maintenance form and discuss with the group | ||
Line 67: | Line 74: | ||
c.4. Disseminate copy of approved Item Maintenance form to concerned departments | c.4. Disseminate copy of approved Item Maintenance form to concerned departments | ||
- | |||
- | c.5. Deactivate affected item in system Item Master File Profile | ||
* other records should be updated at this point too (removal from list if necessary) | * other records should be updated at this point too (removal from list if necessary) | ||
* other records to be updated: cost sheets, excel running inventory, quick books SKU, actual storage, etc., | * other records to be updated: cost sheets, excel running inventory, quick books SKU, actual storage, etc., | ||
+ | |||
+ | c.5. Deactivate affected item in system Item Master File Profile | ||
c.6. File copy of Item Maintenance form in Item Maintenance Folder | c.6. File copy of Item Maintenance form in Item Maintenance Folder | ||
Line 77: | Line 84: | ||
| | ||
d.1. Identify item/s to reactivate in item master file (note: item beginning balance should have proper documentation) | d.1. Identify item/s to reactivate in item master file (note: item beginning balance should have proper documentation) | ||
+ | *see [[module: | ||
+ | *see [[module: | ||
d.2. List the item/s in MS Excel Item Maintenance form and discuss with the group | d.2. List the item/s in MS Excel Item Maintenance form and discuss with the group | ||
Line 90: | Line 99: | ||
d.6. File copy of Item Maintenance form in Item Maintenance Folder | d.6. File copy of Item Maintenance form in Item Maintenance Folder | ||
| | ||
- | Notes: | + | **Notes:** |
- | For further instructions on how create a new item record | + | For details about filling up item profile (Item Masterfile Profile) |