General Ledger Interface [U1003]
End of Period: This process can be selected to run during End of Period. As an EOP module, the process is:
| EOP Only | No |
| Frequency | Daily |
| Sequential Updates | No |
| Skip Notes | See comments below |
For more information about End of Period, refer to U04 End of Period Overview.
This optional module is designed to allow the transfer of information from LeasePak's General Ledger to another general ledger system. It accomplishes this by creating a special scratch file containing the daily debits, credits and account balances for each LeasePak General Ledger account, for each office. All transferring is performed based on daily totals. A customized, user-supplied program must then translate the information in the scratch file to a format that can be read by the non-LeasePak general ledger system.
Skip Notes: If it is purchased, this module is run during End of Period. If it is skipped, the Zero Daily General Ledger Accounts update [U0422] should also be skipped. Otherwise, when the interface is later run, the current day's totals are no longer available for transfer.
Scratch File
LeasePak's General Ledger interface scratch files is an ASCII flat files. There is one scratch file for each portfolio. Each record in the file is 143 bytes long. The file is STREAM format with no record separators; that is, it is one large record.
The outbound file is located in the directory:
$udata
The file name is called:
dsgl_p??.dat
Where xx is the client ID and ?? is the number of the portfolio.
All fields are converted to a string format before being written to the file. The format is as follows:
| Field Name | Size (bytes) | Type |
|---|---|---|
| Portfolio number | 2 | Alphanumeric |
| Company number | 2 | Alphanumeric |
| Region number | 2 | Alphanumeric |
| Office number | 3 | Alphanumeric |
| GL Account EOP trans date | 6 | Numeric |
| GL Account Type | 1 | "C" or "D" |
| GL Account Number | 12 | Alphanumeric |
| GL Account name | 36 | Alphanumeric |
| GL Account debit | 15 | Numeric signed |
| GL Account credit | 15 | Numeric signed |
| GL Account M-T-D debit | 15 | Numeric signed |
| GL Account M-T-D credit | 15 | Numeric signed |
| GL Account balance | 15 | Numeric signed |
| Fill (blanks) | 4 | |
| TOTAL | 143 |
An example of a numeric signed value is 0012649053+. The first eleven characters are the dollar value, multiplied by 100. In this example, the actual dollar value is $126,490.53 The twelfth character is either a plus (+) if the value is positive or a minus (-) if negative.
Running the Interface
The General Ledger Interface [U1003] may be executed automatically through End of Period [U04] processing.
LeasePak Documentation Suite
©
by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.