PI Import History Inquiry field descriptions

Fields are presented in alphabetical order within each section.

Imports grid

Date: The date displayed is the date that the update file or sequence was updated when PI Entry Update Products Report was run.
Journal #: Each time a file is updated in PI Entry Update Products Report, a journal is opened. If standard or replacement costs for an existing product with on-hand balances are changed, GL entries are posted to this journal for the cost differences. That journal number is displayed in this field. If transactions were posted to General Ledger, those can be viewed in GL Journal Inquiry or printed in PI Entry Journal Print Report.
Price Decreases: These fields are not functional at this time.
Price Increases: These fields are not functional at this time.
Sequence Number: An update file is assigned a sequence number when an import is performed. If multiple update files exist with the same update number, each has a different sequence number displayed in this field.
Status: The status of an update is either selected [Active] or cleared [Inactive].
Update Number: The update number is displayed in this column. Update numbers are assigned by the PI Administrator Import File Report.

Details of Import tab

Calendar Period: This reflects the calendar period, from 1 to 12, depending on the month in which this file was updated. If you operate under a calendar year from January to December, the calendar period is the same as the fiscal period.
Date Read: This is the date the file was imported in Product Import Administrator Import File.
Date Updated: This is the date this update file and sequence was updated in Product Import Entry Update Products.
Fiscal Period: The fiscal period in which this journal was posted is displayed. Because this journal was opened automatically during Product Import Entry Update Products, the current fiscal period is the default value from the current posting period defined in SA Administrator Options-Financials.
G/L Credit $: The total credit amount posted to General Ledger in this journal is displayed.
G/L Debit $: The total debit amount posted to General Ledger in this journal is displayed.
Issue Date: The issue date is from the import file. This is the date the product information was issued by the pricing service.
Journal #: The number of the journal that was opened during Product Import Entry Update Products is displayed.
Report Date: This is the first date this file was printed in Report From Update File Entry or during Product Import Edit Product Update File-Print. If the file has never been printed through either of these functions, but has been updated, the Update Date is displayed in this field.
Set #: The set number from this journal is displayed. Only one set exists per journal.
Update #: This is the update number of the file.

Active/Inactive Products tab

A list of products that have the filtered import type are displayed. Select Active Products or Inactive Products to further filter the list.

Description

The information mapped and stored as the Description field is displayed for each active item in the update file.

Import Type

The import type of this update file is displayed.

Issue Date

The date this import file was issued by your pricing service is displayed.

Product

The product number that is used to update the Product entity records is displayed. This is the number after it has been manipulated during the import process. This is not the raw product identifier.

Status

The status reflects the option you selected [Active] or cleared [Inactive].

Update

The action to be taken for this item is displayed. This action may be Update, Ignore, Hold, Delete, or Error.

See Product Import - Entry - Edit Product Update.

Update #

The update number for this file is displayed.

Warehouse

The warehouse attached to this line item is displayed. The same product may be listed more than once if it is attached to different warehouses. The warehouse is assigned on the Product Import Price/Cost Multipliers Setup record for each supplier group.

Details

In the grid of the Active/Inactive Products tab, expand a listed product to access additional tabs:

Product Details: Shows details specific to the product.
Raw Import Data: Shows the data mapped for the import file, before any modifications were made, such as product name manipulation or price/cost multiplying. With this inquiry, you can see how the file was mapped and determine how field values were imported into the edit update file.
Industry Data Warehouse: Shows any data originating from an IDW update file.
Price/Cost/Quantity Breaks: Shows any data where the supplier has indicated a price, cost, or quantity break.
User/Xref Fields: Shows any data you have defined and mapped for these fields in PI Import Definitions Setup. If the field is not mapped, this field is blank.