The Sales and Purchase Account records all contain a
rolling history of turnover for (usually) 12 periods. This new report allow output of this detail
to an Excel spreadsheet together with average values for the last 3, 6, 9 and
12 periods so that you can monitor for any increase or decrease in turnover
over time.
Selecting the report presents a list of parameters to control the turnover details output.
Date of Report / Report As At Date – usually defaulting to today’s date you may wish to change the ‘As At’ date to an earlier point in time if transaction entry is not fully up-to-date.
Range of Account Codes From / To – optionally enter a range of accounts to be output, <F4-Select> is available if required.Leave blank to output all accounts.
Specify Any Selection Criteria – optionally set any criteria to restrict output of the turnover history to selected accounts.
Include Current Period – the turnover history option is based on the saved turnover values for the account, setting this option includes the current period turnover within the report and drops off the oldest of the saved turnover periods. For example if 12 periods in the accounting calendar and you are in period 3 then set whether when reporting period 3 you use this year’s figure or last year’s figure.
No of History Periods – on first use this defaults to the number of periods in the current accounting calendar, though can be amended if required, and controls if outputting the individual period turnover values for last X periods.
Include 3/6/9/12 Period Average – these four parameters ask whether you wish the Excel output to include averages for the last 3, 6, 9 and 12 periods. If including current period then the average of the last 3 periods is this period and the 2 previous periods, average for last 6 period is this period and the previous 5 periods, and so on. If using an alternate number of periods in the accounting calendar then these options may vary – the system will omit average options if they exceed the number of periods in the year and the 12-period average will be an average based on however many accounting periods there are.
Include Year Turnover – set whether to include a total of the turnover for the year. Again if including current period then this turnover is a total of the current period and the previous 11 (assuming 12 accounting periods) periods.
Once the output parameters are set you can select the
PRINT option to output the turnover history to Excel. Note that as no ‘physical’ print can be
created for this report (too much detail to be legible on typical A4-page) then
this option is not applicable if Excel is not in use.
Installation
Menu Design
The Turnover History reporting option needs to be
added as required to the Sales / Purchase Ledger reports menu. To add a new menu option sign-on as the CONFIG user and select Application Menu Design, choose the
menu to update (the main Sales Ledger reports menu is SLREP.D03, with PLREP.D03
for the Purchase Ledger) and then select to update either the left or
right-hand menu. Move down to a blank
menu entry and enter the title required then press <Enter> to enter the
menu parameters.
Applic, Program or Notes P-Program
Menu Name or Program Path SL.EXE / PL.EXE
Parameter 3009
NB: Other options can be set as required.
Article ID: 133
Created On: Mon, Jun 11, 2012 at 1:46 PM
Last Updated On: Mon, Jun 19, 2023 at 4:26 PM
Online URL: https://kb.datafile.co.uk/article/turnover-history-report-133.html