PD Administrator Automatic Pricing Report overview

Pricing and Discounting > Administration > PDA Reports > PDAA

Function acronym: PDAA

Use this report to update your inventory records with data from a pricing service bureau or another source that provides pricing and descriptive product information.

The ranges and options that you specify on the report use the parameters from PD Automatic Pricing Setup to update your product records.

The data from your service bureau must be saved as a text file with individual records delineated by quotation marks.

This report provides you with an audit trail for the prices and costs that are updated by service bureau records. It can also create product and pricing records and cross-reference your product numbers with those used by the service bureau.

If PD Automatic Pricing Setup records are created, Product Setup records are also created. Associated records in Product Warehouse Product Setup and PD Pricing Setup-Customer must be set up before theses events can occur:

  • The product can be ordered.
  • The product prices can be changed through subsequent PD Administrator Automatic Pricing Report updates.

The PD Administrator Automatic Pricing Report also updates the Standard Cost field in Product Catalog Setup records. If catalog records are created, the product line from PD Automatic Pricing Setup is used if the product line in the pricing file is not provided.

If you use the PD Administrator Automatic Pricing Report to create or maintain pricing records, restrict the use of pricing record types to Type 7. PD Administrator Automatic Pricing Report only creates Type 7 non-promotional records. If record types 1 through 6 or promotional records exist, their prices override those created by the report. If you use a pricing method that is based on list price or cost, pricing records that are created PD Administrator Automatic Pricing Report are not required.

The Date fields for the replacement cost and standard cost in Product Warehouse Product Setup-Costs are updated when the PD Administrator Automatic Pricing Report is generated. The cost is changed if the Standard and Replacement in PD Automatic Pricing Setup is any value except None. Not all product costs are updated each time you run the report. Use the Date field to identify the last date of a change to a cost.

Verifying cross-referenced products

Cross-referenced products are set up in Product Extended Product Cross Reference Setup. For some cross-referenced products, a product ID can match multiple products that are sourced from different vendors. The Authorized Replenishment Path (ARP) vendor from the Product Warehouse Product Setup record is verified whenever an interchange or auto price records exist for the imported product ID. This process ensures that the correct product is updated.

To verify the ARP vendor, the Use Product Xref option must be selected in PD Automatic Pricing Setup. The vendor number must also be provided by the pricing service. If the vendor number is not provided, the first matching cross reference that is found is used by the report. If more than one warehouse product matches the cross-reference product and ARP vendor, then the first matching product that is found is used.

Custom processing

Custom programs can be automatically executed by the PD Administrator Automatic Pricing Report. If a compiled pdxxxx99.r file is stored in the Product Import directory, the report is processed according to the program. Otherwise, standard processing is used.

Infor Consulting Services (ICS) coordinates the use of custom '99' programs with customers. Contact ICS to implement this feature.