This report, like the above, shows the latest price and fixed price (if applicable) for every supplier/product combination. Use this report to customise the output to show various product details such as supplier SKU/name, category, product family, brand and more.
Prerequisite
Data from this report can be exported in Excel, PDF or RTF format.
Input:
Layout | Set to the Default layout. Allows selection of saved layouts, if any. |
Save Layout As | Allows saving a layout for potential future use. |
Reset Layout | Resets the layout to the default layout or selected saved layout. |
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
Output:
The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.
Fields | |
SKU | Product SKU |
Product | The name of the product in DEAR |
Supplier | The name of the supplier |
Supplier SKU | Product SKU as specified by the supplier |
Supplier Product Name | Product Name as specified by the supplier |
Category | Product category |
Brand | Product brand |
Product Tags | Comma-separated product tags |
Family | Product family name |
Unit | Product unit of measure |
Supplier Product URL | URL of the web page describing the product on the supplier's web site |
Supplier Additional Attribute 1-10 | Values of additional supplier attributes |
Product Additional Attribute 1-10 | Values of additional product attributes |
Data Headers | |
Latest Price | Latest Price of the product excluding discount from the most recent purchase invoice of the supplier |
Fixed Price | Fixed Price of the product defined by the supplier |