SA Pricing Science Report ranges and options

Ranges

See Ranges.
Invoice Date
Specify a beginning and ending invoice date range if you are exporting data. This range is required. You can select up to two years of data to export.

Options

(E)xport or (I)mport

To export data to Pricing Science for Distribution (PSD), specify E.

To import data from PSD, specify I.

Local File Directory

If you are exporting data, leave this field blank to save the XML and CSV output in the Outbound EDI directory specified in SA Company Setup. Otherwise, specify an output directory.

If you are running CloudSuite Distribution, leave this field blank. The export files are automatically placed in your tenant-specific report location in the cloud.

If you are importing data, leave this field blank if the CSV input from PSD was saved in the Inbound EDI directory specified in SA Company Setup. Otherwise, specify the input directory.

Import File Name
Specify the name of the ZIP file to import. This is the file created by PSD and stored in your AWS S3 export bucket. Ignore this option if you are exporting a file.
Exclude I)nact, S)uper, L)abor, A)ll, N)o

Use this option to exclude certain products from the export.

Specify I to exclude products with a status of Inactive in Product Setup. Product, warehouse product, and sales line data containing a product with an inactive status are excluded from the XML file.

Specify S to exclude products that have a status of Superseded.

Specify L to exclude products that have a status of Labor.

Specify A to exclude all products that have a status of Inactive, Superseded, or Labor.

Specify N to include all products, regardless of status.

You can also specify the status types separated by a comma to indicate the products to exclude. For example, specify I, L to exclude Inactive and Labor items, but include Superseded items.

If you are importing data from PSD, disregard this option. It is not used during the import.

Import Update?

Specify Yes to update Distribution SX.e with new PD Pricing Setup records.

Specify No to run the import in Edit mode with no updating of pricing records. Refer to the report output for any lines that contain errors.

If you are exporting data to PSD, disregard this option. It is not used during the export.