Print Columns Category / Subcategory line: Category / Subcategory (Formatted as 99 XXX / 999 XXX) number> <category name> + + <subcategory ‘/‘ number> <subcategory name> on DP_ID, get FoodCategory.CategoryNr, FoodCategory.Name, Product.SubCategoryNr, Product.Name). Detail line: UPC/PLU DetailProduct.UPC (formatted number) – UPC/PLU Description DetalProduct.Description – UOM (width 6) DetailProduct.UnitofMeasureCd (USDA UOM – Description) Units DetailedProduct.QuantityBenefit – Quantity DetailProduct.BenefitQty format to 2 decimal – – places. Active See calculation – Last Used See calculation above. – Average Price See calculation above. – Purchased Quantity See calculation above. – Total Paid See calculation above. – Sort Order Category / SubcategoryUPC/PLU Total / Count None Columns Totals None Primary Group None (page break) Additional Category / Subcategory Group By Notes Due to amount of displayed information (125% of normal report); the standard report font is not used. A smaller font is used. This small mockup may need to be viewed in MS Word’s zoom mode.
Print Columns Category / Subcategory line: Category / Subcategory (Formatted as 99 XXX / 999 XXX) number> <category name> + ‘/‘ + <subcategory number> <subcategory name> on DP_ID, get FoodCategory.CategoryNr, FoodCategory.Name, Product.SubCategoryNr, Product.Name). Detail line: UPC/PLU – DetailProduct.UPC (formatted number) UPC/PLU Description – DetalProduct.Description UOM – (width 6) DetailProduct.UnitofMeasureCd (USDA UOM Description) Units – DetailedProduct.QuantityBenefit Quantity – DetailProduct.BenefitQty – format to 2 decimal places. Active – See calculation Last Used – See calculation above. Average Price – See calculation above. Purchased Quantity – See calculation above. Total Paid – See calculation above. Sort Order Category / SubcategoryUPC/PLU Total / Count Columns None Totals None Primary Group (page break) None Additional Group By Category / Subcategory Notes Due to amount of displayed information (125% of normal report); the standard report font is not used. A smaller font is used. This small mockup may need to be viewed in MS Word’s zoom mode.
DFDD%20VM%20Vendor%20Management%20Reports%20(3).docx