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 of a layout for potential future use.
Reset LayoutResets 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 product in DEAR.
SupplierThe name of supplier.
Supplier SKUProduct SKU as specified by Supplier.
Supplier Product NameProduct Name as specified by Supplier.
CategoryProduct category.
BrandProduct brand.
Product TagsComma-separated product tags.
FamilyProduct family name.
UnitProduct unit of measure.
Supplier Product URLURL of web page describing the product on 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 product excluding discount from most recent purchase invoice of Supplier.
Fixed Price
Fixed Price of product defined by Supplier.

Did you find it helpful? Yes No

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