Sales Ledger by Client

Use this option to request a report that gives you a client-by-client look at sales results. The report is available in detail or in summary. You may choose from several options to obtain totals at different levels as defined during database entry. For example, you can request a report which only shows a total by client, division, product, or levels in business units. These levels are based on how your company determined the reporting during installation. Level 1 is always Client. Level 2 could be product or division. Level 3 could be brand or product. The next level is business units, if defined in your profile. You can also obtain a breakdown by requesting subtotals by client group, jobtype group, or business unit.

If you do not request sales register reports with write offs, then writeoffs will not appear on the report. If you INCLUDE writeoffs, then if written off to an expense account, the amount will show up in the cost column; if written off to a revenue account, then the amount will be in the revenue column, and the value will be reversed.  Example: Writing off $100 to an expense account will be a positive $100 in the cost column. Writing off $100 to a revenue account will be a negative $100 in the revenue column. In the case of write offs, there is no Gross or Billing total since no billing occurred.

  1. Select Sales Ledger|Sales Ledger by Client.

Sales Ledger by Client Prompt

  1. Key the Reporting Period From/To date in MMCCYY format.

  2. From the Print Total By drop-down list, select one of the following:

  1. Select the Report Version

  1. Accept the default of Yes to include journal entries that affect revenue; otherwise, select No from the Include Journals drop-down list.

  1. Accept the default of Yes to include write-offs; otherwise, select No from the Include Writeoffs drop-down list. Write-offs are included in the COST column only.

  2. Accept the default of Yes to exclude clients not associated with Cost Accounting; otherwise, select No from the Exclude Non Cost Accounting Clients from the drop-down list.

  3. Key a Client Group, Job Type Group, or Business Unit to collect information pertaining only to those groups.

  4. To further limit information that displays, click any of the applicable buttons and select items from the list.

  5. Click the Next icon next.gif to display the Printing Selections Window. Refer to Printing Selections Screen.