Journal Entry Source Codes

Each journal entry that is created in the Journal Entry file is assigned a source code.  The source code identifies where, in the system, the journal entry came from.  The source code can also be used for reporting, auditing, and trouble shooting purposes.  The source code field is displayed in various inquiry programs and printed on many reports.  The source code field can also be used as a selection criteria on many accounting reports.  The GL Autoposts used by the applications that create each Journal Entry Source code are listed where applicable

Source

Description

Module

GL Autoposts Used

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

AP Autopost stored in each invoice (310-319)

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

Inventory based on Product Line of Item being adjusted (150-199), and  Cost Adjustment Code (721-730)

AD

Automated Deposit – An AD source journal entry is created when customer payments are automatically applied to accounts reveivable invoices using the ACA (automated cash application) system

AR

Cash Clearing (1-99) , AR (120-149), Discounts Taken (570-599)

AI

Adjust inventory  - Source AI entries are created when inventory quantities are adjusted in the Inventory Adjustment program.

WMS

Inventory (150-199),  Inventory Adjustment Account (700-710)

AP

Accounts Payable – A source AP journal entry is created when an accounts payable invoice is created in the Accounts Payable Entry program.

AP

AP Autopost in Vendor Acct (310-319) Inventory Liability Account (340) if Inventory Invoice, Freight Liability Account (341) Other distribution accounts selected by operator.

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

NA

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

Based on Balance Sheet Accts with non-zero Balances (all balance sheet accounts with or without autoposts).

BC

Bank Clearing (foreign currency  realized gain and loss entries due to processing payment against foreign currency invoice.

BNK

Cash (100-119), FC Gain or Loss (840)

BD

Bank Deposit – A source BD journal entry is created when a miscellaneous deposit is processed inside the Bank System

BNK

Cash (100-119) Bank Misc Deposit Code (790-799)

BF

Bank Fee -– A source BF journal entry is created when a bank fee or bank charge is processed inside the Bank System

BNK

Cash (100-119), Bank Charge Code( 780-789)

BT

Bank Transfer – Source BT entries are created when amounts are transferred between bank accounts using the Bank System.

BNK

NA – program discontinued, see BF, BD Sources

CA

Cash Application – Source CA entries are created by the Accounts Receivable system when customer payments are applied against accounts receivable invoices.

AR

AR (120-129), Cash Clearing (1-99), Discounts and Chargeoff Accounts (570-599), FC Gain or Loss (840)

CD

Cash Disbursement – CD source journal entries are created when accounts payable invoices are paid using a computer generated check or wire transfer

AP

Cash (100-119), AP (310-319), Discounts Earned (820) FC Gains or Losses (840)

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

Cash (100-149), or Cash Clearing (0-99), AR (120-149), Discounts Taken (570-599)

ES

Edit Shipping.  An ES journal entry source is used when the shipping amount for an invoice is changed using the Edit Shipping, Update invoice option in the Shipping utilities program.  If the invoice being processed is posted and you are posting sales online, an ES journal entry is created by the program to reverse the original sales posting for the invoice.  A new source OP journal entry is then created to post the updated invoice amounts.

OF

See sales posting - source SP

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

AR (120-149), Other accounts selected by operator (program does not allow posting to AR, CASh Autoposts).

IC

Inventory Count Adjustment

WMS

Inventory (150-199),  Count Adjustment (701)

IN

Inventory Depreciation.  A source IN journal entry is made when an item is depreciated using the Depreciate Stock option that is available in the Inventory Management program.  The depreciate stock option can be used to convert an item to a depreciated or less valuable version of the same sku (ie open box, rebox, cosmetic damage version of item).  The amount of the je is based on the diff in cost between the normal and other version of item being used and/or a write off percentage used when creating a new deprrec version of item.   .  The Inventory transaction type used for Depreciate Stock transactions is always CI but the je source is based on the program from which transaction is processed.  (RA, IN, PN).

WMS

Inventory (150-199), Gain Loss on Returns to Inventory (670)

IP

Inventory Posting

WMS

Inventory (150-199), Inventory Liability (340), Freight Liability (341)

JE

Journal Entry

GL

Allows posting to all accounts, certain accounts can be blocked using security settings which can be set by operator.

MD

Manual Disbursement

AP

Cash (100-119),  AP (310-319), Discounts Taken (820), FC Gain Loss (840)

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

AR (120-149), Accts specified in NIGLACCT Gencode Table

OC

Order Completion (credit applied to invoice during invoicing)

OF

AR (120-149)

OE

Old sales posting entry (no longer used)

AR

NA – See sales posting

OP

Online Posting – New GL source code used when AR Invoice is posted on-line at the end of invoice creation.

AR/OF

See Sales Posting (SP), Same Logic is used for OP, SP

PA

Pending Adjustment (A source PA journal entry is created when a pending record is “written off” to  a GL account)

WMS

Inventory based on Product Line of Item being adjusted (150-199), Pending Cost Adjustment Code (711-720)

PN

A source PN journal entry is made when an item is returned to stock and then depreciated using the Depreciate Stock option that is available in the Pending Management program(s).  The depreciate stock option can be used to convert an item to a depreciated or less valuable version of the same sku (ie open box, rebox, cosmetic damage version of item).  The amount of the je is based on the diff in cost between the normal and other version of item being used and a write off percentage used when creating a new deprrec version of item.  The Inventory transaction type used for Depreciate Stock transactions is always CI but the je is based on the program from which transaction is processed.  (RA, IN, PN).  

WMS

Inventory (150-199), Gain Loss on Returns to Inventory (670)

PP

Price Protection

PO

Inventory (150-199), Price Protection (360)

PS

POS Payment Processing

POS

POS Clearing Accounts (1001, 1002, AR (120-129)

RA

A source RA journal entry is made when an item is returned as a depreciated item (ie open box, rebox, cosmetic damage version of item) during RA processing.  The amount of the je is based on the diff in cost between the normal and other version of item being used and a write off percentage used when creating a new deprrec version of   The Inventory transaction type for Depreciate Stock transactions is always CI but the je is based on the program from which transaction is processed.  (RA, IN, PN).  

RA/PMS

Inventory (150-199), Gain Loss on Returns to Inventory (670)

RI

Return to Inventory (from Pending)

PND

Inventory (150-199), Gain Loss from Ret to Inv (670)

RV

Return Disposition - Type RD, RV Invtran (File 91) records

PND

Inventory (150-199), Gain Loss from Ret to Vendor (660)

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

AR (120-149)

SC

Shop Completion – A source SC journal entry is created when non-stock items are consumed during shop order completion.  This journal entry records the conversion of the cost of the nonstock item into inventory (the nonstk item cost is included in the finished item and must be added to inventory).

SF

Inventory (150-199)

SD

Summary Deposit – Source SD records are created as summary deposits are processed in the Accounts Receivable Deposit Processing program.

AR

Cash Clearing  (1-99), Cash (100-119)

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.

SF

Inventory (150-199), Gain Loss – Returns from Manuf (680)

SP

Sales Posting

AR

AR (120-149), Inventory (150-199), Sales (500-549, 5000-5499), Cost of Sales (60-649, 6000-6499), Sales Tax Payable (370. 3700-3799), Sales Discounts (550), Shipping (560), Vendor Rebates Receivable (320), Finance Charges Income (830), FC Rounding (835)

More:

Month-end Processing Checklist