SECTION 184.108.40.206 - DEBTOR SALES ANALYSIS - BY DATE
USAGE: To analyse the transaction files and print complete breakdown of sales by Debtor by Inventory. Generally this report is run after a period is closed. It can take a long time to run.
DISCUSSION: When you choose this report, HiFinance will firstly ask you in which order you wish to print the Debtors. The screen will appear as follows:
Choose the order you wish to print the report in by pressing the number next to the option. If you choose to print BY OTHER KEYS, another menu will open to allow you to specify which of the three OTHER KEYS you actually require.
The report is similar irrespective of report order, however certain sort orders allow page breaks between keys (eg by GROUP). Also if you intend to limit the report to a range of Debtors, it is more efficient to print the report in that order, because HiFinance can then optimise the search pattern.
When you enter this program, the following questions will appear:
USE LONG FORMAT REPORT If you are using wide stationery, reply Y, otherwise reply N. This question will only be displayed if the relevant option is set to A, see SECTION 7.1.2.
CONSOLIDATE SUB-ACCOUNTS If you have sub-accounts in your Debtors you might wish to consolidate the report so that it gives one total per head-office. If you enter Y here, AAA/001 and AAA/002 would be totalled together under AAA. If you choose N, the individual stores would be shown separately. This is on top of the ability to sub-total by Group, etc. If you do not use the sub-account facility, your answer here is irrelevant.
PRINT SUB-TOTALS ONLY If you enter a Y here, the report will not print any details. Only the totals will be printed.
START A NEW PAGE ON CHANGE OF KEY Certain sort options will sub-total at the end of each group, eg SALESMAN. If you wish HiFinance to insert a page break at the end of each group, reply Y. Otherwise the report will flow on continuously after printing the sub-total. This option is suppressed if you choose to print sub-totals only.
TRANSACTION DATE RANGE Here you enter the lowest and highest dates you wish to include in the report. The computer will search the Inventory transaction-file with in this range of dates.
INCLUDE ALL DEBTORS If you do not wish to set any limits on the report, enter Y otherwise enter N. If you enter N, you will be asked a list of further questions.
CODE RANGE This is the Debtor’s code.
GROUP RANGE This is the Debtor Group.
NAME RANGE This is the first 10 characters of the Debtor’s name.
POSTCODE RANGE This is the postcode. For this to work, you must use the postcode field on the Debtor’s master-file.
OTHER KEY RANGES These may appear as a different literal depending on how you have defined the fields in SYSTEM PARAMETERS.
SALESMAN RANGE This is the salesman code as it appears on the Debtor master-file (not the transaction file).
YTD SALES RANGE This is the total sales for this year and next year, irrespective of the period you are running the report for.
TOTAL BALANCE RANGE This is the total balance, irrespective of the period you are running the report for.
INVENTORY RANGE This is Inventory code range. If you do not wish to run the report for all Inventory, enter the range here.
INVENTORY GROUP RANGE This allows you to limit the report to a range of Inventory Groups.
To start the report, press <Enter> through each field or simply press <F10>.
The report itself will detail the Debtor Group, Debtor Code, Debtor name. Then for each Inventory code purchased by that Debtor, the report will list the total sales in dollars and units for the chosen date range.