Work in Progress > GL Integration > WIP Part Billings Distribution

WIP Part Billings Distribution

You use this program to generate a report of General Ledger entries for part billing transactions created within the Part Billings program.

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 ledger journals created by the WIP Part Billings GL Integration program.

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 of part billings transactions posted against each ledger code.

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

SummarySelect this to print only totals for each ledger code, together with distribution totals.
Print additional reference

Select this to print the additional reference, entered in the Part Billings program, on the distribution report.

This only applies when generating a detailed 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 print the report.
Year Indicate the year(s) for which to print 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 print the distribution 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 printed.

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

  • The term *Multiple* in place of a GL code indicates that, in the sub ledger, a single journal was referenced to more than one control record.

  • Only the first Additional reference per Job entry is printed.

  • 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

  • The report cannot be generated if your Work in Progress integration method is defined as Not linked to GL - no distribution report (General Ledger Integration).

Reprinting

  • You can only reprint distribution entries for as long you are retaining part billing journals (Work In Progress Setup).

    In SYSPRO 6.1 the Journal and Distribution entries tables/files were combined and the Distribution entries tables/files was removed. Therefore, the number of months you select to retain the journals also determines the number of months for which the distribution entries prior to SYSPRO 6.1 are retained.

  • Only the current period can be reprinted when the Work in Progress module is not integrated to General Ledger in Detail or Summary (General Ledger Integration).