Turnover History Report

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.