|
REPORTING MANUAL
Saved Reports
for F&B Operations
Food
& Beverage · Yellow Dog Inventory
Version 377 ·
Updated June 2026
|
We’ve
streamlined reporting for Food & Beverage operations by pre-saving
essential reports. To find them, select Reports
in the left navigation, then Saved Reports.
This manual gives an overview of each saved report, with its purpose, date
range, and frequency, plus a screenshot of the report options, the applied
columns, and the report name and path.
The path (for
example, Troubleshooting \ Advisor)
shows how to run the report from Reports >
Standard Reports. If your Yellow Dog Inventory version predates the
release that includes these pre-saved reports, follow the report path to run
and then save the report.
To run a
report, highlight it and select Execute Saved
Report. Each report has a unique number, a three-character category
code, and a name. Enter a report number in the search bar to find it quickly.
To adjust
parameters before running a report, use the filters on the right side of the
screen. After running a report, select the change,
grouping and sorting link at the top right to open the Report
Columns dialog, where you can change sorting and add or remove columns.
To keep your
changes, select Save Report Template
at the bottom right of the report. You can overwrite the existing report or
save a new one. When saving a new version, reuse the same title and append a
letter to the report number (for example, 202a –
ALR – Check Negative On-Hand). This groups related reports together
and keeps them easy to find.
All the reports
with the abbreviation ALR (Alerts) are the reports to run to check for system
issues. We recommend you run these reports at least once per week to allow time
for investigation and correction.
Purpose: The
report shows actions that should be addressed.
Date Range: Now
Frequency: At
least twice per month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows items with a negative on-hand.
Date Range: Now
Frequency: Check
weekly to uncover recipe or adjustment issues.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
All the reports
with the abbreviation SLS (Sales) are reports to review your sales performance.
Recommended you run these daily and certainly weekly to gauge your operations
performance.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows actions that should be taken to correct a particular issue.
Date Range: Now
Frequency: Day
before each event
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
All the reports
with the abbreviation INV (Inventory) are the reports that detail your
inventory on-hand and movement.
Purpose: The
report shows the on-hand quantity and cost of items.
Date Range: Now.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the on-hand quantity and cost of items summarized by Level I.
Date Range: Now.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the on-hand quantity and cost of items summarized by Level II.
Date Range: Now.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the on-hand quantity and cost of items summarized by Level III.
Date Range: Now.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows transfers committed this month.
Date Range: This
Month.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows transfers committed this month.
Date Range: This
Month.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows transfers committed this month.
Date Range: This
Month.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows transfers committed this month.
Date Range: This
Month.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the summary of inventory movement for the month by Level I.
Date Range: This
Month.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the summary of inventory movement for the month by Store/Stand.
Date Range: This
Month.
Frequency: As
needed for end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows vendor price changes by month.
Date Range: 4
or 6 Months
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows item cost changes by document type.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
All the reports
with the abbreviation PUR (Purchasing) are the reports that show you your PO,
Invoice, Requests, and Return to Vendor activity. Recommended you run these as
necessary.
Purpose: The
report shows the items below their reorder point and PAR.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the items on order.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Open committed Purchase Orders.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Open committed Purchase Orders.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the difference between ordered and invoices items.
Date Range: This
Month.
Frequency: At
month end.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the committed Purchase Orders.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the committed Purchase Orders in summary.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Open committed Purchase Orders.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Open committed Purchase Orders.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Open committed Purchase Orders.
Date Range: Now.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the Invoices by their created date.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the Invoices by the selected statuses (suggest all committed
statuses).
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the Invoices by the selected statuses (suggest all committed
statuses).
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the Invoices grouped by COGS for the selected statuses (suggest
all committed statuses).
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the Invoices for the selected statuses (suggest all committed
statuses) in summary.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows vendor prices on invoices that are different than the bid/contract
vendor price.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows vendor prices on invoices that are different than the previous
invoice.
Date Range: This
Month.
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Open invoices.
Date Range: All
time.
Frequency: Before
month end.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Return to Vendors at the item level.
Date Range: This
Month
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows Return to Vendors at a summary level.
Date Range: This
Month
Frequency: As
needed.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
All the reports
with the abbreviation PHY (Physical) detail your physical variances and
activity.
Purpose: The
report shows inventory items received but have never been on a
physical/counted.
Date Range: Select
the date to start.
Frequency: At
least once per month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows inventory items received but have never been on a
physical/counted.
Date Range: Select
the date to start.
Frequency: At
least once per month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the summary of physical performed last month.
Date Range: Last
month.
Frequency: At
end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.
Purpose: The
report shows the summary of physical performed last month by item.
Date Range: Last
month.
Frequency: At
end of month.
Report options
& path
The applied filters and the report path (run from Reports >
Standard Reports on older versions).
Column
selections, sorting, and grouping
The columns, sorting, and grouping configured for this report.