1.1AR Management Detail
The AR Management Report is designed to show an accounts receivable aging report that shows outstanding customer Invoices that are still due to the merchant. In the process of end of month procedures, the AR Management Report should be run after Statements are printed, but before closing the period.
Column Headers
Company ID, Company Name, City, State, Contact Name, Phone, Email, Invoice ID, Date, PO, Terms, Current, 30, 60, and 90.
Running an AR Management Detail Report
1
Select the AR Management Report from the Reports window.
Figure 1-1Screen Shot 2018-03-22 at 10.10.22 AM
2
Set the parameters for the report.
Figure 1-2Screen Shot 2018-03-22 at 10.10.54 AM
A. Dates: Select the date that the report is to be run for.
B. Filters: You can broaden or limit your search by using the Filters
i. Show Negative Amounts: Check this box if you want the report to show negative amounts.
ii. Show Zero Balances: Check this box if you want the report to show zero balances.
C. Show Detail: Check the detail check box to see the invoice broken out on the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-3Screen Shot 2018-03-22 at 10.10.22 AM
4
The report will open in a print preview window.
Figure 1-4Screen Shot 2018-03-22 at 10.10.54 AM
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.2AR Management Summary
Accounts receivable aging report that summarizes outstanding customer invoices that are still due to the merchant.
Running an AR Management Summary Report
1
Select the AR Management Summary Report from the Reports window.
Figure 1-5reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-6Kirsten
4
The report will open in a print preview window.
Figure 1-7ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.3AR Statement
The AR Statement is designed to print statements for customers who have a balance on their account. It will print one statement for every customer with an outstanding balance. In the End of Month Procedures process, Statements should be printed after the Finance Charge has been run.
Column Headers
Date, Document Type, PO #, Terms, Amount, and Total
Running an AR Statement
1
Select AR Statement from the Reports window.
Figure 1-8Screen Shot 2018-03-22 at 10.11.59 AM
2
Set the parameters for the report.
Figure 1-9Screen Shot 2018-03-22 at 10.12.12 AM
A. Date: Select the date that the report is to be run for
B. Ranges: Select how you want the report information listed. For example, select Customer ID to choose a range of customers to display.
C. Filters: You can broaden or limit your search by using the Filters.
i. Print Phone Number: check this box if you want the report to include the phone number.
ii. Print Negative Balances: check this box if you want the report to include customers with a negative balance.
iii. Print PO ID as Reference: check this box if you want the report to include the Purchase Order ID as a reference.
iv. Print Only Past Due: check this box if you want only the past due customers to appear in the report.
3
Once the parameters are set, select the Run Report button.
Figure 1-10Screen Shot 2018-03-22 at 10.12.45 AM
4
The report will open in a print preview screen.
Figure 1-11Screen Shot 2018-03-22 at 10.13.05 AM
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview screen.
1.4AR Transactions
This report is designed for the merchant to have one report that shows all transactions that effect account receivable from invoices, batch payment finance charges, and miscellaneous finance adjustments. It is used to help merchants balance individual customer accounts, as well as the total accounts receivable.
Column Headers
Customer ID, Customer Name, Document Type, Transaction Type, Reference #, Invoice Transaction, and AR Batch Transactions.
Running an AR Transaction Report
1
Select the AR Transaction Report from the Reports window.
Figure 1-12Screen Shot 2018-03-22 at 8.58.44 AM
2
Set the report parameters
Figure 1-13Screen Shot 2018-03-22 at 8.51.23 AM
A. Dates: Select a specific time period by entering a From and To date.
B. Ranges: Select how you want the report information listed. For example, select Customer ID to choose a range of customers to display.
C. Filters: You can broaden or limit your search by using the Filters.
i. Include Invoice: check this box if you want the report to include invoices.
ii. Include AR: check this box if you want the report to include AR.
iii. Include Finance Charges: check this box if you want the report to include finance charges.
D. Grouping: Select fields to specify how you want to group the customers that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
E. Show Detail: If this check box is not checked, the report will show you the customer(s) and the total on his account. If you select the detail check box, it will break out and show the different transactions.
3
Once the parameters are set, select the Run Report button.
Figure 1-14Screen Shot 2018-03-22 at 8.51.52 AM
4
The report will open in a print preview window.
Figure 1-15Screen Shot 2018-03-22 at 8.52.05 AM
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.5Best Customer Report
Running the Best Customer Report
1
Select the Best Customer Report from the Reports window.
Figure 1-16Screen Shot 2016-08-11 at 3.23.30 PM
2
Set the parameters for the report. Begin by entering a date range in the From Date and To Date fields. Then specify one or more of the following filters: a range of Customer ID's, a range of Item SKU's, the number of invoices a customer is attached to, or the dollar amount spent during the time period specified.
Figure 1-17Screen Shot 2016-08-11 at 3.27.30 PM
3
Once you have all the parameters of the report, select the Run button.
Figure 1-18Screen Shot 2016-08-11 at 3.33.12 PM
4
The report results will appear in the window. Click on any of the report column headers to sort the report results.
5
Use the buttons at the bottom of the report window to Run, Print, or Save the report as a file. Customer mailing labels can be printed by selecting Print Labels.
1.6Best Seller
Running the Best Seller Report
1
Select the Best Seller Report from the Reports window.
Figure 1-19reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-20Kirsten
4
The report will open in a print preview window.
Figure 1-21ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.7Dynamic Management
Running the Dynamic Management Report
1
Select the Dynamic Management Report from the Reports window.
Figure 1-22reports menu AR Management
2
Add Columns to the report.
Figure 1-23dynamic management columns
3
Set the parameters for the report.
4
Once you have set all the parameters, select the Run Report button.
Figure 1-24Kirsten
5
The report will open in a print preview window.
Figure 1-25ar management report
6
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.8General Journal
The General Journal shows an invoice by invoice journal for all sales transactions. To import this information into an account program, you will use the General Journal Export.
Column Headers
Invoice ID, Invoice Date, General Ledger Account, Type, Description, Debit, and Credit
Running a General Journal
1
Select the General Journal in the Reports window.
2
Set the report parameters.
A. Dates: Select a specific time period by entering a From and To date.
B. Grouping: Select fields to specify how you want to group the information that is displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
C. Show Detail: Checking this check box will show individual transactions within a document.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.9Gift Card
The Gift Card Report is designed as a tool to help in managing gift cards by showing gift cards issued, balances, and dates of transactions.
Column Headers
Gift Card ID, SKU, Balance, Original Amount, Date Activated, Date Last Used, Activated Invoice ID
Running the Gift Card Report
1
Select the Gift Card Report from the Reports window.
2
Set the report parameters
A. Dates: Select a specific time period by entering a From and To date. You can set dates for the date last used, and/or the date activated.
B. Ranges: Enter the desired gift card ID and Balance.
C. Filters: You can broaden or limit your search by using the Filters.
i. Transaction Detail: check this box if you want the report to display transaction detail.
D. Grouping: Select fields to specify how you want to group the gift cards that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.10Held Items
Running the Held Items Report
1
Select the Held Items Report from the Reports window.
Figure 1-26reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-27Kirsten
4
The report will open in a print preview window.
Figure 1-28ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.11Invoice Management
Running the Invoice Management Report
1
Select the Invoice Management Report from the Reports window.
Figure 1-29reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-30Kirsten
4
The report will open in a print preview window.
Figure 1-31ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.12Market Analysis
The Market Analysis Report allows the merchant to view the responses to the Market Analysis survey questions. To learn more about using Market Analysis see Market Analysis
Running the Market Analysis Report
1
Set the report parameters
Figure 1-32Screen Shot 2014-01-02 at 1.54.56 PM
Dates: Set the From and To date range
Ranges: Set a range to filter. For example you could filer by Response 1 to only see specific Responses.
Filters: This is used to specify the Invoice Transaction types to include in the report.
Grouping: This helps to organize the report into groups of data.
Show Detail: If this is checked the report will show the grouped data as well as the individual lines that are in the group. If this box is not checked the report will just show the group totals.
2
Once the parameters are set, select the Run Report button.
3
The report will open in a print preview window.
Figure 1-33Screen Shot 2014-01-02 at 2.00.16 PM
4
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.13No Seller
Show inventory that has not sold within a specified time period.
Running the No Seller Report
1
Select the No Seller Report from the Reports window.
Figure 1-34reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-35Kirsten
4
The report will open in a print preview window.
Figure 1-36ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.14On Hand
The On Hand Report allows the merchant to manage the quantity and value of his inventory. This report will show information for the items that you currently have on hand.
Column Headers
Item SKU, Description, Vendor ID, Vendor SKU, Quantity On Hand, Average Cost per Unit, Extended Cost, Our Retail, Extended Retail, Department.
Running the On Hand Report
1
Select the On Hand Report from the Reports window.
2
Set the report parameters.
A. Date: Set the date that you want the report to run as of.
B. Ranges: Select how you want the report information listed. For example, select Department to choose a range of departments to display.
C. Filters: You can broaden or limit your search by using the Filters.
i. Exclude Zero Quantities: check this box if you do not want the report to show zero quantities.
ii. Exclude Negative Quantities: check this box if you do not want the report to show negative quantities.
iii. Include Discontinued Items: check this box if you want the report to display discontinued items.
D. Grouping: Select fields to specify how you want to group the departments that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
E. Show Detail: Checking the Detail check box will add more information about the item such as the description, vendor ID, etc.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.15On Order
The On Order Report allows the merchant to manage all individual items that have been ordered, but not yet received.
Column Headers
SKU, Description, Vendor ID, Vendor SKU, Original Ordered Quantity, Remaining Order Quantity, Vendor Cost, Extended Cost, PO #, Ship Date, Department, and Cancel Date.
Running an On Order Report
1
Select the On Order Report from the Reports window.
2
Set the report parameters
A. Ranges: Select how you want the report information listed. For example, select Item SKU to choose a range of items to display.
B. Grouping: Select fields to specify how you want to group the items that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
C. Show Detail: Selecting the detail check box will add more information about the item such as the description, vendor ID, etc.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.16PO Management
The purpose of the PO Management Report is to help the merchant manage outstanding purchase orders by showing all outstanding purchase orders.
Column Headers
Vendor Name, PO #, Ordered Date, Shipped Date, Cancel Date, Ordered Cost, Received Cost, Remaining Cost, and Type.
Running the PO Management Report
1
Select the PO Management Report from the Report window.
2
Set the report parameters.
A. Dates: Select a specific time period by entering a From and To date.
B. Ranges: Select how you want the report information listed. For example, select Vendor SKU to choose a range of vendors to display.
C. Filters: You can broaden or limit your search by using the Filters.
i. Show all Purchase Orders: check this box if you want the report to show all purchase orders.
D. Grouping: Select fields to specify how you want to group the information that is displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.17Purchasing Journal
The Purchasing Journal shows all Closed Receiving Logs within a period of time. To import this information into an accounting program, you will use the Purchasing Journal Export.
Column Headers
Receiving Log ID, Purchase Order ID, Vendor ID, Name, Vendor Invoice, Vendor Invoice Date, GL Account, and Amount.
Running the Purchasing Journal
1
Select the Purchasing Journal from the Reports window.
2
Set the report parameters
A. Dates: Select a specific time period by entering a From and To date.
B. Grouping: Select fields to specify how you want to group the information that is displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
C. Show Detail: Checking this check box will show individual transactions within a document.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.18Reorder
The Reorder Report is designed to help the merchant determine what items need to be purchased. It is specifically for commodity items using max stock and reorder point.
Column Headers
SKU, Description, Vendor ID, Vendor SKU, Currently Available, On Order Quantity, Special Order Quantity, Reorder Point, Max Stock, Reorder Quantity, Vendor Cost, and Extended Cost.
Running the Reorder Report
1
Select the Reorder Report from the Reports window
2
Set the report parameters
A. Ranges: Select how you want the report information listed. For example, select Item SKU to choose a range of items to display.
B. Grouping: Select fields to specify how you want to group the items that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
Calculations
Calculating the Reorder Quantity: When the Available Quantity is less than the Reorder Point, then take the Available minus the Max Stock to equal the Reorder Point.
Calculating the Virtual On Hand: Take the Available Quantity plus the On Order Quantity less the Special Order Quantity.
Calculating the Reorder Point: Max Stock minus Virtual On Hand.
1.19Restocking
The Restocking Report is designed to assist the merchant in keeping the shelves stocked by replacing items that have been sold. This report shows the items sold since the date and time displayed in the "Dates" portion of the report definition. This date and time is the last time the report was run. The report shows: Sku, Description, Vendor ID, Vendor SKU, Style, Row, Column, Current Price, Qty Sold and Available. The stock clerk would run the report to see what items have been sold since the shelves were restocked last time. The report also helps in seeing if the item is on hand, and the price at which it should be tagged.
Running the Restocking Report
1
Select the Restocking Report from the Reports window.
Figure 1-37reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-38Kirsten
4
The report will open in a print preview window.
Figure 1-39ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.20Return on Investment
Shows return on investment totals with comparative period.
Running the Return on Investment Report
1
Select the Return on Investment Report from the Reports window.
Figure 1-40reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-41Kirsten
4
The report will open in a print preview window.
Figure 1-42ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.21Reward Point Customer History
Running the Reward Point Customer History Report
1
Select the Reward Point Customer History Report from the Reports window.
1.22Reward Point Item History
Running the Reward Point Item History Report
1
Select the Reward Point Item History Report from the Reports window.
Figure 1-43reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-44Kirsten
4
The report will open in a print preview window.
Figure 1-45ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.23RMSA
RMSA is a third party company that provides reporting software and consulting to forecast what inventory to purchase to maintain a profitable flow. You can learn more about RMSA from their website: http://www.rmsa.com
This report will be used to export data from EVO to the RMSA system.
1
Double click the RMSA report.
Figure 1-46Screen Shot 2015-04-17 at 12.10.54 PM
2
Enter the report date range and other filter data.
Figure 1-47Screen Shot 2015-04-17 at 12.30.48 PM
3
Click Export to File. This will create a file which is specially formatted to be used by the RMSA software.
Here is a list of the RMSA Transaction Types:
Trans | Notes |
|---|---|
SAL | Sales |
INV | Beginning of Month inventory for the current reporting month* |
CIN | Current Inventory |
EOM | End of Month inventory for the current reporting month* |
MKD | Markdowns |
AMK | Additional Markups |
CBR | Chargebacks at retail (Vendor Returns) |
TFR | Net transfers*** |
RCR | Receiving at retail |
RCC | Receiving at cost |
R01 | On Order at retail, future month 01** |
R02 | On Order at retail, future month 02** |
R03 | On Order at retail, future month 03** |
R04 | On Order at retail, future month 04** |
R05 | On Order at retail, future month 05** |
R06 | On Order at retail, future month 06** |
R07 | On Order at retail, future month 07** |
R08 | On Order at retail, future month 08** |
R09 | On Order at retail, future month 09** |
R10 | On Order at retail, future month 10** |
R11 | On Order at retail, future month 11** |
R12 | On Order at retail, future month 12** |
C01 | On Order at cost, future month 01** |
C02 | On Order at cost, future month 02** |
C03 | On Order at cost, future month 03** |
C04 | On Order at cost, future month 04** |
C05 | On Order at cost, future month 05** |
C06 | On Order at cost, future month 06** |
C07 | On Order at cost, future month 07** |
C08 | On Order at cost, future month 08** |
C09 | On Order at cost, future month 09** |
C10 | On Order at cost, future month 10** |
C11 | On Order at cost, future month 11** |
C12 | On Order at cost, future month 12** |
** On Order is reported starting with the month following the last full month. That is, if the current reporting month is April, the R01 & C01 figures should report May On Order values at retail and cost respectively. The x02, x03, ... figures represent next 12 months (June, July, ... in this example).
***A negative number is a transfer out and a positive number is a transfer in.
1.24Sales Commission
Running the Sales Commission Report
1
Select the Sales Commission Report from the Reports window.
Figure 1-48reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-49Kirsten
4
The report will open in a print preview window.
Figure 1-50ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.25Sales Person Performance
The Salesperson Performance Report is designed to assist the merchant in analyzing the performance of each individual salesperson as well as the whole store.
Column Header
Salesperson, Sales, % of Store, Margin %, Average Invoice, Average Item Sale, Average Items per Sale, And Items per Sale
Running the Salesperson Performance Report
1
Select the Salesperson Performance Report from the Reports window.
2
Set the report parameters
A. Dates: Select a specific time period by entering a From and To date.
B. Ranges: Select how you want the report information to be listed. You can select a range of salespersons, as well as filter on a specific field.
C. Grouping: Select fields to specify how you want to group the information being reported.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
D. Show Detail: Checking the detail check box reveals more information about the salesperson and his sales.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.26Sales Report
The Sales Report is designed to assist the merchant in understanding the items sold, sales value, and margins. Sales can also be represented by transaction types, departments, and categories.
Column Headers
SKU, Description, Quantity, Sales, Cost, Margin $, Margin %, and Sales % of Total
Running a Sales Report
1
Select the Sales Report from the Reports Window
2
Set the report parameters
A. Dates: Select a specific time period by entering a From and To Date.
B. Ranges: Select how you want the report information listed. For example, select Department to choose a range of departments to display.
C. Filters: You can broaden or limit your search by using the Filters.
i. Sales Transactions: check this box if you want the report to show sales transactions.
ii. Return Transactions: check this box if you want the report to show return transactions.
iii. Admission Transactions: check this box if you want the report to show admission transactions.
iv. Labor Transactions: check this box if you want the report to show labor transactions.
v. Misc. Transactions: check this box if you want the report to show miscellaneous transactions.
vi. Pymt/Account Transactions: check this box if you want the report to show payment on account transactions
vii. Spec. Ord. Transactions: check this box if you want the report to show special order transactions.
viii. Drop Ship Transactions: check this box if you want the report to show drop ship transactions.
ix. Layaway Transactions: check this box if you want the report to show layaway transactions.
x. Rental Transactions: check this box if you want the report to show rental transactions.
xi. Gift Card Transactions: check this box if you want the report to show gift card transactions.
xii. Consolidate SKUs: check this box if you want the report to consolidate the item SKUs.
D. Grouping: Select fields to specify how you want to group the departments that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
E. Show Detail: If this check box is checked, more information will be displayed about the items and other information in the report.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.27Sales Tax
The Sales Tax Report is designed to provide the merchant’s book keeper with the information necessary to fill out the sales tax report. The report is grouped by Sales Tax District and Item Group showing the total invoice. Also displayed are a break out of administrative transactions and exempt reasons. Posim can process certain non-sale transactions by invoice that would normally not be included in invoice totals. These transactions are titled administrative transactions, such as payment on account.
Column Headers
Total Invoice, Administrative Transactions, Pre-Tax Amount, Taxable Amount, and Tax
Running the Sales Tax Report
1
Select the Sales Tax Report from the Report window.
2
Set the report parameters
A. Dates: Select a specific time period by enter a From and To date.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.28Style Report
The Style Report is designed for use by merchants that have style type items and allows them to see, at a glance, the results of sales comparing items within the style and other like styles.
Column Headers
Style, SKU, Row, Column, Description, Quantity Sold, Sales, % by Total, % by Sale, and Available Quantity.
Running the Style Report
1
Select the Style Report from the Report window.
2
Set the report parameters
A. Dates: Select a specific time period by entering a From and To date.
B. Ranges: Select how you want the report information listed. For example, select Item SKU to choose a range of items to display.
C. Filters: You can broaden or limit your search by using the Filters.
i. Sales Transactions: check this box if you want the report to show sales transactions.
ii. Return Transactions: check this box if you want the report to show return transactions.
iii. Admission Transactions: check this box if you want the report to show admission transactions.
iv. Labor Transactions: check this box if you want the report to show labor transactions.
v. Misc. Transactions: check this box if you want the report to show miscellaneous transactions.
vi. Pymt/Account Transactions: check this box if you want the report to show payment on account transactions
vii. Spec. Ord. Transactions: check this box if you want the report to show special order transactions.
viii. Drop Ship Transactions: check this box if you want the report to show drop ship transactions.
ix. Layaway Transactions: check this box if you want the report to show layaway transactions.
x. Rental Transactions: check this box if you want the report to show rental transactions.
xi. Gift Card Transactions: check this box if you want the report to show gift card transactions.
xii. Consolidate SKUs: check this box if you want the report to consolidate the item SKUs.
D. Grouping: Select field to specify how you want to group the items on the report.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
E. Show Detail: If the detail check box is not checked, the report will display the name of each style and the information pertaining to that style. If the detail check box is checked, each style will be broken out to display each style item and the information pertaining to each item, as well as the totals for the entire style.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.29Turn Ratio
The Turn Ration Report is designed to aid the inventory manager in understanding the effectiveness of his value investment in inventory. Inventory turns ratio is defined typically as the number of times the average inventory is sold during a year. The higher the turn ratio number, the more times those same inventory investment dollars are being turned into sales. The report allows the user to define a current period and a comparative period for the same items.
Column Headers
SKU, Description, Vendor ID, Department, Quantity Sold, COGS, Average Inventory Cost, Turn Ratio per. 1, Turn Ratio per. 2.
Calculations
1. Annualize the COGS by dividing the number of days in the period and multiply by 365
2. Divide the annualized number by the average inventory cost.
Running the Turn Ratio Report
1
Select the Turn Ratio Report from the Report window.
2
Set the report preferences
A. Dates: Select two comparative time periods by selecting two sets of From and To dates.
B. Ranges: Select how you want the report information listed. For example, select Item SKU to choose a range of items to display.
C. Filters: Select the Annualize check box if you want that information shown on the report.
D. Grouping: Select field to specify how you want to group the items that are displayed.
NOTE: |
|---|
You can select multiple fields in the grouping box. The first field in the Group Fields is the main grouping field. If others are selected, they will be sub groups. |
E. Show Detail: Check this check box to see more information such as description, vendor SKU, etc.
3
Once the parameters are set, select the Run Report button.
4
The report will open in a print preview window.
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.
1.30Weekly Sales & Status
This report is designed to allow the merchant to manage multiple related styles. It allows the merchant to see information related to sales, on hand status, and receiving since that style was introduce to the store. This report is designed for seasonal items, specifically styles, but will still work for commodity items as well.
Running the Weekly Sales & Status Report
1
Select the Weekly Sales & Status Report from the Reports window.
Figure 1-51reports menu AR Management
2
Set the parameters for the report.
3
Once you have set all the parameters, select the Run Report button.
Figure 1-52Kirsten
4
The report will open in a print preview window.
Figure 1-53ar management report
5
To Print, Save, or Navigate through the report, use the icons at the top of the print preview window.