Inventory Suppliers Report

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:

LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets 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 More Fields dropdown menu to add some of them to your report.


Fields
SKUProduct SKU
ProductThe name of the product in DEAR
SupplierThe name of the supplier
Supplier SKUProduct SKU as specified by the supplier
Supplier Product NameProduct Name as specified by the supplier
CategoryProduct category
BrandProduct brand
Product TagsComma-separated product tags
FamilyProduct family name
UnitProduct unit of measure
Supplier Product URLURL of the web page describing the product on the supplier's web site
Supplier Additional Attribute 1-10Values of additional supplier attributes
Product Additional Attribute 1-10Values 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

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.