Reporting Explained: Invoice Records: By Invoice
Business Need: This report will provide users a summarized list of all invoices, and their status’ over a period.
How it Works: This report displays the dollar value, and quantity count for every invoice for the selected period. This report will also display what distributed, and non-distributed expenses have been included on invoices, as well as when the invoice was committed, the status of the invoice, the invoice number, the vendor the invoice was created for, and Billed date if it was added to the invoice.
Generating the Report:
Go to the Standard Reports section in Yellow Dog:
1. Select Standard Reports
2. Select the Purchasing Folder
3. Select the Invoice Records folder
4. Select By Invoice
5. Select date range and filters
Reading the Report
Column breakdown:
1. The top of the report will display the filter options that were selected for the report and will be included if the report is exported or printed.
2. Change Columns, Sorting, and Grouping – will be where users can add or remove columns from the report as well as organize and group data.
3. Store Name – will be the store the invoice was created for
4. Vendor Code – will be the code identifier assigned to the vendor in Yellow Dog
5. Vendor – will be the vendor the Invoice was created for
6. Number – will be the number assigned to the invoice. This can be generated automatically by Yellow Dog or updated by the user to something specific.
7. Status – this will be the status of the invoice at the time report is generated.
8. Committed – will be the date and time the invoice was committed. This column will be blank for Invoices with a status of Open
9. Document Total – will be the total dollar value of the invoice including additional expenses.
10. Quantity – will be the total quantity of the items included on the invoice
11. Billed Date – will be the Billed date added to the invoice. This field is optional on invoices and if this column is blank, a Billed date has not been filled in.
12. Payment Status – will be where Paid status can be seen. If this column is blank this invoice has not been marked as paid.
13. Vendor URL – if a URL has been added to the vendor details it will appear here.
14. Non-Distributed Expenses – if there are additional expenses that have been added to the invoice, but not distributed to any items they will appear here.
15. Distributed Expenses Total - if there are any additional expenses that have been distributed to items they will appear here.
16. Print/Save/Export – will be where users can print their report, export to excel/csv, or save as a template.
Related Articles
Reporting Explained: Inventory Requests: Summary
Business Need: This report will provide users with an overview of all Inventory Requests that have been created over a period, when they were committed, and can be filtered by document status’ How it works: This report displays the commit date and ...Reporting Explained: Purchase Order Summary
Business Need: This report will provide an overview of all purchase orders for an organization summarized by document. How it Works: Users will filter to a specific date range and have the option to include or exclude certain Status’ as needed. The ...Reporting Explained: Inventory Transfers: Summary
Business Need: This report will provide a summary of all transfers for an organization summarized by document How it works: This report will display the issuing and accepting locations, the issued, and accepted quantities, and document status. ...Reporting Explained: Summary By Period
Business Need: A user would like to see a summary of all activity for items between two dates. How it Works: This report will show all movement between two selected dates. This report can filter to as broad as by store, or as granular as by item. ...Reporting Explained Physical Inventory Summarized by Store
Business Need: This report is helpful for users who want to view Physical Inventory data summarized to a single line per location. How it Works: The Physical inventory report Summary by Store will provide information on the Stores total on hand ...
Recent Articles
Feature Overview: Client ID
What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...Feature Overview: Password Recovery
What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...377 Food & Beverage Webinar
Curious about Yellow Dog Inventory version 377? New features, smarter workflows—watch the 377 Webinar now! Want to join the live webinar? We're hosting the 377 Food & Beverage Webinar weekly. Click HERE to sign up.Feature Overview: Retail Price Fields
Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...Yellow Dog/Silverware Integration Overview
This document will provide an overview of the Yellow Dog Silverware Integration Integration Approach This can be setup as a 2Way – Push items and Pull sales or a 1Way – Pull sales Sales – Pulled from the Silverware API Codes – Pulled from the ...