Audit Lines - Enhance Clarity in Tracking and Analysing Audits

Accounts Audit Lines Overview

The Accounts Audit Lines Inquiry function in SapphireOne’s Accounts History Mode enables users to view all Audit Lines within historical transactions. All transactions listed in the Accounts Audit Lines Inquiry screen are posted transactions that have been moved into History by SapphireOne. This screen includes posted transactions from both past and current periods, providing a comprehensive view of the audit lines associated with these transactions. Users can access and review detailed audit information for these transactions, facilitating accurate tracking and analysis of historical data.

Initially, the transactions in the Audit Lines are listed in the order of entry, with the most recently dated Audit Lines at the top. To change the sorting order, simply click on any of the column headings. By re-clicking the column heading, you can switch the selected column from ascending to descending order, or vice versa.

Additionally, you have the ability to rearrange the columns by clicking on a column and dragging it to the left or right. Similar to other List windows, you can customize the displayed information by highlighting and utilizing functions from the Options Menu. This allows you to reorganize and tailor the view according to your preferences, offering flexibility in managing and presenting the information.

In SapphireOne, all inquiry screens provide the option for customisation of the displayed item list. The feature, called Custom Inquiry, lets users choose the data fields to be shown and the sequence of data columns across the screen. The user can save infinite custom views. While a client list is used as an example to follow, any inquiry type can be customised in SapphireOne.

The Standard Inquiry Screen

The Standard Inquiry Screen in SapphireOne provides a foundational view of data, presenting a set of column fields for each record. This screen is designed to offer a straightforward and efficient way to access and review essential information.

The list above represents the standard inquiry list, displaying a fundamental set of data fields for each client record and includes two buttons as follows:

  • Swap to Custom Inquiry – When the user selects the ‘Swap to Custom Inquiry’ button in the lower left-hand corner of the screen, SapphireOne will display the default Custom Inquiry Screen, which is documented below.
  • Show/Hide Audit Lines – Toggle the Audit lines panel open. This panel will display at the bottom of the Inquiry screen, benefiting workflow by providing an immediate view of the critical details for a selected line.

The Custom Inquiry Screen

When the user selects the ‘Swap to Custom Inquiry’ button from the Standard Inquiry, SapphireOne will display the default Custom Inquiry Screen, as shown below. This screen provides the user with a customisable view of the data set, which is maintained per user and for each particular inquiry.

The options available from the Custom Inquiry Screen are as follows:

  • Swap to Standard Inquiry – Return the view to a standard Inquiry.
  • Method List Box – This list box, in conjunction with the adjacent operator list box, allows for calculations to be performed across all rows of the displayed data. The results are displayed adjacent to the operator list box.
  • Operator List Box – Select an operator to apply to the method selected using the method list box.
  • Setup Button – The Setup button will open a modal screen with functionality to customise the Custom Inquiry, as documented in the following section.
  • Export Button – Open the data set in CSV format in the devices default spreadsheet application.

The Custom Inquiry Setup Screen

The Custom Inquiry setup screen allows for the customisation of the data view, which is maintained per user and for each particular inquiry. Once the user has customised the Custom Inquiry screen, the screen view will be maintained in subsequent sessions and is unique to the current user account. This screen also provides the option to select and save an unlimited number of custom views per user.

The Custom Inquiry setup screen provides the following functionality:

  • Favourite Sets – This option enables the user to save a custom-created screen for future use. For instance, the user can have a simple Inquiry screen for general use and a more complex screen view when auditing specific information.
  • Row Height – Adjust the table row height to the users preference.
  • Show Related Record – This option allows the user to add related fields from other tables. By ticking the Show Related checkbox at the top of the screen, the user can select a related record, and a view of that related record for the chosen entry will be displayed for that currently selected record. The user will need to select the fields to be displayed.
  • Reset to Default – Reset the display to the default view configuration as established by SapphireOne.

The Custom Inquiry setup screen provides the user with two main options for organising the data displayed:

  • To remove or relocate a column – Right-click on the column lines and choose from Delete, Move Left, or Move Right.
  • To add a column – Locate the desired data set in the list and double-click on it to add it to the custom view as a new column. Edit the location as described above if required. Almost every field within the SapphireOne data tables can be included in the Custom List screen, provided the user has the necessary authorisation.

Customising inquiry screens in SapphireOne allows for a tailored data view that meets the users specific needs. By leveraging the Custom Inquiry feature, the user can enhance their workflow efficiency and ensure that critical information is readily accessible.

Viewing Individual Audit Lines

From this list, you have the option to View or Look Look a transaction, which will open the corresponding screen and allow you to view historical details for the transaction as seen below.

Details Area

  • ID – This field in the Audit Line record refers to the Table ID associated with the specific Audit Line. This ID corresponds to the relevant table, such as Client, Vendor, or General Ledger, to which the Audit Line is linked. It serves as a unique identifier that helps establish the connection between the Audit Line and the corresponding record in the respective table, providing valuable context and reference for auditing and analysis purposes.
  • Type – This field in the Audit Line record refers to the type of transaction associated with that particular line. It indicates the category or nature of the transaction, providing information about its purpose or function.
  • Post – This field in the Audit Line rexcord refers to the user who posted the transaction’s Audit Line, as well as the date and time when the transaction was posted. It captures the information about the user responsible for the posting action and provides a timestamp for when the transaction was recorded in the system
  • Run No – This field in SapphireOne refers to the Run Number of a batch process. In a batch processing system, multiple tasks or transactions are grouped together and processed as a batch. The Run No represents the specific number assigned to a particular batch process process.
  • Allocation – This field in SapphireOne refers to the allocated amount and percentage of the transaction. It represents the portion of the transaction that has been allocated to a specific category, account, or recipient.

Tracking Area

  • Period – This field in the record refers to the specific accounting period to which the transaction belongs. It represents the time frame in which the transaction is recorded or allocated for accounting and reporting purposes.
  • Date In – This field in the record indicates the date when the transaction was created or entered into the system. It serves as a reference for when the transaction was initially recorded or received.ed.
  • Due – This field represents the due date of the transaction. It signifies the date by which the payment or action related to the transaction is expected to be completed or fulfilled.
  • Int. Ref – This field records for the internal reference number generated by SapphireOne for the transaction. It serves as an internal identifier or tracking number specific to the transaction created within the system,
  • Ext. Ref – This field captures the external reference number for the transaction. It is a user-defined reference number or identifier that can be provided by the user to track and link the transaction to external systems, documents, or references.
  • Memo – This field is used to record any additional notes or comments associated with the transaction. It provides a space where users can enter relevant information, such as explanations, reminders, or specific instructions related to the transaction.

Currency area

  • Local – The fields following this section display the amounts of the transaction in the local currency. These fields represent the value or monetary amount of the transaction in the local currency, providing a perspective on the transaction’s worth in the local currency.
    • Amount – This field represents the pre-tax amount of the transaction. It indicates the value or monetary value of the transaction before any tax or withholding is applied..
    • Tax – This field displays the amount of tax withheld in the transaction. It refers to the portion of the transaction that is collected or deducted as tax.
    • Total -This field represents the total amount of the transaction, including the tax component. It reflects the overall value or monetary value of the transaction, inclusive of any applicable taxes.
  • FX – This field refers to the Foreign Currency amount of the transaction. It represents the value or amount of the transaction in a currency other than the base or local currency of the system.
    • Amount – This field represents the pre-tax amount of the transaction. It indicates the value or monetary value of the transaction in FX before any tax or withholding is applied..
    • Tax – This field displays the amount of tax withheld in the transaction. It refers to the portion of the transaction that is collected or deducted as tax in the FX currency.
    • Total -This field represents the total amount of the transaction, including the tax component. It reflects the overall value or monetary value of the transaction, inclusive of any applicable taxes in FX.

General Ledger area

  • Account Number – This field indicates the General Ledger account to which the transaction is linked. It provides the specific account identifier within the General Ledger system.
    • Name – This field corresponds to the name or description of the General Ledger account linked to the transaction. It provides a clear identification of the account associated with the transaction.
    • Amount – This field represents the total amount of the transaction excluding tax. It indicates the value or monetary value of the transaction before any tax or withholding is applied.
    • Code – This field in the transaction displays the tax code that has been applied to the respective audit line. This code represents the specific tax category or classification that has been assigned to the audit line within the transaction.
    • Tax % – This field signifies the percentage of tax applied to the transaction. It represents the tax rate or tax percentage associated with the transaction.
    • Tax – This field represents the total amount of tax calculated for the transaction. It represents the cumulative tax amount applied to the transaction.
    • Total – This field represents the overall amount for the transaction, including both the base amount and the tax that has been applied. It reflects the combined value of the transaction, incorporating the original amount plus the corresponding tax amount.d
  • Notes – This field displays any additional information or comments that have been entered in relation to the Audit Lines transaction. It serves as a space where users can record relevant notes, explanations, or any other details that provide further context or clarification for the transaction.

Custom Fields area

  • Custom Fields – Any custom fields heading that are in the transaction will be displayed in this area. These custom fields provide additional flexibility and allow for the inclusion of specific information or data that is relevant to the transaction but may not be captured by standard fields. The presence of custom fields ensures that you can tailor the transaction to your specific needs and capture any unique or specialized information required for your business processes.
    • Setting Up Custom Field Headings – In SapphireOne, there is a custom function called Change Names that allows users to modify or customize field names within the system. For more detailed information about this function and its usage, you can refer to the article titled Change Names. This article provides comprehensive instructions and guidance on utilizing the Change Names function to customize field names according to your specific requirements within SapphireOne.

Footer area

  • Sequence – This field displays the unique sequence number generated by SapphireOne for the transaction. This number serves as a distinct identifier for the transaction within the system.
  • Amount – This field displays the total amount of the Audit Lines Transaction. It represents the overall monetary value of the transaction, inclusive of any applicable taxes or fees.
  • Tax – This field displays the total tax amount associated with the Audit Lines Transaction. It represents the cumulative tax applied to the transaction.
  • Total – This field displays the total tax amount of the Audit Lines Transaction. It represents the overall sum of the taxes levied on the transaction.
  • Invoice Button – Selecting the Invoice button will open the Invoice on screen, allowing users to view the corresponding invoice associated with the Audit Lines Transaction. This then provides additional information and a comprehensive view of the invoice for further review and analysis.

You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Printing

By selecting the Print-ButtonPrint button located on the main toolbar, you have the option to generate a Historical Audit Lines Report dedicated to the selected historical transaction. This report offers a comprehensive overview of the audit lines associated with the transaction, serving as a documented record for reference and documentation purposes. It provides valuable insights and detailed information about the transaction’s audit history, facilitating accurate tracking and analysis of the historical data.

 

Was this helpful?

Previous Article

Transactions

Next Article

EFT Files