Page History: PO Receipt Import (Central States)

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Wed, 26 Feb 2020 08:04

Table of Contents [Hide/Show]

   General Description
   Key Import Fields
      Sample Import File
      Mapping Screen

General Description¶

Default Menu Location: Transaction >> Importers/Exporters >> Purchase and Sales Orders >> Import PO Receipt

Screen Name: IMPORTCSPO

Function: Uses an order confirmation file from Central States vendor to process cost updates only (see checkbox on screen) or cost updates and quantity receipts (occurs when Update Cost Only not enabled)

This screen has only been tested with a specific file from Central States and has not been tested or used for any other purpose.

Key Import Fields¶

PO: The system finds the PO number following the hyphen below the PO column header (cell E2)

Item ID: Adjutant matches the data in the Item ID column to the Adjutant PO line item vendor part numbers

Order Qty: The system uses this column and the Pieces columns to identify the column length (if applicable) for matching and quantity for receiving

Pieces: This column is used for rows with a length to identify the quantity to receive

Part Mark: This column is used to match to the appropriate PO line, where applicable

Unit Price: This column is used for the cost update when updating cost only and when processing PO line receipts

Sample Import File¶

Sample Import File

Mapping Screen¶