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 time of a request, the need by date if one has been added, the total quantity of the product requested as well as the total vendor price of the items included. This report can be filtered to only display requests with a specific status assigned as well if needed.

Generating the Report:

      1.    Select Standard Reports

      2.    Select the Purchasing Folder

      3.    Select the Inventory Requests Folder

      4.    Select the option for Summary

      5.    Select the appropriate filters for date/time, stores and/or statuses

      6.    Select Generate to run the report

Reading the Report:

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.     Will be where users can identify how a report is sorted and or grouped

3.      Change Columns, Sorting, and Grouping – will be where users can add or remove columns from the report as well as organize and group data.

4.     Store Code – will display the numerical code assigned to the store in Yellow Dog

5.     Store Name – will display the name assigned to the store the Requests were created in.

6.     Document Number – will display the number assigned to the requests included in the report

7.     Committed – will be the date and time the request(s) were committed

8.     Need By – will be the date the product is needed if it was added to the request

9.     Quantity Requested – will be the total quantity of items included in the request

10.  Total Vendor Price – will be the quantity X the vendor price

       11. 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 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: 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: 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: ReOrder

  Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...

• 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

• Yellow Dog/Spot On(Appetize) Integration Overview

  The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...

• Yellow Dog/InfoGenesis Integration Overview

  The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...

• Yellow Dog/Shopify Integration Overview

  This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...

• Yellow Dog/Simpony2 w/Oracle Integration Overview

  This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...

• Yellow Dog/NCR Silver Integration Overview

  This document will provide an overview of the Yellow Dog/NCR Silver integration Integration Overview The Yellow Dog/NCR Silver integration is a 2Way integration Sales – Pulled from the NCR API Codes For reporting codes are pulled from the NCR API For ...