Inventory > GL Integration > Inventory Distribution

Inventory Distribution

You use this program to generate a report of ledger entries created for transactions processed that affect Inventory.

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 Inventory GL Integration program and serves as an audit trail of Inventory 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 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 Inventory is integrated to General Ledger in summary (General Ledger Integration) then you should print this report in detail for reconciliation purposes.

Summary

Select this to print only the total values for each ledger code.

A distribution total is 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 Inventory ledger journals to the General Ledger, then you can use this report to assist in balancing Inventory to the General Ledger when discrepancies exist.

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

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

  • The following transactions types may be listed in the Transaction type column of the report:

    REC Receipt
    ADJ Adjustment
    PHY Physical
    CHG Cost Change
    ISS Issue
    MOD Cost Modification
    TRN Transfer
    BFL Backflushing variance between the receipt value and the calculated backflushing value
    VAR Variance caused by average costing calculation, or by transfers using standard costing
    ABC ABC Costing
    TOT Variance arising during processing of a receipt where rounding errors have occurred from entering a cost with a basis of 'total'
    Trn typ is blank but Reference is C.G.S

    This indicates a cost of sales adjustment which occurs when:

    • you are using Average costing
    • stock on hand is allowed to go negative
    • you process the receipt of an item into a warehouse in which the item has a negative quantity on hand

    For example:

    You sell an item you do not have (stock on hand allowed to go negative) that has a cost of 100.

    When you receive stock of the item, the cost of the item is now 120.

    This in effect means that the cost of sales for the item you sold is understated by 20 (i.e. new cost less old cost = 120 -100 = 20). The system allocates this 20 to the Cost of goods sold adjustment account. The reference for this entry on the Inventory Journal Report report is C.G.S.

Notes and warnings

Restrictions and limits

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

Reprinting

  • You can only reprint distribution entries for as long as you are retaining Inventory journals (Inventory Setup).