Audit Trail of Transactions
This window pane provides a list of transactions on all ledgers. To populate the list you must select a range from the dropdown list and then enter the range values and click on the Build List button.
Field |
Description |
---|---|
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. |
Lists all transactions within the range you selected. Double-click on an invoice reference to view the invoice, a contra account to review it, otherwise to load the account into the ScratchPad.
Every transaction in the ledgers is assigned a unique identification number. Numbers are never re-used (except for month-end balance brought forward transactions). The identification numbers are assigned chronologically.
Button |
Action |
---|---|
Build List |
Use this button to build the list using the range selected. |
The window has 2 tab panes.
Reports and Analysis
Error Correction
Reports and Analysis
Audit reports and other analysis tools.
Field |
Description |
---|---|
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. |
Button |
Action |
---|---|
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. |
Analysis Tools
Button |
Action |
---|---|
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. |
Error Correction
Enables some transaction data elements to be corrected for the transaction selected in the audit listing.
Field |
Description |
---|---|
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} |
Button |
Action |
---|---|
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. |
See also: – |
Compiled in Program Version 5.10. Help data last modified 8 Sep 2016 10:31:00.00. Class wAcAuditList last modified 10 Oct 2017 11:47:46.