![]() |
Interface From Other PackagesApplication Overview
Interface From Other Packages allows the distribution files of Accounts Receivable, Accounts Payable, Payroll, Job Costing, Inventory Management, and Assets and Depreciation to be transferred into the General Journal Transaction File.
The General Ledger interface was designed to be a quick and simple means of transferring distributions from Accounts Receivable (AR), Accounts Payable (AP), Payroll (PR), Job Costing (JC), Inventory Management (IM), and Assets and Depreciation (AD) to General Ledger. Only minimal data validation occurs during the interface, so careful preparation is required.
Prior to running this program you should have run the Distribution Report in detail for the appropriate package, making sure that all transactions are accurately represented. The program does not require that you provide a valid period starting or ending date for the cutoff date, but we suggest that you maintain period integrity. Along these lines it would be wise to adjust your current starting and ending period dates to those of the period you are interfacing to avoid warnings that the transaction dates are not within the current period on the General Journal Transaction Edit List and Register.
You may interface multiple packages without stopping and posting from the General Journal Trx File to the General Ledger. If the General Journal Trx File contains unposted transactions, you will be asked by the program if you still wish to interface. You will not be allowed to interface the same package more than once without posting from the first interface. Since the interface moves data directly from the package into General Journal Trx Processing, you may deal with the transactions exactly as you would had they been entered manually. You are allowed to do full maintenance on the file and may print an Edit List to verify that all transactions were successfully interfaced.
You may want to purge the file while you interface. Elliott suggests that you not purge during interface but purge after posting General Journal Trx. In the unlikely event of a power or system failure, you may not have to restore from a backup but simply interface. If you do not purge the file during the interface, you must do so from within the package of origin. Transactions are flagged after being interfaced and will not be interfaced twice unless you answer Y to field #6, Re-Interface Records Flagged As Interfaced? in this application.
Once you have run the interface you should run General Journal Trx Processing to generate an edit list. When the edit list is approved, you will want to post the transactions to the General Ledger Trx File just as you would ordinary entries using Post General Journal Trx in the Processing window. Interfaced transactions are distinguished from ordinary entries by the source, session and reference fields in the record. If journal history totals are not in use, the source file will be set to XXIN, where XX is the package designation of the interfaced package (AR, AP, PR, JC, IM, or AD), and, if you choose a detailed interface, the reference will provide a description of the original transaction. The reference for a payroll transaction, for instance, would contain the employee number and the check number of the original transaction. If journal history totals are in use, the source field will be set to the interfaced package (AR, AP, PR, JC, IM or AD) followed by the Journal History number originally assigned to the transaction. The session ID will reflect the package interfaced with XXINTRFACE, where XX is the package designation.
Summary Interface
When interfacing, you have the option of doing a summary interface by date within source or by Account Summary. This has the advantage of compressing your transactions into a single transaction for each account number and date. The summary interface will maintain the source (that is, ARIN, APIN, PRIN, JCIN, IMIN, or ADIN) but summarize the information on each account, similar to a compress by date within source compress option in the Compress General Ledger Trx File application. The Account Summary will create one debit and credit transaction for the date range that is being interfaced.
ASCII Interface
When interfacing, you have the option to interface a fixed length ASCII distribution file from another system into the Elliott General Ledger. This ASCII file must be in the format as defined in the Appendix section of the Elliott Developer Reference manual for Accounting (DRMA). The ASCII file name must be GLDISASC.DAT and the file must be copied into the Elliott data directory of the company you wish to interface transactions into.
If the GLDISASC.DAT file is found in your current Elliott data directory then the option to interface the ASCII file at the Interface With Which Package ? question will be allowed. The package code used to interface an ASCII distribution file is AI.
Warning: If you choose to interface ASCII distribution files from another system, make sure to verify the interfaced transactions by printing a General Journal Edit List prior to posting any transactions.
Run Instructions
Select Interface From Other Packages from the pull down G/L Processing window. The following screen will then be displayed:
Interface From Other Packages Entry Screen
The following options are available:
· Select the desired mode from the Interface From Other Packages menu bar
· If there are unposted transactions in the General Journal Transaction File, you will be asked if you still wish to interface. Enter Y to continue or N to exit the application. Enter the data requested on the screen. · To exit press the ESC or F10 key when the cursor is positioned for entry of the first field on the screen
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
Interface With Which Package?
Interface From A/P
|