Custom Functions are for running non-standard activities and should only be accessed at the direction of SapphireOne Support. These may either damage your data file or make changes to it that you do not want so speak to SapphireOne before accessing. 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.
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.
| 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 |
| 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. |
| [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. |
Custom Tools provide additional tools for the maintenance of your data file.
This window displays a live list of any transactions that may be in error.
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.
Provides access to web server details page …web client
This procedure checks all of the un-posted values in your SapphireOne program and verifies any links with your General Ledger.
This tool brings in new data for SapphireOne when an upgrade is done.
This resets the Plug-In keys back to zero after which all keys can now be re-entered.