PD Customer Pricing Report CSV output
This table shows the fields included in the CSV output file created by the PD Customer Pricing Report.
Note: Most prices, costs, rebates, margins, and discounts can be validated in Sales Customer Pricing Inquiry.
| Field | Source |
|---|---|
| Cust No | Customer Setup |
| CPT | Customer Price Type in Customer Setup or Customer Ship To Setup |
| Ship To | Customer Ship To Setup |
| Product | Product Setup |
| Description 1 | Product Setup |
| Description 2 | Product Setup |
| Cust Prod | Customer Product in Product Extended Product Cross Reference Setup |
| UOM | Unit of Measure in Product Setup |
| Price | Base Price in Product Warehouse Product Setup or Product Catalog Setup |
| Cost | Replacement Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup |
| Margin % | Calculated based on Net Price, Actual Cost and Rebate Amount |
| Vendor | ARP Vendor in Product Warehouse Product Setup or Vendor in Product Catalog Setup |
| Product Line | Product Warehouse Product Setup or Product Catalog Setup |
| PPT | Price Type in Product Warehouse Product Setup or Product Catalog Setup |
| RBT | Rebate Type in Product Warehouse Product Setup or Product Catalog Setup |
| Sub RBT | Sub Rebate Type in Product Warehouse Product Setup or Product Catalog Setup |
| PDSC # | Record # in PD Pricing Setup |
| Level | PD Pricing Setup |
| End Date | PD Pricing Setup |
| PDSR # | Rebate Record # in PD Pricing Setup |
| Level | Rebate Level in PD Pricing Setup |
| End Date | Rebate End Date in PD Pricing Setup |
| Disc Amt | Discount percent for the Rebate Level in PD Pricing Setup |
| Net Price | Calculated price based on selling UOM, with discounts applied. If no selling UOM, stocking UOM is used. |
| Rebate | Calculated rebate amount (as calculated in Sales Customer Pricing Inquiry). If tied to a pricing worksheet, the cost from the pricing sheet is used. |
| UPC# | Vendor UPC in Product UPC Number Setup, based on product and ARP or catalog vendor |
| List Price | Product Warehouse Product Setup or Product Catalog Setup |
| Base Price | List Price in Product Warehouse Product Setup or Product Catalog Setup |
| Average Cost | Average Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup |
| Standard Cost | Product Warehouse Product Setup or Product Catalog Setup |
| Replacement Cost | Replacement Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup |
| Last Cost | Last Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup |
| Vendor Product | Product Warehouse Product Setup or Product Catalog Setup |
| Catalog | Yes or No; Product Catalog Setup |