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 |