This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
module:inventory:importation:list [2018/08/09 19:09] target |
module:inventory:importation:list [2018/08/16 18:28] (current) target |
||
---|---|---|---|
Line 12: | Line 12: | ||
Importation Record - consists pertinent information about the registered Shipment; found under Inventory Menu> | Importation Record - consists pertinent information about the registered Shipment; found under Inventory Menu> | ||
- | Shipment Number- unique code produced | + | Shipment Number- unique code provided |
**User Involve:** | **User Involve:** | ||
- | Supply chain managers (SC) are in charge of maintaining and processing inventory orders while maintaining close coordination with importation | + | Supply chain managers (SC) are in charge of maintaining and processing inventory orders while maintaining close coordination with Importation |
- | Importation processes importation of inventory order until released and delivered to assigned destination | + | Importation processes importation of inventory order shipments |
**Forms** | **Forms** | ||
- | Inventory Order profile - a web system form use to have a copy of items on order base on order confirmation (OC) or supplier' | + | Importation |
- | OC Template | + | Importation Forms - a matching excel file of importation profile; records data for csv uploading |
- | + | ||
- | Order Confirmation (OC) - the printed record | + | |
**General Procedure/ | **General Procedure/ | ||
- | **A. Creating | + | **1. Registration and Maintaining |
+ | |||
+ | 1.1. Log on to the system and access Importation | ||
+ | |||
+ | 1.2. Select “New” to open Importation Profile, then fill up the form | ||
+ | |||
+ | 1.3. Select Inventory Order tab and add orders of the same shipment from the selection | ||
+ | |||
+ | 1.4. Click “Save” to register and complete other requirement as data becomes available | ||
+ | |||
+ | 1.5. Create a copy of excel Importation template using the registered shipment number; fill sheet -ID Form-1 & | ||
+ | 2 with the available data and print | ||
+ | |||
+ | 1.6. Create a manual folder for compiling shipment documents; attach and fill ID Form -1 & 2 together with other files as document becomes available | ||
- | a.1. access inventory order module under inventory menu | + | 1.7. Upload csv data from excel to the system (see separate procedure) |
- | a.2. fill-up inventory order profile given the reference order list from excel file | + | 1.8. |
- | a.3. click " | + | **2. Upload CSV data from excel to the system (for Broker, Customs and Docs tab)** |
- | **B. Using Inventory Order Import Detail function** | + | 2.1. Completely fill up form-1 & 2 of importation excel template |
- | b.1. Summarized | + | 2.2. Open the shipment |
- | b.2. copy the columns (item code, total qty, description) and paste to the importing template or sheet | + | 2.3. Click “upload” button |
- | b.3. high-light the column headers down the last item of the pasted details | + | 2.4. |
- | b.4. run the macro (macro name:?) (the macro will create a CSV data in noted pad) | + | 2.5. Click upload and save |
+ | |||
- | b.5. save the file in assigned folder | + | **3. |
- | b.6. access the inventory order record you want to have details imported (see A. Creating an Inventory Order Record) | + | 3.1. |
- | b.7. click " | + | 3.1.1. Open Shipment record you want to update status |
- | b.8. copy and paste the text generated | + | 3.1.2. Select appropriate status |
- | b.9 click " | + | 3.1.3. Click “save” to update |
- | b.10. review correctness and click " | + | 3.2. |
- | **C. Updating an Inventory Order Record** | + | 3.2.1. Open Shipment record you want to update status |
- | c.1. select an Inventory Order you want to update; update can be: a. revision of details | + | 3.2.2. Fill ATA or ARD date field |
- | c.2. revise or update to reflect current information (also see D. Finalizing a Parts List Record) | + | 3.2.3. Click “Save and Update Status” button |
+ | |||
+ | **4. Add Shipment Logs** | ||
- | c.3. click “save” | + | 4.1. Open the Shipment you want to have Log or notes on |
- | **D. Confirming an Inventory Order Record** | + | 4.2. Go to Logs tab |
- | d.1. process the invoice | + | 4.3. Click add log (+) button |
- | d.2. select the corresponding inventory order in the system | + | 4.4. Set date and type your log |
- | d.3. click " | + | 4.5. Click “save” ; note: saved logs will be shown on Shipment Log Report |
**Notes:** | **Notes:** | ||
- | For information about inventory order profile please see [[module: | + | For information about Importation |