General Journal Interface: Pipe Delimited Method
Use the General Journal Interface to load general ledger entries using data from external applications. Information you load using this interface adds to or updates the data already stored in PENTA.
This interface lets you:
Make journal entries for equipment and fixed assets whose OUs you are authorized for.
Associate a cash account number with a cash related journal entry.
Data files you load must have Request Types assigned to the J Interface Type.
The following System Options affect interfaced records:
107 (Prevent Inter_BS Entries) - if set to Y, transactions for one balance sheet only can be included in the journal entry.
125 (Mark Batch for Distribution) controls whether PENTA automatically distributes the batches.
128 (Reject Interface File on Error) whether PENTA rejects a batch when errors exist in the file.
Processing
Only if the following is true will PENTA attempt to process the Detail Records and distribute the batch (Header Record and associated Detail Records):
The record count equals the number counted by PENTA during processing.
The batch is in balance. PENTA generates an exception message that states the amount the batch is out of balance, but the interface program cannot identify the exact transaction that is incorrect.
The currency for all distributions within the batch is the same.
The batch affects no more than two balance sheets. If System Option 107 is Y, you can only use one balance sheet. If a batch impacts more than two balance sheets, PENTA does not process it.
The journal number is unique. If the journal number is not unique, PENTA does not process the batch.
Where to View Loaded Data
If System Option 125 is set to N, you can view and modify records in the Journal Entry window. PENTA creates the batch in the Journal Entry window so you can update, delete, or release the batch.
Available Records
Customer Reference Detail Record
# | Field | Entry | Format | Description |
---|---|---|---|---|
1 | Record Type | Req | I 1 | This value should be 3 to identify the record as a Customer Reference record. |
2 | Customer Reference Code | Req | C 15 | ID referring to Customer-specific information. |
3 | Customer Reference Value | Opt | C 30 | The value for the associated Customer Reference Code. |