US Foods – Business Analytics



Business Analytics - Frequently Asked QuestionsContents TOC \o "1-3" \h \z \u 1. How can I pull usage reports by product categories? PAGEREF _Toc306229061 \h 22. How can I see total purchases? By unit? By manufacturer? By division? PAGEREF _Toc306229062 \h 33. How can I see extended product information? PAGEREF _Toc306229063 \h 54. How can I pull purchases for a specific product group without knowing all of the product numbers? PAGEREF _Toc306229064 \h 55. How can I see summary purchases by individual store/location/unit? PAGEREF _Toc306229065 \h 86. How can I run reports by individual store/location/unit? PAGEREF _Toc306229066 \h 87. How can I select time periods for reports? PAGEREF _Toc306229067 \h 98. Can I run reports by start date and end date up to and including yesterday? PAGEREF _Toc306229068 \h 99. How can I pull a report by multiple item codes or product descriptions? PAGEREF _Toc306229069 \h 910. How can I pull reports by custom groups? PAGEREF _Toc306229070 \h 11How can I pull usage reports by product categories?Click on “Product Usage>Purchase Details Descending Dollar. Click on “Cancel” to stop the auto report.Click on “Month” to select date range.Click on the Class, Category or Group multi select box and select the desired parameter. Use “Begins with” to speed selection.Once selections are made, click on “Ok” in the lower right corner.857256425565Click “Go” in the upper left hand corner of the reporting screen.You will know the report is running when you see the clock spinning.933450424815Once report is complete, verify selections by viewing the breadcrumbs at the bottom of the report.You can now pull any of the Product Usage reports with the same filters without reselecting.How can I see total purchases? By unit? By manufacturer? By division?Click on “Product Usage>Purchase Details Descending Dollar. Click on “Cancel” to stop the auto report.Click on “Month” to select date range.Report will generate for all customers / divisions.76200558800To view the division, wait until the report finishes generating. Click on the first “View by” to expose the Division column.152400656590To view the customer name, click on “Then by” and click on “Go”. You will see the clock spinning, indicating that the data is being refreshed.76200391160Sample report showing division and customer:How can I see extended product information?Use the “View by” or “then by” on any of the reports.To see all data elements at the invoice line level, run a Data Download Report.How can I pull purchases for a specific product group without knowing all of the product numbers?Pull the report by Class, Category or Group. In the example, we will pull a report for all Chicken breasts purchased. Click on the “Group” selection box enter the words “Chicken, breast” into the “Begins with” box. Click on the “Go” button to the immediate right.Note: If you don’t know the Group name for a particular product, look on the use the Product Hierarchy posted on the Welcome page or look for the assigned hierarchy in any of the Purchase reports for the products.All of the groups that begin with “Chicken, breast” will appear. Click on the double arrows to move all of the groups to the “Selected” box and click on “OK”.You will be returned to the main screen. Click on “Go” in the upper right corner. The report will generate in a minute or two.How can I see summary purchases by individual store/location/unit?Select the Purchase Summary by Customer report.How can I run reports by individual store/location/unit?Select the report you wish to run. Use the Customer Name multi select box to select an individual customer or group of customers.How can I select time periods for reports?For Product Usage Reports, use the Month multi selection box:Can I run reports by start date and end date up to and including yesterday?Currently you can only run by month for Product Usage. Select by date is schedule for later this year. You can pull Invoice History by calendar date OR you can pull Detail Data Download with information through prior day for the current month and all closed months.How can I pull a report by multiple item codes or product descriptions?Business Analytics support cutting and pasting of selected data elements. To run a report by multiple product numbers, click on the Product Number multi select box and click on the “Edit” button.A box will appear that allows you to key or cut and paste product numbers. Key or cut and paste product numbers into the box.-1619254124325Click on “OK” in the edit box…… on the multi select box. …….on the multi select box and….on the main reporting page.How can I pull reports by custom groups?To pull reports by different customer groups, first select all of the customer names you want in the custom group.Run the report for this grouping. Once the report is complete, click on “Page Options”.Click on “Save Current Selections”.Enter a name for the custom report. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download