Understanding Transaction Codes in CATS

You can see transaction codes on reports and in the general ledger scan. In general, the transaction in uppercase is the entry you put in, and the lowercase part is the proof amount/opposite side entry.

Under the T (Type) column, you can have the following transaction-related codes.

R/r = Credit into G/L account/bank.
P/p = Debit from G/L account/bank.
Q/q = General journal entry OR internal CATS movements (moving the balance from one invoice to another, foreign currency balance transactions, etc.).

Under the TrCd column, you can have the following transaction code types.

BD = Bank deposit, part of a receipt.
AC/ac = Commission invoice.
CK = A check (disbursement).
bt = Bank transfer.
fx = Foreign currency adjustment.

Under the T column, you can have the following values for invoices.

OP/OA = On account invoices.\
I/i = Sale invoice.\
A/a = Purchase Invoice.\

In addition to the main invoice type code, CATS uses the following fields from the Accounting > Invoice Types code file.

* Transaction Code - This two-digit code was created when this invoice type was set up. This populates the TrCd column of the general ledger.
* Invoice Type - The first two letters are used for the invoice type. This is pulled into the InvoType column.

List of invoice types and transaction codes.

Automatic Codes

Q/q = Entries CATS makes to adjust balances. Q entries can be used in the following transactions:

To move balances from provisional invoices to their related final invoices.
To create automatic currency movements.
For entries moving between inventory and cost of goods sold.

Sample Entries

Here is a sample G/L scan with entries of most types available.

Transaction Code Types in the General Ledger Scan

Combining the two codes, we can interpret the type of transaction. Examples include:

I SF FI is one side of a posted sales invoice (the top level of the invoice), and i SF FI is the opposite side (the invoice items).
A AP PU is one side of a posted purchase invoice (the top level of the invoice), and a AP PU is the opposite side (the invoice items).
P CA CK is the top line of a disbursement, and p is used for each application of the disbursement (against different invoices or GL numbers).
R BD is the top line of a receipt, the bank deposit line, and r is used for each application of the deposit/credit.