This document explains how journal entries are linked to source documents such as invoices, checks, and receiving and other inventory transactions.
Journal entry records contain a ref_no field and a memo field. The ref_no field in a journal entry line normally points to the primary document associated with the journal entry transaction such as an AP or AR invoice record, or inventory transaction. The memo field in a journal entry line is often used to point to another secondary document associated with the journal entry, typically an accounts payable or an accounts receivable check number. In some cases, both fields in a journal entry line will contain information, while in other cases one or both of the fields can be blank.
The following logic is used when loading the ref_no and memo fields as journal entry lines are created by the various programs in the system. The Journal Entry source code, originating module and logic used when printing the associated source document detail on general ledger posting reports are listed for each journal entry source code.
When finding a source document from the journal entry, the division and the unique counter for the document (stored in the ref_no field of the journal entry) should be used to find the related document in the appropriate file.
Source Code |
Transaction Description |
Module |
Gl Detail Print Logic | |
AA |
Apply A/P credit memo - A source AA journal entry is created when an AP invoice is applied to an AP credit memo |
AP |
PNOTE=REGISTER.COMPANY REF_NO=REGISTER.TRAN MEMO= REGISTER.CHECK_NO PO =REGISTER.PO_NO | |
AC |
Average Cost Adjustment An AC source journal entry is created when the average cost of an item is adjusted in the product management system and the item has a cost and on hand quantity) |
WMS |
REF_NO=INVTRAN.TRAN PNOTE=COST ADJ | |
AI |
Adjust inventory - Source AI entries are created when inventory quantities are adjusted in the Inventory Adjustment program. |
WMS |
REF_NO=INVTRAN.TRAN PNOTE=QTY ADJ | |
AP |
Accounts Payable A source AP journal entry is created when an accounts payable invoice is created in the Accounts Payable Entry program. |
AP |
SAME AS AA but there is normally no check number or any other information in the MEMO field. | |
AR |
Old Payment Entry ( The AR source code was used in prior versions of the system to record payments against customer invoices. This source code is not currently in use) |
AR |
REF = INVOICES.INV_NO MEMO=CHECK# - in older versions of the system this did not point to a record in any file (a record of the customer check was not created in the data base). | |
BB |
Beg Balance Creator. A source BB entry is created when the operator moves the ending balance sheet balances for one year into period 0 of the next year using the Beginning Balance Loader program. |
GL |
PNOTE BEGINNING BALANCE REF_NO=BLANK MEMO=BLANK | |
BC |
Bank Clearing (foreign currency realized gain and loss entries due to processing payment against foreign currency invoice. |
BNK |
FILE = BANK PNOTE = COMPANY REF=TRAN MEMO=REF_NO | |
BD |
Bank Deposit A source BD journal entry is created when a miscellaneous deposit is processed inside the Bank System |
BNK |
SAME AS BC | |
BF |
Bank Fee - A source BF journal entry is created when a bank fee or bank charge is processed inside the Bank System |
BNK |
SAME AS BF | |
BT |
Bank Transfer Source BT entries are created when amounts are transferred between bank accounts using the Bank System. |
BNK |
PNOTE =TRANSFER OTHER SAME AS BF | |
CA |
Cash Application Source CA entries are created by the Accounts Receivable system when customer payments are applied against accounts receivable invoices. This action creates a check in the ARCHECK file and adjusts the open balance of |
AR |
PNOTE=ARCHECK.COMPANY REF=INVOICES.INV_NO MEMO=ARCHECK.CHECK# (have to find by company and check# or by div and je# in current file 84 structure). PO=INVOICES.PO_NO Note = Some lines (to cash account) will not have an invoice number in the memo field. | |
CD |
Cash Disbursement CD source journal entries are created when accounts payable invoices are paid using a computer generated check or wire transfer |
AP |
FILE=BANK REF_NO = REGISTER.TRAN MEMO=BANK REF_NO FIND BY BANK.JE | |
CV |
Check Void A CV journal entry is created when a customer check or payment record is voided using the Void Check option in accounts receivable. |
AR |
| |
IA |
Invoice Adjustment An IA journal entry is created when a customer invoice amount is adjusted against a general ledger account in the Accounts Receivable Invoice Adjustment program |
AR |
REF_NO=INVOICES.INV_NO MEMO=BLANK PNOTE=INVOICES.COMPANY | |
IC |
Inventory Count Adjustment |
WMS |
| |
IN |
Inventory Depreciate Stock |
WMS |
Used when items are depreciated from the Inventory Management Program. | |
IP |
Inventory Posting |
WMS |
REF_NO=INVTRAN.TRAN MEMO=INVR POST PNOTE = INVENTORY RECEIPT (The inventory transactions will have the vendor name in the company field). | |
JE |
Journal Entry |
GL |
PNOTE =MANUAL JOURNAL ENTRY REF_NO=BLANK MEMO=BLANK (No source documents are associated with a manual journal entry). | |
MD |
Manual Disbursement |
AP |
PNOTE=BANK | |
NI |
Non-Inventory Invoice An NI source journal entry is produced when a Non-Inventory AR invoice is created and posted to the General Ledger on-line |
AR |
| |
OC |
Order Completion (credit applied to invoice during invoicing) |
OF |
| |
OE |
Old sales posting entry (no longer used) |
AR |
| |
PA |
Pending Adjustment (A source PA journal entry is created when a pending ing record is written off to a GL account) |
|
| |
PN |
Pending Depreciate Stock |
PN |
Used when items are depreciated from the Pending System | |
PS |
POS Payment |
POS |
Used to post cash, check, credit card payments against POS Invoices. Code field can contain PCS (pos cash pmt), PCK (pos ck pmt), or PCC (pos cc pmt). Ref will store the AR invoice number in AR Lines. Memo is loaded with CC Tran#, the customer Check Number, or CASH based on pmt type. | |
PP |
Price Protection |
PO |
| |
RA |
Return Authorization |
RA |
Used when items are depreciated from the RA System | |
RI |
Return to Inventory (from Pending) |
|
| |
RV |
Return Disposition - Type RD, RV Invtran (File 91) records |
|
|
|
SB |
Summary Billing A source SB journal entry is created by the Summary Invoicing program when individual invoices are paid off and replaced by a summary invoice |
AR |
|
|
SD |
Summary Deposit Source SD records are created as summary deposits are processed in the Accounts Receivable Deposit Processing program. |
AR |
PNOTE=SUMMARY DEPOSIT REF_NO=BLANK MEMO=DEPOSIT NUMBER (not a document is the unique deposit number assigned to a group of customer checks) |
|
SF |
Shop Floor A source SF journal entry is created when items are returned to inventory from the Manufacturing System and there is a difference between the inventory and work in process value of the items being returned. In this situation, a Gain or Loss entry is made to the GL inventory account for the difference in cost at the time of the transaction. They are created based on Type WO Invtran (File 91) records. |
MAN |
|
|
SP |
Sales Posting- Source SP journal entries are made as the invoices in a given date range are summarized and posted to the general ledger. |
AR |
PNOTE=SALES POSTING REF_NO=BLANK applies to a group or date range of invoices. MEMO=POST SALES |
|
More: