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.
Data from this report can be exported in Excel, PDF or RTF format.
|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.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|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|
|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|
|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|