Accounts Receivable > GL Integration > AR Sales Distribution

AR Sales Distribution

You use this program to generate a report of General Ledger entries for sales transactions created within the AR Invoice Posting, AR Initial Invoice Capture, AR Finance Charge Calculation, Sales Order Entry, Document Print and AR Post Permanent Entries programs.

The report reflects details of the sub-module transactions posted to the GL Journal, grouped by the GL journal number. It is generated from the General Ledger journals created by the AR Invoice GL Integration program and serves as an audit trail of Accounts Receivable sales transactions processed.

The report can be run at any time and as often as required.

Report Options

Field Description
Report options  
Report type Indicate the type of report to generate.
OptionDescription
Detail

Select this to print a list (in ledger code sequence) of all sales transactions posted against each ledger code.

Totals are printed for each ledger code with a distribution total printed at the end of the report.

You should generate this report in detail for reconciliation purposes, if Accounts Receivable is integrated to the General Ledger in Summary, (General Ledger Integration).

SummarySelect this to print only totals for each ledger code for all selected entries in a period.

Distribution totals are printed at the end of the report.

Entry selection  
Entry selection by: Indicate whether to generate the report for a specific set of journals or a set of distribution entries.
OptionDescription
GL journalSelect this to generate the report for a specific range of General Ledger journal numbers.
Entries groupSelect this to generate the report for a specific range of distribution entry groups.

This only applies to ledger distribution entries created prior to SYSPRO 6.1, in which a new entries group was created in the General Ledger entries file/table for each distribution report printed. This option enables you to print these entries groups.

Current GL period This indicates the period and year that your General Ledger module is currently in. It is displayed for information purposes only and cannot be changed.

Selection criteria

Selection Description

Ledger period

Option Description
Period Indicate the period(s), within the year(s) indicated, for which to generate the report.
Year Indicate the year(s) for which to generate the report.

GL journal

Indicate the ledger journal number(s) to print.

This selection is only enabled when your Entry selection is by Journal.

Ledger entries group Indicate the entry group(s), within the selected periods and years, for which to generate the report.

This selection is only enabled when your Entry selection is by Entries group.

Ledger code

Indicate the General Ledger codes for which the report must be generated.

Only the distribution entries for the General Ledger code(s) you select are printed.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

  • If you posted all your Accounts Receivable ledger journals to the General Ledger, then you can use this report together with the AR Payments Distribution report to assist in balancing Accounts Receivable to the General Ledger when discrepancies exist.

  • The report is generated by General Ledger code, not by journal number, so when you select to include all journals, the individual journal numbers are not displayed.

    The journal number is only displayed in the headings when the report is generated for a single journal number as the journal number can then be identified.

  • The word *Multiple* is printed in place of the GL code where there is more than one warehouse per invoice or if Accounts Receivable is not linked to the General Ledger (General Ledger Integration).

    If Accounts Receivable was linked to the General Ledger in Summary when the GL journal was created, but was later changed to Detail, then the word *Multiple* will still be printed on the report for those journals.

  • The register number is not printed for the warehouse control when Accounts Receivable is linked to the General Ledger in Summary (General Ledger Integration).

  • An _TAX product class entry may be displayed as a tax rounding line at the end of the report.

    The rounding amount comes from the Document Print program when tax rounding occurs on an invoice with an inclusive tax code (Tax Code Setup) and Sales tax calculation is set to Invoice level (Company Tax Options Setup). This does not apply if your nationality code is CAN (Canada).

  • All journals/entries (whether previously printed or not) are included in the report according to the report options indicated. The Reprint column on the report indicates whether the journal/entry was previously printed.

Notes and warnings

Restrictions and limits

  • This report cannot be generated if your Accounts Receivable integration method is set to Not linked to G/L - no distribution report (General Ledger Integration).

Reprinting

  • You can only reprint sales distribution entries for as long as you are retaining sales transaction summary records and sales transaction detail records (Accounts Receivable Setup).