Ledgers Manager: Audit Trail of Transactions

Selection range list

Select the field that you want to select from.

From

Enter data that restricts the records selected. If left blank, data will be selected from the maximum and minimum extremes in the file. All selections criteria you enter will have to be met by each record processed.

To

Enter data that restricts the records selected. If left blank, data will be selected from the maximum and minimum extremes in the file. All selections criteria you enter will have to be met by each record processed.

Adhoc where

The final selection in the dropdown list will open the Adhoc extra where combo box normally seen in data selection dialogues. In here you can either select a previously performed where clause or enter a new one. Do not start with a WHERE. For example, you may want to show all USD transactions with TRACURR=’USD’, or all transaction for a User Id TRAINIT=’JB’, or transactions of a particular amount TRAGROS=96824.75. All sorts of combinations are possible. See the Client-Server SQL Introduction help for a longer discussion.

Sum of selected

Sum of selected transactions (Gross-Discount+Tax) in local currency.

Build List

Use this button to build the list using the range selected.

Transaction List Report

Make this selection for a normal audit report of the list obtained on the previous tap pane.

Normal Audit Transaction Report

Make this selection for a normal audit report which will show all transactions meeting the selection range entered.

Include full details on the report

Check this option to have the report print an extra line of transaction detail.

Selection

Enter data that restricts the records selected. See the Transaction Selection subwindow for more details.

Special Contra Balance Check Report

A special General Ledger balance-check report that identifies if errors have occurred when multiple transactions across General Ledger accounts have occurred.

You will first be offered a starting period serial number (not the same as a descriptor – see Ledgers Period Calendar Maintenance). In operation it looks for all contra value transactions where the contra value does not start with a G, within the same period, and having a sum of local currency values that is non-zero. Other than some currency revaluation activities, all such blocks of transaction should balance, so the report generally identifies problems that have occured and may be a pointer to the source of a G/L Imbalance.

G/L Transaction Trial Balance Report

Provides a special account trial balance report for all G/L transactions on file that should show that all General Ledger accounts balance.

Print Report

Will cause a report to be printed of the subject matter. You can change the Destination of the report by selecting the ‘Report Destination’ menu command.

Benford’s Law

Provides a Grubby Pages Phenomenon analysis of various data sets. See the Grubby Pages Phenomenon topic.

Account Statistics

Provides a statistical analysis of accounting data. See the Ledgers Transaction Analysis topic.

History Integrity

Provides an integrity test and analysis of the G/L history. See the G/L Account History Validation Testing topic.

Transaction Id Check

Scans transaction data and looks for missing Id numbers. Low numbers will be missing due to archiving. High numbers may indicate record deletions. The Omnis Studio Trace Log will open and show where Id gaps are present. Thereafter you can explore using the Audit Trail List.

NOTE: Transactions in PostgreSQL behave subtly differently from other database engines. When a row is inserted a Sequence object within the database is used to provide the next Record Sequence Number, a bit like an auto-advancing counter. For example, the Transaction Serial Id (TRASEQ) in Ledger Transactions. PostgreSQL does not include this Sequence activity within it’s Searialisable Transaction model. As a result, in the event of an error during a transaction that has inserted rows into the database, and therefore advanced the Sequence, on rollback the Sequence will not be returned to it’s original, pre-transaction, value. The effect of this is that record sequence numbers do not always advance by 1. There can be gaps when serialisable transactions fail and are automatically rerun when contention between user activities is spotted. In the normal course of events this is unimportant. However, in Ledger Audit Trail analysis when looking for manually deleted transaction, this behaviour should be recognised as normal. Missing TRASEQ numbers is NOT proof of manually deleted data rows.

Future G/L Balances

Looks at G/L transaction data from the current and for future periods and checks period balancing.

Ledger

Ledger Transactions. Ledger type (P=A/P,R=A/R,G=G/L). {TRAFILE.TRALEDG char 1}

Account code

Ledger Transactions. Account code (Payable/Receivable/General). {TRAFILE.TRAACCO char 10}

Account name

Account description or supplier or customer company name.

Period

Ledger Transactions. Period serial number of transaction. {TRAFILE.TRAPERN number}

Contra account

Ledger Transactions. Contra account identifier code =con(TRALEDG,TRAACCO). {TRAFILE.TRACONT char 11}

Contra account name

The name of the contra account.

Transaction number

Ledger Transactions. Record sequence number. {TRAFILE.TRASEQ sequence}

Transaction type

Ledger Transactions. Transaction type (0, 1, 2, 3, etc). {TRAFILE.TRATYPE integer shortint}

Type description

Ledger Transactions. Transaction type (0, 1, 2, 3, etc). {TRAFILE.TRATYPE integer shortint}

Date

Ledger Transactions. Date of transaction. {TRAFILE.TRADATE date date1980}

Document reference

Ledger Transactions. Document reference. {TRAFILE.TRADOCR char 15} NOTE: Document Reference values can not be between “XX-000000” and “XX-999999” where XX is either ASS, CA, CH, CR or IN, as these are reserved for the system.

Due date

Ledger Transactions. Date payment due. {TRAFILE.TRADUED date date1980}

Comments

Ledger Transactions. Comments on transaction. {TRAFILE.TRACOMM char 30}

User ID

Ledger Transactions. Users transaction identifier. {TRAFILE.TRAINIT char 3}

Cleared

Ledger Transactions. Cleared flag. {TRAFILE.TRACLEA boolean}

Currency

Ledger Transactions. Currency code. {TRAFILE.TRACURR char 3}

Local currency

Company and System Settings. Standard currency symbol. {MCDFILE.MCDSTCU char 3}

Gross amount in currency

Ledger Transactions. Gross amount in currency debited (-ve credited) to account. {TRAFILE.TRAGROSF number 2dp}

Gross amount

Ledger Transactions. Gross amount in local currency debited (-ve credited) to account. {TRAFILE.TRAGROS number 2dp}

Discount amount in currency

Ledger Transactions. Discount amount in currency on gross to make net. {TRAFILE.TRADISCF number 2dp}

Discount amount

Ledger Transactions. Discount amount in local currency on gross to make net. {TRAFILE.TRADISC number 2dp}

Tax amount in currency

Ledger Transactions. Tax amount in currency on net purchases (-ve on sales). {TRAFILE.TRATAXF number 2dp}

Tax amount

Ledger Transactions. Tax amount in currency on net purchases (-ve on sales). {TRAFILE.TRATAXF number 2dp}

Debit or Credit (-ve) value in currency

The net value of the transaction. Negative values are credits.

Debit or Credit (-ve) value

The net value in local currency of the transaction. Negative values are credits.

Un-paid amount in currency

Ledger Transactions. Amount in currency due to be cleared (0.00 = fully allocated) (was TRAPAID). {TRAFILE.TRADUEF number 2dp}

Un-paid amount

Ledger Transactions. Amount in local currency due to be cleared (0.00 = fully allocated). {TRAFILE.TRADUE number 2dp}

Sales tax code

Ledger Transactions. Tax Id jst(TAXCODE,’3X’,TACCLAS,’1X’) in G/L tax control accounts (or blank for tax authority transfers) or Tax Regime Id jst(TAMCODE,’6X’,TACCLAS,’1X’) in A/P and A/R. {TRAFILE.TRATAXC char 7}. (See the Tax Maintenance window for details of the tax system.)

Sales tax rate

The tax rate that is currently applicable to the tax class.

Input turnover

Ledger Transactions. Input goods (purchases) taxable turnover. {TRAFILE.TRATAXO number 2dp}

Memo set number

Ledger Transactions. Credit control memo set serial number. {TRAFILE.TRATRC number}

Output turnover

Ledger Transactions. Output goods (sales) taxable turnover. {TRAFILE.TRATAXI number 2dp}

Allocation serial number

Ledger Transactions. Allocation serial number. {TRAFILE.TRATRL number}

Special trading status

Ledger Transactions. Trading country flag. {TRAFILE.TRATRAD boolean}

Save

To save the changes you have made to the data file.

Revert

To revert any changes to the previously saved version.

Delete

Execute this button to permanently remove the currently selected record from the file. If you are permitted to delete the item, you will be asked for confirmation, otherwise an explanation will be given.

• Transaction Selection
• Grubby Pages Phenomenon
• Ledgers Transaction Analysis