General Ledger Reporting Logic

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:

General Ledger System Startup