ASN Portal Instruction Guide - LogisticsWebPortal



Dashboard Instruction Guide



[pic]

This application allows users the ability the view inventory reports, transactions reports, and ROP reports.

□ Data is real time and available 24/7.

□ All reports are exportable to Excel.

□ CEVA recommends that users download each report once a month as data is only available for 60 days.

□ Ability to view inventory, and transactional history within multiple CEVA SLC sites where applicable.

Select Location:

User will have the choice of Receipts, Inventory Report, Receiving Report, Shipping Report, Vendor Loads Shipped Report, Inventory Detail, ROP, Adjustment Report, Aged Inventory, and Qip Transaction.

[pic][pic]

Report Types

Receipts Report– Report used to see receiving information with individual pallet detail.

[pic]

Column Headings

Packing List – Packing list number received against.

Status – In-Progress, Received, or Closed.

SOI – Vendor or Supplier ID number

Supplier – SOI-Supplier Name

Expected – Qty expected from either packing list or ASN entered.

Good – Qty received in good condition.

Damaged – Qty received in damaged condition.

Short – The Qty difference between what was expected and physically received.

Pallets – Number of pallets received.

Date Received – Date/Time received.

User – CEVA Personnel that completed the receipt.

Comments – Additional comments entered by CEVA personnel.

Receipt Detail – Provides additional receiving information per receipt. User selects the line desired, and then clicks “Receipt Detail”.

[pic]

Column Headings:

Line – Line number received on.

Part – Part number

Description – Description set up in the item master.

Expected – Qty expected

Actual – Qty received

Damaged – Qty received damaged.

Short – The Qty difference between what was expected and actually received.

Receipt Inventory – Provides additional receiving information specific to individual pallet. User clicks “Receipt Inventory”.

[pic]

Column Heading:

Line – Line number received on.

Part – Part number.

Description – Description set up in the item master.

SOI – Vendor or Supplier ID

Supplier – SOI-Supplier Name

Location – Location pallet was received in at the CEVA SLC.

MU – Pallet ID assigned by CEVA SLC as a unique identifier.

Qty – Pallet quantity for the specific pallet.

Inventory Report – Report showing real time inventory for all part numbers.

[pic]

Column Headings:

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Part No. – Part Number

Qty ATP – Quantity Available to Pull (Not on Quarantine/Hold or Allocated to a previous Order).

Qty in QIP – Quantity on Quarantine or Hold. Unavailable to Ship.

Qty Allocated – Quantity allocated to an open order.

Qty Total – Quantity available, Qip/Hold, and Allocated combined.

Receiving Report – Report showing receiving transactions.

[pic]

Column Headings:

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Status – Receiving statuses are In-progress, Received, or Closed.

Part No. – Part Number

Qty Shipped – Quantity expected based on packing list or ASN submitted.

Qty Received Good – Quantity received in good condition.

Qty Received Damaged – Quantity received in damaged condition.

Qty Short – The quantity difference between expected quantity and actual quantity received.

Pallets Received – Number of pallets received.

Packing List No. – Packing list number provided on the ASN.

First Date Received – Date/Time first pallet received.

Last Date Received – Date/Time last pallet received.

Blanket PO – PO number entered on the ASN.

Truck # – Truck number entered on the ASN.

Master BOL – Master BOL entered on the ASN.

Manifest # - Manifest number entered on the ASN.

Ship Unit Measure – Unit of Measure entered on the ASN.

Misc.-Miscellaneous information entered on the ASN.

Receiving Detail – Additional receiving information at a line level.

User can double click on the desired line or select Receiving Detail from the menu on the left side of the screen.

[pic]

Column Headings:

SOI – Vendor or Supplier ID.

Packing List No. – Packing List number received against.

Part No. – Part Number.

MU – Pallet ID assigned by CEVA personnel as a unique identifier.

Qty Received – Pallet quantity received.

Date Received – Date/Time received.

Received By – CEVA personnel who received the pallet.

Shipping Report - Report used to see shipping transactions.

[pic]

Column Headings:

Order/Packing List No. – Packing List number the shipment was received against.

Blanket PO Rel # - Blanket PO Release Number provided on the order.

Part No. – Part Number

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Qty Ship – Quantity shipped.

# of Plts – Number of Pallets shipped.

# of Ctns – Number of Cartons shipped.

Ship Date – Date/Time of the order.

BOL No. – BOL number assigned to the order.

EPOD Close Date – Date/Time the order confirmed received and closed.

Delivery Location – Delivery Destination.

Vendor Loads Shipped Report – Report used with additional shipping information.

[pic]

Column Headings:

Pick Ticket – Packing List number

Ship To – Delivery Destination.

Line No. – Line number on the packing list part number shipped on.

Part – Part Number.

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

MU – Pallet ID assigned by CEVA personnel as a unique identifier.

Parent MU – Original Pallet ID that carton was picked from.

Qty – Qty for the MU per line.

Date Shipped – Date/Time of the shipment.

Storage Date – Origination date of the Parent MU.

Inventory Detail Report – Report used to see inventory for part numbers with current inventory. This report is real-time data and can not be filtered to view inventory for a previous date/time.

[pic]

Column Headings:

Part – Part Number

Description – Description set up in the item master.

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

SOI QOH – Quantity on Hand for part number/SOI.

SOI QOA – Quantity on Allocation for part number/SOI.

SOI QOR – Quantity on Reserve (Qip or Hold) for part number/SOI.

SOI ATP – Quantity Available to Pull.

Inventory Location – Report used to see actual pallets/MU/storage dates for product in inventory. This report is real-time data and can not be filtered to view inventory for a previous date/time.

[pic]

Column Headings:

Location – Location product resides in within the CEVA SLC.

MU – Pallet ID assigned by CEVA personnel as a unique identifier.

Item – Part Number

Description – Description set up in the item master.

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Status – Status of the pallet. Quarantine, Hold, or Available.

Storage Date – Origination Date/Time of the pallet.

Age – Number of days in inventory.

Backorders – This report displays all orders that have been received from an end customer that requested material that was not on hand at the SLC at the time of the request. The system maintains these orders and ships the necessary material as soon as it is received into the system.

[pic]

Column Headings:

PO – The Purchase Order Number included in the original order request.

Item – The Part Number on the Backorder

SOI – Vendor or Supplier ID

Supplier – SOI-Supplier Name

Order Date – The date the original order was made for the part number

Order Quantity – The total number of pieces requested on the original order.

Backorder Quantity – The remaining number of pieces to be shipped from the original order

MRID – Material Request ID associated with the original order

Pick Ticket ID – This will hold the packing list information once the Backorder is shipped

ROP – Re-Order Point report used to notify users of inventory levels based on MIN, ROP, and MAX quantities entered. ROP is maintained by the end Customer.

Color Coding – Total ATP column color coded based on the ATP column + In Transit Qty.

Green – Normal. Qty at the correct level.

Yellow – Below ROP. ATP quantity is below the set ROP level.

Red – Below MIN. ATP quantity is below the set MIN level.

Orange – Above MAX. ATP quantity is above the MAX level.

[pic]

Column Headings:

Part – Part number

Description – Description set up in the item master.

SOI – Vendor or Supplier ID

Supplier – SOI-Supplier name.

SOI QOH – Quantity on Hand for part number/SOI.

SOI QOA – Quantity on Allocation for part number/SOI.

SOI QOR – Quantity on Reserve (Quarantine or Hold) for part number/SOI.

SOI ATP – Quantity Available to Pull for part number/SOI.

Total QOH – Quantity on Hand for part number.

Total QOA – Quantity on Allocation for part number.

Total QOR – Quantity on Reserve (Quarantine or Hold) for part number.

Total ATP – Quantity

Min – Minimum quantity set.

Max – Maximum quantity set.

ROP – Re-Order Point quantity set.

In Transit Qty – In Transit Quantity based on open ASNs not received yet by the CEVA SLC.

Adjust Inventory Report – Report used to see adjustments performed by the CEVA SLC.

[pic]

Column Headings:

Timestamp – Date/Time adjusted was performed by CEVA SLC.

Reason – Reason why SLC completed the adjustment.

Location – Location within the SLC product was adjusted from or into.

MU – Pallet ID assigned by CEVA personnel that was adjusted out.

Item – Part Number.

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Quantity – Quantity adjusted. Product adjusted out of inventory will have a “-“ prefix.

Aged Inventory Report – Report used to see a complete suppliers inventory and number of days specific pallets have been in inventory.

[pic]

Column Headings:

Location – Location pallet resides in within the CEVA SLC.

Pallet/MU No. – Pallet ID assigned by CEVA personnel as a unique identifier.

Part No. – Part Number

Description – Description set up in the item master.

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Status – Status of the pallet. Quarantine, Hold, or Available.

Qty – Pallet quantity.

Date Received – Origination Date/Time of specific pallet.

Age – Number of days in inventory.

Qip Transaction Report – Report used to view Qip/Hold transactions history of specific pallets.

[pic]

Column Headings:

Location – Location pallet resides in within the CEVA SLC.

Packing List # - Packing list number the pallet was received against. Packing list number will only be present if pallet was put on Qip at the time of receipt.

MU – Pallet ID assigned by CEVA personnel as a unique identifier.

Description – Description set up in the item master.

SOI – Vendor or Supplier ID.

Supplier – SOI-Supplier name.

Status – Status of the pallet. Qip, Hold, Qip/Hold, Available.

Quantity – Quantity of the pallet.

Reason – Reason enters when changing the status of the pallet.

Timestamp – Date/Time the status change was completed.

Sorting – All Dashboard Reports allow user to sort columns. By clicking on the column headings once, report will sort by that column ascending. By clicking on the column heading twice, report will sort by that column descending.

Filtering – At the bottom of each report, filtering criteria is available to limit the information being displayed. The below fields must be entering before applying the filters.

Field – Column headings from the Drop Down menu.

Operator – Must select greater than (>), less than ( ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download