Inventory GL Distribution

Inventory > GL Integration > Inventory GL Distribution

Inventory GL Distribution

You use the Inventory GL Distribution program to generate a report of General Ledger entries created for transactions processed which affect Inventory.

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


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

If you have posted all your Inventory ledger journals to the General Ledger, then you can use this report as an audit trail of entries posted to the General Ledger and possibly to assist in balancing Inventory 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 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 - General Ledger tab ), 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.

Reprint

Select this to reprint Inventory GL 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 Inventory journals (Inventory Setup - History tab).

Entry selection

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.

Selections

In addition to the report options that can be selected, the following selection criteria can be defined when you select to reprint the report:

Selection	Description
Period	You can reprint Inventory distribution entries for as long you are retaining Inventory journals (Inventory 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	Indicate the ledger journal number(s) you want to reprint. 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 you want to reprint the distribution report. This selection is only enabled when your Entry selection is by Entries group.
Ledger code	Indicate the General Ledger code(s) for which the report must be reprinted. 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 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.

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.