|
This report shows sales figures for a specified date range. It is almost identical to the Sales Journal in the Reports module. The difference is that this report can show G/L Account information and will also produce a G/L Transaction Summary page at the end.
| o | Blank - it is not recommended that you leave both date fields blank. This may result in a "blank" or inaccurate report. |
| o | To: Date only - this will show you everything from the beginning up to the specified date. |
| o | Both - this will show you results for the specified date range. |
| • | Detail Level - Adjust to control how much information you would like to see on the report. |
| o | Customer totals only - limits the results to a list of each customer, showing their totals. |
| o | Job and customer totals only - each customer will have their own section, listing each job and their totals. |
| o | Line items without unit pricing - each customer will have their own section, listing each job and their line items. Only the extended pricing will be show for each line item (no quantities or unit pricing). |
| o | Full Detail - each customer will have their own section, listing each job and their line items. Quantities and unit pricing will be shown, as well as the extended pricing for each line item. |
| o | Sales Rep - limits the results to a single Sales Rep. |
| o | Customer - limits the results to a single Customer. |
| o | Master Customer - limits the results to a single Master Customer. |
| o | Group by sales rep - each sales rep will have their own pages within the report, and the last page will show a summary of all sales reps with their totals. |
| o | Hide cost and margin - When flagged, only price information is shown. |
| o | Deduct 'exclude from sale' items - The amount deducted from the sales price is generated by checking the Exclude from Sales option on the Line Item dialog. |
| o | Show G/L account summary - When flagged, the report will include a summary of all affected G/L accounts. |
| ► | The choices below will only be visible if you are set up for both accrual basis and cash basis accounting: |
| ▪ | Accrual Basis - select this if you are using accrual basis accounting. |
| ▪ | Cash Basis - select this if you are using cash basis accounting. |
| ▪ | Customer - the report will sort by your customer code. |
| ▪ | Customer sales descending - report will sort by customer sales going from highest to lowest. |
| o | Export - The ability to export data is a powerful tool provided by the Xebra. Exports from the Xebra Reporting module will be provided in a *.csv (comma delimited, text file) format to be used in third-party spreadsheet and database applications (i.e. Microsoft Excel). |
|