sales - View Invoice Summary

View Invoice Summary

Sales, Shrink, and other automatically-generated invoices provide information at the supplier, store, and item level. However, some businesses prefer to handle invoice reconciliation at a summary level.

Use the Invoice Summary Report to list a line-item summary of each store invoice. The summary is based on the time frame you specify, and allows you to choose between the Invoice Date and the Creation Date. Click for a sample report.

Notes:

This report cannot be displayed online.
The Start Date cannot be more than six months prior to the current date.
A maximum of 31 days can be included in one report.
As long as one or more line items are present, invoices are generated even when the net amount is zero. For example, an item is sold for $1.00 (debit), but another item is returned for $1.00 (credit). Generating a zero invoice ensures that all financial item movement is tracked.

Follow these steps:

A.	Open the screen	From the Item Movement tab: Click View Invoice Summary. If you've saved a prior set up as a query, and wish to use it again, click Expand Stored Queries. It's easy to name and save queries for report set ups you'd like to repeat. The settings pre-populate, allowing you to change dates other information as needed. See Saving and using report queries. ____________________________________________________________
B.	Enter Date and Supplier Criteria	If desired, enter a different Start Date. An invoice summary is based a time period that begins on the Start Date you enter. By default, the Start Date is seven-days prior to today. Enter all dates in the format mm/dd/yyyy or mmddyy. The Start Date cannot be more than six months prior to the current date. Select from the Next Days drop-down list to choose the number of days to include. This sets the time period for the report, based on and forward from the Start Date. For example, 7 days for a Start Date of 1/1/2012 will include 1/1 through 1/7/2012. The default is 7 days. Choose from 1 to 7 or 14, 21, 28, or 31 days. Select to base the report on the Invoice Date or the Creation Date. Invoice Date is the business date on which the scan sales took place. Creation Date is the date the invoice was generated in Park City Group. Select the Supplier from the drop-down list. The stores associated with the supplier display. ____________________________________________________________
C.	Select the Stores	Select the stores to include in the report, up to a maximum of 50. Check the All Stores option, or Select one or more Stores, clicking the > link to move them to the right. If desired, click Expand Store Search Criteria to narrow the list. Store Name - Enter all or part of the store name using asterisks as wild cards. Store State - Select the state. Retailer Store Nbrs - Enter the numbers or copy and paste in the box. Click Find and select the stores. ____________________________________________________________
D.	Run the report	If desired, enter a different Report Name. Select a Format. Comma Separated (CSV) for a report you can open as a spreadsheet. RTF for a ready-to-print table you can open with word-processing software. Select a Delivery Type. Note: If you wish to save your entries, click Expand Stored Queries at the top. Enter a Name for New Query and click Save. See Saving and using report queries for more information. Click Submit. ____________________________________________________________ Note: If a report is over 2MB in size, it normally will not be sent as an e-mail attachment. Instead, you are notified by e-mail that the report is ready to download. Click File Registry from any Park City Group window, Find and select the file, then click Download to transfer it to your computer. ____________________________________________________________

Retrieving your report

Need assistance with your report?

(Top)

Updated 3/20/2012