Difference between revisions of "How do I create a customer turnover report?"
From Catalyst
m (Les Ward moved page How do I Create a Customer Turnover Report? to How do I create a customer turnover report?: Lower case (except for Platinum menu options)) |
|||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
== Summary == | == Summary == | ||
| − | If you are keen to start creating your own reports this article guides you through creating a very simple Customer Turnover report. | + | If you are keen to start creating your own reports, this article guides you through creating a very simple Customer Turnover report. |
== More Information == | == More Information == | ||
| Line 16: | Line 14: | ||
=== Sort Order === | === Sort Order === | ||
| − | + | See [[How do I Create a Report Sort Order?|this article]] for more information on creating the sort order. | |
| − | * | + | |
| − | * | + | Enter these variables: |
| + | * {{DataValue|A01}} - Ledger Code. | ||
| + | * {{DataValue|A09}} - Account Turnover. | ||
** Move across to {{DataPrompt|Width}}. Amend the value shown to be {{DataValue|-8.2}}. | ** Move across to {{DataPrompt|Width}}. Amend the value shown to be {{DataValue|-8.2}}. | ||
| − | ** Amend the {{DataPrompt|Dir}} to {{DataValue|R}}. This will ensure the report produces information to show the account | + | ** Amend the {{DataPrompt|Dir}} to {{DataValue|R}}. This will ensure the report produces information to show the account with the highest turnover value at the top of the report. |
| − | * | + | *{{DataValue|A02}} - Account Code. |
| − | |||
Press {{KeyPress|Esc}} to return the report menu. | Press {{KeyPress|Esc}} to return the report menu. | ||
=== Range Filter (1) === | === Range Filter (1) === | ||
| − | * | + | See [[How do I enter a report range?|this article]] for more information on creating the ranges. |
| − | + | ||
| + | * Enter {{DataValue|A01}}- Ledger Code. | ||
** Press {{KeyPress|Enter}} twice to move across to the {{DataPrompt|Limit/Comparison}} column. | ** Press {{KeyPress|Enter}} twice to move across to the {{DataPrompt|Limit/Comparison}} column. | ||
** Enter {{DataValue|S}} to specify Sales Accounts only. | ** Enter {{DataValue|S}} to specify Sales Accounts only. | ||
| Line 34: | Line 34: | ||
* Enter {{DataValue|A09}} - Account Turnover. | * Enter {{DataValue|A09}} - Account Turnover. | ||
** Press {{KeyPress|Enter}} to move to the {{DataPrompt|Op}} column. | ** Press {{KeyPress|Enter}} to move to the {{DataPrompt|Op}} column. | ||
| − | ** Enter {{DataValue|>}} | + | ** Enter {{DataValue|>}}. In this case we are using ''Greater Than''. |
** Press {{KeyPress|Enter}} to move across to the {{DataPrompt|Limit/Comparison}} column. | ** Press {{KeyPress|Enter}} to move across to the {{DataPrompt|Limit/Comparison}} column. | ||
** The value should be set at 0.00. The report will only include customers with a turnover balance exceeding zero. | ** The value should be set at 0.00. The report will only include customers with a turnover balance exceeding zero. | ||
| Line 41: | Line 41: | ||
=== Column Details === | === Column Details === | ||
| − | * Press {{KeyPress|F2}} to create column | + | * Press {{KeyPress|F2}} to create the first column. |
| − | * | + | * At {{DataPrompt|File Var.}}, enter {{DataValue|A02}} - Account Code. |
** Press {{KeyPress|Enter}} then {{KeyPress|Esc}} and {{Button|Accept}} the column. | ** Press {{KeyPress|Enter}} then {{KeyPress|Esc}} and {{Button|Accept}} the column. | ||
| − | * Press {{KeyPress|F2}} to create column | + | * Press {{KeyPress|F2}} to create the next column. |
{{Tip|text=The system will automatically enter the position at which the column will be printed. It uses the previous column position plus that column's width plus 1 to allow for a space.}} | {{Tip|text=The system will automatically enter the position at which the column will be printed. It uses the previous column position plus that column's width plus 1 to allow for a space.}} | ||
| − | * | + | * Enter {{DataValue|A03}} - Account Name. |
| − | * | + | * Enter {{DataValue|A09}} - Account Turnover. |
| − | + | ** Move down to the {{DataPrompt|Before}} field. | |
| − | |||
| − | ** | ||
** Set the value to {{DataValue|08}} - this will ensure the total of the report has enough decimal places to display values exceeding 999,999.99 | ** Set the value to {{DataValue|08}} - this will ensure the total of the report has enough decimal places to display values exceeding 999,999.99 | ||
| − | ** | + | ** Use the {{KeyPress|arrow keys}} or {{KeyPress|Tab}} key to move across to the {{DataPrompt|Groups}} section. |
| − | |||
** Under {{DataValue|O}} change {{DataValue|N}} to {{DataValue|T}}. | ** Under {{DataValue|O}} change {{DataValue|N}} to {{DataValue|T}}. | ||
{{Information|text=The system will automatically create a totals section at the bottom of the report. It will contain a formula which will total the turnover column for you.}} | {{Information|text=The system will automatically create a totals section at the bottom of the report. It will contain a formula which will total the turnover column for you.}} | ||
| − | + | * Press {{KeyPress|Enter}} then {{KeyPress|Esc}} and {{Button|Accept}} the column. | |
| − | |||
| − | |||
== Output Options == | == Output Options == | ||
| Line 68: | Line 63: | ||
== Saving the Report == | == Saving the Report == | ||
| − | When you have completed your report click {{Button|Finish Editing}} and click {{Button|Accept}}. | + | When you have completed your report, click {{Button|Finish Editing}} and click {{Button|Accept}}. |
| − | Having created this report you may wish to be brave and amend it to suit your purpose! See [[Modifying a Report Generator System Report]] for instructions on how to copy a report | + | Having created this report you may wish to be brave and amend it to suit your purpose! See [[Modifying a Report Generator System Report]] for instructions on how to copy a report. |
== See also == | == See also == | ||
* [[Getting started - Report Generator]] | * [[Getting started - Report Generator]] | ||
| + | * [[How do I Create a Report Sort Order?]] | ||
| + | * [[How do I enter a report range?]] | ||
{{KB_Tags|report, reports, generate, generator, figures, report generator, custom reports, custom, customer turnover}} | {{KB_Tags|report, reports, generate, generator, figures, report generator, custom reports, custom, customer turnover}} | ||
{{FAQ}}{{KB_RGen}}{{Guide}} | {{FAQ}}{{KB_RGen}}{{Guide}} | ||
Revision as of 10:41, 17 December 2018
Contents
Summary
If you are keen to start creating your own reports, this article guides you through creating a very simple Customer Turnover report.
More Information
The Report Generator in Platinum is a very useful and powerful tool. Please Contact your Platinum dealer or our sales team on 0116 230 1500 or by using our website sales contact page who will be pleased to advise you on upcoming training course dates and availability.
Creating a Report
These instructions will guide you through creating a simple Customer Turnover list.
Go to " Sales Ledger Sales Reports Accounts Report Generator".
- Add a new report.
Follow the sections below in order:
Sort Order
See this article for more information on creating the sort order.
Enter these variables:
- 'A01' - Ledger Code.
- 'A09' - Account Turnover.
- Move across to "Width". Amend the value shown to be '-8.2'.
- Amend the "Dir" to 'R'. This will ensure the report produces information to show the account with the highest turnover value at the top of the report.
- 'A02' - Account Code.
Press <Esc> to return the report menu.
Range Filter (1)
See this article for more information on creating the ranges.
- Enter 'A01'- Ledger Code.
- Press <Enter> twice to move across to the "Limit/Comparison" column.
- Enter 'S' to specify Sales Accounts only.
- Press <Enter> to move through the remaining columns until you are on the next row.
- Enter 'A09' - Account Turnover.
- Press <Enter> to move to the "Op" column.
- Enter '>'. In this case we are using Greater Than.
- Press <Enter> to move across to the "Limit/Comparison" column.
- The value should be set at 0.00. The report will only include customers with a turnover balance exceeding zero.
Press <Esc> to return the report menu.
Column Details
- Press <F2> to create the first column.
- At "File Var.", enter 'A02' - Account Code.
- Press <Enter> then <Esc> and [Accept] the column.
- Press <F2> to create the next column.
 | The system will automatically enter the position at which the column will be printed. It uses the previous column position plus that column's width plus 1 to allow for a space. |
- Enter 'A03' - Account Name.
- Enter 'A09' - Account Turnover.
- Move down to the "Before" field.
- Set the value to '08' - this will ensure the total of the report has enough decimal places to display values exceeding 999,999.99
- Use the <arrow keys> or <Tab> key to move across to the "Groups" section.
- Under 'O' change 'N' to 'T'.
 | The system will automatically create a totals section at the bottom of the report. It will contain a formula which will total the turnover column for you. |
- Press <Enter> then <Esc> and [Accept] the column.
Output Options
Specify how you wish to Output the report.
Saving the Report
When you have completed your report, click [Finish Editing] and click [Accept].
Having created this report you may wish to be brave and amend it to suit your purpose! See Modifying a Report Generator System Report for instructions on how to copy a report.
See also
- Getting started - Report Generator
- How do I Create a Report Sort Order?
- How do I enter a report range?
