AR Sales Distribution

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.

This report is generated from the General Ledger journals created by the AR Invoice GL Integration program.

The AR Sales Distribution report serves as an audit trail of Accounts Receivable sales transactions processed.


	The AR Sales Distribution report cannot be generated if your Accounts Receivable integration method is defined as Not linked to G/L - no distribution report (General Ledger Integration).

If you have posted all your Accounts Receivable ledger journals to the General Ledger, then you can use this report together with the AR Payments Distribution report as an audit trail of entries posted to the General Ledger and possibly to assist in balancing Accounts Receivable to the General Ledger when discrepancies exist.

This 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 you want to generate.

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.

If Accounts Receivable is integrated to the General Ledger in Summary, (General Ledger Integration - General Ledger tab), then you should print this report in detail for reconciliation purposes.

Summary

Select 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.

Reprint

Select this to reprint AR Sales Distribution reports previously printed.

When you select this option, you can define a range of selection criteria according to which you want to reprint the report.


	The number of periods for which you can reprint distribution entries depends on the number of periods for which you are retaining Sales transaction summary records and Sales transaction detail records (Accounts Receivable Setup - History tab).

Entry selection

GL journal

Select this to reprint the report for a specific range of General Ledger journal numbers.

Entries group

Select this to reprint the report for a specific range of distribution entry groups.

This only applies if you want to reprint ledger distribution entries created prior to SYSPRO 6.1.

Prior to SYSPRO 6.1, a new entries group was created in the General Ledger entries file/table for each distribution report printed.

This option enables you to reprint these entries groups.

Current GL period

This is displayed for information purposes only and cannot be changed.

Period

This indicates the period that your General Ledger module is currently in.

Year

This displays the year that your General Ledger module is currently in.

Selection criteria

Field	Description
Ledger period selection	You can reprint sales distribution entries for as long you are retaining Sales transaction summary records and Sales transaction detail records (Accounts Receivable Setup - History tab). Period Indicate the period(s), within the year(s) indicated, for which you want to reprint the report. Year Indicate the year(s) for which you want to reprint the report.
GL journal selection	Indicate the ledger journal number(s) you want to reprint. This selection is only enabled when your Entry selection is by GL journal.
Ledger entries group selection	Indicate the entry group(s), within the selected periods and years, for which you want to reprint the distribution report. This selection is only enabled when your Entry selection is by Entries group.
Ledger code selection	Indicate the General Ledger codes for which you want to reprint the report. Only those 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

The distribution report reflects details of the sub-module transactions posted to the GL Journal and are grouped by the GL journal number.

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).

The register number is not printed for the warehouse control when Accounts Receivable is linked to the General Ledger in Summary (General Ledger Integration). Similarly, if Accounts Receivable was linked to the General Ledger in Summary when the GL journal was created and the integration was changed to Detail, the word * Multiple * is still printed on the report for those journals.