IM20S1 Inventory Management I/M Distribution to G/L Report

IM20S1 Inventory Management I/M Distribution to G/L Report

I/M Distribution TO G/L Report

Application Overview

 Records are created in the I/M Distribution To G/L File whenever transactions are posted by the following applications:  I/M's Post Inventory Transactions, P/O's Post Receivings Transactions, COP's Post Invoices To A/R, and BOMP's Post Production Transactions.  The I/M Distribution To G/L Report prints the information from this file to verify exactly which accounts were updated and the amounts that were posted to them.

 

Sections Of The Report

 The Cost Of Goods Sold section of the report shows every change to the company's cost of goods sold account.  This section will only print if the Post Cost Of Goods Sold ? flag in COP Setup is set to Y.

 The Inventory section of the report shows every change to the company's inventory asset account(s).

 The Work In Process section of the report shows changes made to the company's work in process account.  This account number is defined in I/M Setup.

 The Purchases Adjustments section of the report shows changes made to the company's receivings account(s).

 

Detail Or Summary Formats

 You can print the I/M Distribution To G/L Report in either a detailed or a summary format.  If you print the report in detailed format, all distributions, which have occurred during the period you select, will be printed, with detail concerning the source of the transaction, such as the item number, document number and type of transaction which generated the posting.

 If you select the summary format, all postings to G/L for the same date for an account will be summarized and printed on one line of the report.

 

Purging The File

 Once you have printed the I/M Distribution To G/L Report and you are satisfied that it is accurate, you can then purge the I/M Distribution File of the transactions, which appeared on the report.  Purging the file periodically will prevent it from growing extremely large.

 If you are using Elliott's General Ledger package, however, and if you plan to transfer these I/M postings to G/L, do not purge the I/M Distribution File.  If you do, you will not be able to transfer the postings to G/L.

 

Run Instructions

 Select I/M Distribution To G/L Report from the pull down I/M Reports window.   The following screen will then be displayed:

 


 

I/M Distribution to G/L Report Entry Screen


The following options are available:

    • Print or display to screen, the general ledger distributions for a given date range in detail or summary
    • Purge the distribution file only after interfacing to G/L

     To return to the menu bar, press the ESC or F10 key.  To leave this application, press X for EXIT when positioned at the menu bar.


    Entry Field Descriptions

     

    Name

    Type and Description

    1.  Print Report ?

    Y or N.

    If you answer Y the report will be generated, otherwise it will not.

    Default is Y.

    2.  Purge File ?

    Y or N.  

    Do not purge if you wish to interface with the General Ledger package.

    Default is N.

    3.  Period Starting Date

    A date in the standard date format.

    Enter the beginning date of the period for which you want to print the report.

    Default to EARLIEST.

    4.  Period Ending Date

    A date in the standard date format.

    Enter the ending date of the period for which you want to print the report.

    Defaults to the starting date.  If starting date is EARLIEST, defaults to today's date.

    5.  Detail Or Summary ?

    1 alphabetic character.

    Enter D if you want the report to show the full detail of every transaction which generated a posting to G/L.  If you answer S, every transaction which occurred on a single date for an account will be summarized and will print on one line.

    Defaults to D.

     


     

    I/M Distribution To G/L Report In Detail

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     




      • Related Articles

      • ARDISSCN Accounts Receivable A/R Distribution to G/L Report

        A/R Distribution to G/L Report Application Overview Whenever Sales, Cash Receipts, or Finance Charge transactions are posted to the A/R files, postings are also made to the A/R Distribution to G/L file. These are records of the postings to be made to ...

      • Feature - Added Distribution to G/L History Files

        Release date: 4/25/2017 History versions of the Distribution to G/L files have been introduced to Accounts Payable (APDISFIH), Accounts Receivable (ARDISFIH), BOMP (BMDISFIH), Inventory Management (IMDISFIH), and Payroll (PRDISFIH). When printing the ...

      • PRDSTSCN Payroll PR Distribution to G/L Report

        PR Distribution To G/L Report Application Overview The PR Distribution to G/L application produces a report of the General Ledger entries generated by the Payroll package during a specified period and optionally purges the Distribution file for the ...

      • GLACTMNU General Ledger G/L Account File

        G/L Account File Application Overview The G/L Account File is used to set up and maintain, as well as print out a list of all or a subset of all accounts on file. The Account number entered for each record can be divided into three related components ...

      • BMDISCN Bill of Material B/M Distribution Report

        B/M Distribution Report Application Overview Prior to Elliott 7.5, distribution were created in the I/M Distribution To G/L File when BOMP production transactions were posted. Elliott 7.5 adds B/M Distribution To G/L File for all Legacy, Material and ...