Custom Functions

SapphireOne Utilities provides tools and custom functions that assist with data auditing processes and allows administrators to access, monitor and adjust datafile components.

light

Custom Functions

Custom Tools

Performance & Connections

Maintenance Tools

 

Custom Functions

Custom Functions are for running non-standard activities and should only be accessed at the direction of SapphireOne Support. Functions are grouped under headings that reflect their usage. i.e. those listed under the General Tab are common to all modes within SapphireOne, with other functions relevant to Financials, Assets and Payroll being grouped under the appropriate tabs.

General

Execute Allows access to all data fields and tables within SapphireOne. Authorisation is required.
Gateway Log Displays a log of all Gateway imports and exports. Details can be exported as a csv file.
NameUpdate Resets all custom names back to SapphireOne defaults
Periods Checks accuracy of Periods when combining data files
User Access Keywords Generates User Access Keywords when required

back to top…

Financial

Aging Allows aging of Clients and Vendor Balances to be recalculated.
AnalysisClient Balance Creates a tab delimited text file displaying additional details including historical information to assist with analysing Client Balance discrepancies.
AnalysisVendor Balance Creates a tab delimited text file displaying additional details including historical information to assist with analysing Vendor Balance discrepancies.
BAS GST Audit Exports a text file that contains a list of all transactions within a BAS period as determined by the requested start and end date entries.
BuildAnalysis Creates a tab delineated text file displaying additional information about Inventory built items.
Check Vendor ABN Checks all Vendor ABN’s for validity and exports invalid entry details as a tab delimited text file.
Client Allocation Audit Checks Client Allocations against Client Balances Total Due and exports allocation error details as a tab delimited text file.
Client Audit Checks History Journal Lines against Client Balances and exports details as a tab delimited text file.
CompareClientTotal Checks the Client total GL balance with the Client Transaction total and exports results as a tab delimited text file.
CompareVendorTotal Checks the Vendor total GL balance with the Vendor Transaction total and exports results as a tab delimited text file.
Full History Copies posted or entered status transactions and invoices from current to history, if they have not been created in history already.
GL Audit Performs a GL Audit by comparing the GL Balances by period to the Journal Lines that make up the balance for each period and logs any errors to a predefined log file.
HInv Audit Checks that transactions exist for all invoices and exports results to a tab delimited text file.
Import Postcodes Imports a text file list of Australian Postcodes Suburbs and Cities.
InventoryValueAudit Calculates Average Cost x Inventory Quantities and compares results with the dollar value in the appropriate General Ledger account.
InvoiceAudit Performs an Invoice Audit by comparing the Invoice totals to the total of the account lines that make up a transaction and exports any errors to a tab delineated text file.
LocationAudit This function queries all locations and ensures that the Base ID is correctly totalled when running in multi-location mode.
No ABN Generates the ‘No ABN’ magnetic media file for the Australian Taxation Office.
PrGiRecal Recalculates transactions linked to Projects and checks that the correct values are entered into the appropriate General Ledger account.
RemarkBankRec Compares the bank reconciliation state of each current transaction against the same transaction stored in history. If there is a discrepancy, the current transaction’s bank rec state will be changed to reflect the historical transaction’s bank rec state.
ResetPlugins Clears Plug-in keys and allows re-entry.
SequenceNumb Resets sequence numbers if they have changed and ensures that there is no overlapping.
SerialFix A specialised function allowing management of serial numbers for damaged logs.
StockAdjAudit Checks stock adjustments against History Invoice lines.
SystemAudit Performs a System Audit by searching history for potentially illegitimate transactions against control accounts. The function reports on non-vendor transactions allocated to vendor control accounts, non-client transactions to client control accounts & non-bank Transactions to bank accounts. Results are exported as a tab delimited text file.
Tran Audit Performs a Transaction Audit by comparing the Transaction’s total to the total of the journal lines making up that transaction. Errors are logged in a predetermined error log file.
Tran Company Audit Cross checks inter-company transactions.
TranAllocAudit Checks previous periods for the selected Client and updates Cost and Sales values.
Update Projects Re-calculates a projects’ actual costs and billing information from source data and updates Tasks located on the Planning/Quote page.
Vendor Allocation Audit Checks History Transactions against Vendor Balances and exports results to a tab delimited text file.
Vendor Audit Checks History Journal Lines against Vendor Balances and exports results to a tab delimited text file.

back to top…

Assets

 

 

back to top…

Payroll

[current year]SuperUpdate Automatically updates the percentage value of the employer compulsory superannuation contribution for all employees. This function is updated annually.
CheckAlltots Checks and recalculates all allowance totals based on payroll history.
ExpDeduction Exports a breakdown of deductions for the current Pay Run as a tab delimited text file
ExportTranHol Exports current Pay details to another data file.
ImportTaxRates Text Imports the latest Tax Rates from a text file provided by SapphireOne at the beginning of each financial year.
ReversePayRun Reverses the last pay run for all employees or for selected employees.
Setup PayrollWizard This wizard allows you to set up a checklist and the order in which procedures are to be run when completing a pay run.
SuperRec Prints a list of employees including Job Title, Class and Department details.
UpdateEmployee YTD Recalculates and updates the Employee’s YTD accumulators.
VerifyUnposted Payroll Checks and verifies any un-posted records in Payroll.

back to top…

 

Custom Tools

Procedures

Custom Tools provide additional tools for the maintenance of your data file

back to top…

Performance & Connections

Error Controller

This window displays a live list of any transactions that may be in error.

back to top…

Server Administration

Selecting this option opens the Server Monitor window. From here you can view your system’s performance and carry out back-ups and datafile maintenance procedures.

back to top…

Host Web Server

Provides access to web server details page …web client

back to top…

 

Maintenance Tools

Verify Unposted

This procedure checks all of the un-posted values in your SapphireOne program and verifies any links with your General Ledger.

back to top…

Retrieve Upgrade values

This tool brings in new data for SapphireOne when an upgrade is done.

back to top…

Plug In Keys

This resets the Plug-In keys back to zero after which all keys can now be re-entered.

back to top…