Clients Inquiry Overview
SapphireOne’s Clients Inquiry function in Accounts mode allows for the efficient management of all customer sales within the SapphireOne application. Once a Client is set up in SapphireOne, it becomes the central repository for all transactions associated with that specific Client.
Look, Modify or create a new Client record
Upon accessing a Client Inquiry, the initial page displayed is a list of Clients already set up, where users can perform the following actions:
- Selection – Once they have selected or highlighted a Client, users have the following choices.
- New – By clicking the
button on the main toolbar, users can initiate the process of creating a new Client’s master record.
- Keyboard Shortcut – Use the keyboard shortcut Control/Command N.
- Look – Select the
Look button to look at or view a Client’s details without modifying them.
- Modify – Users can update a Client’s information by either double-clicking on the Client’s line in the list or selecting/highlighting a client and then clicking the
Modify button.
- Keyboard Shortcut – Or use a keyboard shortcut of Control/Command Look or Modify.
- New – By clicking the
All screens above appear identical as documented above, but data can only be amended when the New or Modify options are chosen.
Client Master Record
It is essential to highlight that when a client is opened and saved in SapphireOne, it is then considered the client’s master record, capturing all relevant and essential information for that particular client. The client’s master record plays a pivotal role throughout SapphireOne, serving as a comprehensive and definitive reference for that specific client. Any modifications or updates made to this master record are permanent and have far-reaching implications across the SapphireOne application. When transactions are carried out for the client, they are based on the most current information available in the client’s master record. Therefore, ensuring the accuracy and completeness of the client’s master record is crucial for maintaining consistency and reliability in all client-related activities within SapphireOne.
Locations for accessing a Client Inquiry
For the convenience of users, the Client Inquiry item has been included in the menus of both Inventory and Job Projects modes. It’s worth noting that regardless of the mode from which a Client Inquiry is accessed, it leads to the same Client Inquiry function within SapphireOne. Therefore, users can access the Client Inquiry function from various modes in SapphireOne. The Client Inquiry function has been documented only in the Accounts mode article in the knowledge base. If you have accessed this Client Inquiry function from Inventory or Job Projects modes in the knowledge base, you can click on this Client Inquiry link to read the article.
SapphireOne incorporates a built-in Contact Relationship Management (CRM) system that diligently monitors all interactions across Clients, Vendors, Job Projects, Assets, Payroll/HR, Employees, and Workbook. It maintains a comprehensive history of all contacts throughout the entire duration of your data file.
The CRM functionality in SapphireOne is specifically designed to efficiently track and manage interactions with various contacts, including Clients, Vendors, Job Projects, Assets, Payroll/HR, Employees, Workbooks, and all contacts. Users can easily record and log various communication activities, such as emails, phone calls, meetings, notes, and actions associated with each contact.
By leveraging SapphireOne CRM, your organisation gains a deeper understanding of past, present, and potential Clients, Vendors, Job Projects, Assets, Payroll/HR, Employees and Workbook leading to analysis of Client buying behavior improved relationship management and customer retention. For example, through analysis of Client buying behavior, an organisation may identify that its Vendor base has not recently supplied a particular SKU inventory.
SapphireOne’s CRM (Contact Relationship Management) is seamlessly integrated into every aspect of the SapphireOne application, providing users with a powerful tool to manage and organise contact details for Clients, Vendors, Job Projects, Assets, Payroll/HR, Employees, and Workbook data. The CRM module efficiently gathers data from various communication channels, including the company’s website and the inbuilt SapphireOne Softphone. It records all outgoing and incoming telephone calls associated with a contact, ensuring a comprehensive interaction history.
The CRM module also manages emails, and it can be integrated with external tools like Mailchimp for monitoring email campaigns to contacts. It tracks when emails are sent, opened, and how many times they are opened. Additionally, all interactions with contacts are automatically recorded, streamlining communication tracking and simplifying follow-up processes.
Users have the convenience of adding actions to contacts, which are automatically populated within the SapphireOne calendar. This feature ensures that important actions and follow-ups are never missed, enhancing productivity and time management.
SapphireOne CRM allows users to attach an unlimited number of documents and digital assets to each contact. Whether it’s contracts, proposals, or multimedia files, this capability ensures all relevant information is readily accessible and organised, making collaboration and decision-making more efficient.
Summarising the Benefits of SapphireOne CRM
SapphireOne CRM delivers enhanced daily support to both Clients and Vendors by providing real-time information, enabling timely decision-making. The core benefits of SapphireOne CRM encompass centralized data management, offering a comprehensive view of contacts, fostering improved customer relationships, facilitating data-driven decision-making, streamlining marketing efforts, and optimizing sales and purchasing processes. Below are the eight core benefits of SapphireOne CRM:
- Centralised Data Management – All contact information is consolidated in one place, ensuring easy access and efficient organisation.
- Comprehensive View of Contacts – Gain a holistic perspective of Clients and Vendors, facilitating a deeper understanding of their needs and preferences.
- Improved Customer Relationships – Build stronger and more meaningful relationships with Clients and Vendors, fostering loyalty and satisfaction.
- Data-Driven Decision-Making – Utilise data insights to make informed decisions, enhancing operational efficiency and business performance.
- Streamlined Marketing Efforts – Targeted marketing campaigns can be devised, ensuring more relevant messaging and increased engagement.
- Optimized Sales and Purchasing Processes – Efficient sales and purchasing workflows lead to improved productivity and revenue generation.
- Identification of Profitable Clients & Vendors – Analyse Client & Vendor data to identify the most profitable partnerships and opportunities for growth.
- Seamless Integration – The CRM is fully integrated across all company departments within a single data file, facilitating smooth collaboration and information sharing.
In summary, SapphireOne CRM empowers businesses by offering tailored services, responsive pricing, and personalized messaging. It creates a cohesive ecosystem where all products and services are linked through contacts for all functions within SapphireOne. This synergy leads to superior supply chain effectiveness and overall operational efficiency, resulting in improved business performance and customer satisfaction.
Client Inquiry Pages
A client inquiry will open on the default details page. What follows is a summary of the extensive functionality accessible from the pages menu within a client inquiry.
- Details – Contains Client ID, Name, Address, Contact, etc., and unlimited CRM contacts.
- More Details – Additional client information (Last Transaction, Loyalty Points, Tax Details, etc.)
- Custom – Features various fields – 12 alpha, 8 Real, 8 Date and Time, 14 Client Custom, and 2 Client Text. These are field headings that can be modified according to the users requirements.
- Current Balances – Includes Balances and Payment Performance accordingly.
- FX Balances – Displays an aged view of transactions, notes, contacts in the client’s home currency.
- Credit Control – An interactive view of aged transactions, balances, notes.
- Terms – Contains Payment Terms, Discount, Payment Defaults, Credit Card Defaults, Internal Credit Control, General Ledger Defaults Controls, EDI Settings, Control Log.
- Transactions – Lists all current transactions.
- History – A comprehensive record of every transaction for the client.
- Sales Analysis – Presents a graphical representation of sales by product or service and allows users to select a date range.
- Sales – Displays sales from Inventory and Job Projects mode, with the option to include history.
- Keywords & Notes – Offers unlimited keywords and notes per client.
- Address: Contains unlimited multi-delivery or billing addresses per client, including post or physical details, marketing, keywords, notes.
- Price Book – Connects to SapphireOne’s and client specific Price Books.
- Period Balances – Records the current period +1, +2, +3, and turnover by period with unlimited history.
- Standing Sales – A complete list of all standard transactions.
- Job Project – Stores all linked Job Projects.
- Email Log – Chronicles all client email interactions with SapphireOne.
- Rating – Can be linked to an electronic campaign where clients rate the company.
- Action – Lists all Client actions.
- Documents – (DMS): Records all documents attached to the client.
- Digital Assets: Unlimited linked digital assets, e.g. PDFs, videos, photographs, JPEGs, RAW files.
Master Defaults – In SapphireOne, the Master Defaults settings available at Utilities > Controls > Master Defaults allow administrators to set default values when creating new clients. These default values serve as a starting point for setting up a new client. However, users retain the flexibility to modify these default values as needed. Along with the default values, additional details specific to the client can also be entered and saved. This ensures that each client’s record is comprehensive and tailored to their individual requirements.
Inactive Clients – Users should be aware that if a transaction is created for an inactive client or vendor, SapphireOne will automatically reactivate them. Inactive clients are not normally displayed. When an inquiry list is on the screen, users must first select the Tools button on the main toolbar and then select the Include Inactive item.
Dictation and Speech to Text Overview
SapphireOne’s Dictation (MacOS) and Speech to Text (Windows) functionalities revolutionise data entry. These features are available for any data entry field and all inquiry screens within SapphireOne. For instance, when a user makes a call via the SapphireOne Softphone, SapphireOne automatically timestamps the contact and phone number. Post-call, users can dictate notes directly into the CRM contact memo field in relation to the stamp.
This functionality is applicable across all Data Entry screens. As examples, when entering a Vendor Invoice (VI), users can dictate memos directly. Similarly, additional lines can be added to the General Ledger account, with each line having a unique memo field. After an employee interview, users can efficiently dictate notes.
Speech to Text and Dictation are powerful tools that SapphireOne and its clients use daily, significantly saving time.
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.
Details Page
Upon initially Looking or Modifying
a Client Inquiry, the Details page is the first one presented to the user. To view different pages, navigate to the Page drop-down menu located on the left-hand side of the SapphireOne Toolbar.
Client Area Data Entry
- ID – The Client ID is the initial item entered in the Client Inquiry screen. It is important to establish ID criteria before entering any Client IDs because they cannot be deleted or reused once saved. The created ID becomes the default and can be modified using Sapphire Tools. The SapphireOne Client ID can consist of up to 12 alphanumeric characters.
- Name – Enter the Client’s name. It can be modified anytime.
- Area – Clients can be grouped for reporting purposes, allowing for convenient organisation based on a rating system such as 1-9 or A-E. The SapphireOne Client Area accommodates alphanumeric characters, giving flexibility in assigning and categorizing clients.
- Class – Assign the Client to a Client Class. This is vital for organising Clients into distinct groups such as Prospects, Inquiry, and Client. The SapphireOne Client Class ID allows for up to six alphanumeric characters.
- Rep – This field is optional. Assign a designated Sales Representative to the Client. For example, Sales Reps may have restricted access, limiting them to view only their assigned Clients. The SapphireOne Rep ID can consist of up to six alphanumeric characters.
- Company – By default, SapphireOne automatically enters the Company ID that the user is logged into when creating this new Client record. The SapphireOne company ID is comprised of up to eight alphanumeric characters.
- Job Project – A Client can be linked to a Job Project, which is an optional field. The SapphireOne Job Project ID allows for up to 12 alphanumeric characters.
- Department – It is optional to enter a department, and the decision may depend on various factors such as the requirement to generate reports at the department level. The SapphireOne Department ID can contain up to eight alphanumeric characters.
- Carrier – If necessary, you can enter a carrier for the Client. The data entry field is highlighted with a light blue background, allowing the user to directly input the carrier ID or utilise wildcards to replace parts of the carrier ID. Sapphire One will automatically insert the carrier ID into any transactions generated for this Client. Additionally, accurately entered addresses will be displayed on Google Maps.
- Open Item & Active Check Boxes – SapphireOne automatically sets these checkboxes as active. The Active checkbox can be changed to inactive by un-ticking it, but only if the Client has a zero balance. It is not recommended to modify the selection of these checkboxes without consulting the support staff. If you wish to make either of these checkboxes inactive, please contact our support staff at 02 8362 4500 for assistance and guidance.
Paperclip Management Saves Time with Easy File Attachment
The SapphireOne Document Management System (DMS) features a convenient Paper Clip button on all data entry and inquiry screens. This enables users to attach relevant documents or files to every transaction or record. The system also includes a dedicated page for managing documents related to a specific transaction or record, providing robust version control of the attached documents.
The color of the paper clip serves as a visual indicator of the status of the attached documents. A red paper clip indicates that there are no documents currently attached to the transaction or record, while a green paper clip indicates the presence of one or more attached documents. Additionally, the word “Items” is preceded by the number of attached documents, providing a clear and concise representation of the current status.
SapphireOne’s Document Management System is highly versatile and can accommodate a wide range of document types, including Adobe Acrobat, spreadsheets, word processing documents, photo files, JPEGs, CSV files, HEIFs, and MP4 files. With the ability to store an unlimited number of documents for an indefinite amount of time, the system provides users with a comprehensive and efficient solution for managing all their important files and documents.
Master Defaults
In SapphireOne, users have the flexibility to control the size of individual documents and determine where they are stored through the Master Defaults settings. These settings can be accessed by navigating to Utilities > Controls > Master Defaults > System Page.
Within the Documents area of the SapphireOne page, there is a Document Size Limit setting with a default size of 10 MB, which can be adjusted as needed. Additionally, users can choose to store the documents either as part of the data file or as separate files, by selecting the appropriate option from the two radio buttons provided.
To attach a document to a transaction, simply click on either the or
Paperclip button. The Document List window as seen below will be displayed allowing the the user to select the desired file to attach.

How to Attach Documents Using SapphireOne Paperclip
SapphireOne also provides users with the convenient Drag & Drop functionality to attach documents. To use this feature, simply drag a document from your local computer into the Document List screen and it will be attached automatically. This streamlined process saves time and effort and makes it easier to manage your important files and documents within SapphireOne.
If SapphireOne detects that the document name already exists, a pop-up will be displayed alerting the user. Alternatively, the user can also select the
If SapphireOne detects that the document name already exists, a pop-up will be displayed alerting the user. Alternatively, the user can also select the Plus button to select a document to upload from the local computer.
SapphireOne’s document management system provides users with the ability to easily manage their attached documents. After a document has been attached, the user has the option to rename it by right-clicking on the file and selecting Rename This feature is useful for maintaining consistency in document names across all records and helps to keep the system organised and efficient.
Documents Area within Document Management System (DMS)
- Open
– By clicking on this button, the document will be opened for viewing, allowing users to review its contents without having to leave the SapphireOne system. This feature provides a convenient and streamlined way to access and review important documents within the context of the larger document management system.
- Update
– When this button is selected an alert is displayed allowing the user to import a new version of a highlighted document, enabling version tracking. After selecting a new version, the user enters a version number. The latest version becomes available, with previous versions accessible in the History area. The updated document remains linked to associated transactions.
- Scan
– This option in SapphireOne provides users with the ability to scan a document directly into the data file and link it to a transaction. This feature requires access to a local or network scanner, and the appropriate scanner and software must be installed on the local machine or network. By using the Scan option, users can quickly and efficiently digitise physical documents and associate them with the relevant transactions within SapphireOne.
- Save
– This button in SapphireOne allows users to save the currently highlighted document to disk. This feature provides a convenient way to export a copy of the document for backup or further use outside of the SapphireOne system. By clicking the Save button, users can easily access a digital copy of their important documents and ensure that they are properly preserved and accessible.
- Link Documents
– With SapphireOne, users have the ability to link a highlighted document to one or more transactions within the data file. To do this, the user simply clicks the “Link” button, which will bring up an alert allowing them to make their selection. This feature provides a convenient way to associate important documents with multiple transactions, ensuring that all relevant information is easily accessible from one central location. For more information about linked documents, refer to the Links Area documentation provided by SapphireOne.
- Link Existing Documents
– SapphireOne provides users with the ability to link existing documents in the data file to the current transaction or record. To do this, the user simply clicks the Link Existing button, which will bring up an Alert allowing them to choose from a list of available documents. This feature provides a convenient way to associate existing documents with additional transactions, ensuring that all relevant information is easily accessible from one central location. For more information about linked documents, refer to the Links Area documentation provided by SapphireOne.
- Delete
– This option in SapphireOne allows users to remove the currently highlighted document. By clicking the Delete button, the selected document will be removed from the system, providing users with a simple way to manage their attached documents and ensure that only relevant and up-to-date information is stored within the system.
- Plus
– SapphireOne includes a search function that makes it easy for users to select a document saved on their local computer. This feature provides a convenient way to quickly locate and attach the desired document, streamlining the process of adding and managing important files within the SapphireOne system.
Details Area within Document Management System (DMS)
The Details area within SapphireOne’s Document Management System (DMS) provides users with additional information about the selected document. When a document is selected in the Documents area, the Details area will automatically display the title of the document and the type of file. This information helps users to quickly identify and manage their important files and documents, providing a more efficient and organised system for document management.
Notes Area within Document Management System (DMS)
The Notes area is for entering any notes related to the document. The user can select the green clock button to create a time and date stamp for every note added.
The Notes area will also keep an automatic user log when any changes are made to the document. For example, if the document is renamed or new links are created. SapphireOne will record the date, time and user that made the modifications.
Document Details Area within Document Management System (DMS)
The Document Details area within SapphireOne’s Document Management System (DMS) provides additional information about the selected document. This area automatically displays information such as the date and time the document was added, the document number, and the user who added the document. This information helps users to quickly understand the context of the selected document and provides a comprehensive history of the document’s status and interactions within the system. The Document Details area is a valuable resource for managing and tracking important documents within SapphireOne.
History Area within Document Management System (DMS)
The History area within SapphireOne’s Document Management System (DMS) provides a record of the complete version history of the selected document. SapphireOne tracks all version changes and automatically displays the document’s history in this area.
As new versions of the document are imported using the button, the History area will be automatically updated, ensuring that all previous versions of the document are recorded and available for viewing. This enables users to access the most recent version of the document, while still maintaining a complete history of all versions.
The History area provides a valuable resource for tracking the evolution of a document and understanding how it has changed over time. By having a complete record of the document’s history, users can easily review past versions and understand the context of the changes that have been made.
Links Area within Document Management System (DMS)
The Links area within SapphireOne’s Document Management System (DMS) is used to link documents to specific transactions or areas within SapphireOne. This area provides a comprehensive view of all linking information related to the document, including any functions used to import the document into SapphireOne.
By linking documents to transactions and areas within SapphireOne, users can easily associate important information and files with the relevant transactions, providing a more organised and efficient system for document management. The Links area is a valuable resource for understanding the relationships between documents and transactions within SapphireOne.
To add additional links to a document in SapphireOne, follow these steps:
- Select/highlight the document you wish to link.
- Click the
Link Document button.
- The Files pop-up window will be displayed.
- From the File drop-down menu, select the item you want to link the document to.
- In the Value data entry field, enter the necessary details (ID).
Note that the Value data entry field has a light blue background and is searchable by entering the wildcard symbols ‘?’ or ‘@’, making it easier to find the information you need. By linking documents to specific transactions and areas within SapphireOne, users can create a more organised and efficient system for document management.

Updating a Document within Document Management
The process for updating a document in SapphireOne is straightforward:
After clicking the “Update” button in SapphireOne, the user will be asked to confirm if they would like to import a new version of the document:
- Confirm that you wish to import a new version of the document by selecting Yes.
- The user will then be prompted to choose the updated document to open.
- After selecting the updated document, a secondary dialogue will appear, asking the user to enter an alphanumeric value for the new version.
- Enter the desired value for the new version and select OK
By following these steps, SapphireOne will replace the previous version of the document with the updated document. It will also maintain a complete record of all previous versions in the History area. This process ensures that the most up-to-date information is always readily accessible within the SapphireOne system.
Document Management using SapphireOne Documents Inquiry
In addition to SapphireOne’s Document Management Paperclip functionality, SapphireOne Documents Inquiry function in Workbook Mode provides users with a centralised repository of all documents and files stored within the SapphireOne data file. This function gives users the ability to add new documents, modify, view, or delete existing documents from within the Documents Inquiry screen.
Any revisions made to a document within the Documents Inquiry screen will be automatically updated across all areas where the document is linked within SapphireOne. Similarly, any modifications made to documents within the SapphireOne Paperclip Document List window will be reflected within the Documents Inquiry window.
For example, if a document is renamed within a transaction Paperclip Document List screen, the updated document name will be reflected when viewing the document in the Documents Inquiry screen.
You can learn more about SapphireOne Documents Inquiry functionality within the Documents Inquiry article.
Document Control within Document Management
In this example, we have an inventory item with documents attached, such as installation instructions and a packing checklist. The item is added to a sales order, manufactured, shipped, and the job is completed. SapphireOne’s Document Management Paperclip functionality allows for easy attachment and access to all relevant documents throughout the entire process, from sales order to completion. This improves efficiency and helps ensure all relevant information remains consistently available and up-to-date.
A year after the completion of the job, a revision of the inventory item is made, along with updates to its associated Documents (DMS). To keep the information organised and up-to-date, it is not necessary to create a new inventory item for the revision. Instead, the documents and files can be easily updated using SapphireOne’s DMS file that are attached.
By using the Update button within the DMS, users can import a new version of the document and SapphireOne will automatically keep track of all version changes, ensuring that the most recent information is readily available. This process saves time and effort by allowing users to simply update the documents and files, rather than creating a new inventory item for each revision.
In SapphireOne, when referring back to the original completed sales client invoice or job projects client invoice, the associated documents and files will be displayed in their original state or as they have been updated. The user has the option to view the documents and files as they were at the time of completion or as they currently are, providing a comprehensive and accurate record of all relevant information.
In the screen shot above, both the current and historical documents are attached to the inventory item. As a SapphireOne user, you have the ability to edit the list and choose to delete the historical document by simply selecting the Minus button.
Additionally, you also have the ability to modify the existing document, keeping a log file of each and every time the document has been revised. This ensures that a complete and accurate record of all revisions to the document is maintained, allowing you to easily reference the most recent version or any previous versions as needed.
The ability to manage both current and historical documents, as well as the option to modify and delete them, provides users with a flexible and efficient solution for document management within SapphireOne.
Inactive Record Management
In SapphireOne, all records are initially created with the Active checkbox selected on the first page, typically the details page, of the record.
In SapphireOne, designating a record as inactive will result in its removal from the standard inquiry list. This principle applies across various categories in SapphireOne, not just limited to Clients and Vendors, which are used as examples in this article. For instance, if there is a former employee, you can mark them as inactive within SapphireOne if they are no longer employed by the company.
Deleting records is prohibited in SapphireOne for the purpose of maintaining an audit trail. Instead, you have the option to mark a Client, Vendor, or any other record as inactive. This action ensures that the record no longer appears in standard inquiries while still retaining its information for future reference.
How to Make a Record Inactive in SapphireOne
To make a record inactive in SapphireOne, follow these steps:
- Access the record in SapphireOne.
- De-select the Active checkbox on the first page usually the Details Page.
- SapphireOne will display a warning to the user if the deletion is not allowed.
How to View Inactive Records in SapphireOne
To access the Include Inactive function when viewing a list of items in SapphireOne, the user has a number of options as follows:
- Tools Menu – Select the small arrow located just to the right of the Tools button
. This will display a drop-down list with the Include Inactive function on it if it is available.
- Options Menu – Go to the options menu which is one of the menu selections at the top of the screen:
- Find – Select the Find option or use the keyboard shortcut Command/Ctrl F and SapphireOne will display the Find pop-up as seen below.
- Drop down menu – From this pop-up select the All Records option.
- Finding – Select the Find button at the bottomof the screen. SapphireOne will now include all active and inactive records within your list on screen..
Grouping Area Data Entry
The Grouping Area on the Client Inquiry screen includes three default tags: Tag, Tag2, and Tag3. Users have the flexibility to customize and rename these tags according to their specific requirements. To learn more about managing these tags, please click on the toggle below.
Note that many of the Tag Headings are user-configurable, so you can rename them to suit your needs.
To rename Tag Headings, follow these steps:
- Navigate to Utilities > Controls > Master Defaults.
- Select the appropriate function’s page.
- Click on the Tag Headings menu to open it.
- Double-click on the heading you wish to rename.
- Enter the new name for the heading and click OK.
- To create customised tag drop-down menus, simply enter a new item that is not currently on the list and then tab away. SapphireOne will prompt you to add the new tag to the list.
- To remove a tag, hold down the Control or Command key and select the tag you want to remove. You will be asked to confirm its removal from the list.
SapphireOne has a tag named HOLD integrated into it. When this tag is selected, the transaction cannot be posted until the HOLD tag status is removed or changed to a different status other than HOLD.
The three tags (Tag, Tag2, and Tag3) are also visible as columns on the right-hand side of the screen when viewing the list of Clients. These tags serve the purpose of reporting and reconciling Client details.
Additionally, when executing a Quick Report in SapphireOne, these tags are included as part of the Master Table, making them available for use in all SapphireOne report writers. This means that you can utilise these fields while generating Quick Reports, giving you the flexibility to include the tag information in various custom reports and data analysis. These tags provide further organisation and categorisation options for reporting purposes, allowing you to have a comprehensive view of Client data based on the tags assigned to each Client record.
Address Area Data Entry
In the upper section of the Address area, you will find a drop-down menu that provides three options for automatically used addresses for the Client. By default, SapphireOne displays the Standard address option.
Furthermore, there are provisions for entering Statement or Invoice addresses by selecting from the drop-down menu. It’s important to note that these addresses are interdependent on each other, meaning changes made to one address may affect the others. Therefore, updating the Standard address, for example, could impact the Statement and Invoice addresses associated with the Client.
It’s important for users to be aware that the addresses entered in SapphireOne will be automatically included in any hard-coded reports within the software. This means that the addresses will be printed or displayed as per the predefined format of the reports.
Address Fields and Features in the Standard Address Area
- Copy Button – This
button enables users to transfer Postal Address details to the Physical Address area in the Standard Address selection on the previous page. It also allows for the copying of the Invoice Mailing address to the Invoice Delivery address on the Invoices address screen displayed above.
- Standard Address – Within the Standard address field area, the Country field is pre-configured, providing users with the option to select the required Country code. This enables users to easily specify the country associated with the standard address for accurate and standardized client data management.
- Postcode field – The Postcode field in the Standard address area is designed to accommodate up to eleven characters, meeting current international standards. This allows users to enter postal codes or ZIP codes of varying lengths, ensuring compatibility with different countries’ addressing systems.
- Delivery Instructions – The Standard address field area in SapphireOne includes a designated space for entering specific Delivery Instructions for each individual Client. This allows users to provide any special instructions or details related to the delivery of goods or services to the Client’s location.
- Other Data Entry Fields – The Address area in SapphireOne also includes provisions for storing additional contact information as follows.
- Telephone Numbers – This includes fields for the main Telephone number & the Mobile Number.
- Email Address – The client’s email address is crucial for seamless email communication, particularly for sending remittances and invoices. Multiple email addresses can be entered by using a comma (,) without spaces between them. To learn more about setting up emails and understanding the email procedures in SapphireOne, please refer to the knowledge base article dedicated to Email procedures for detailed instructions and guidance.
- E-Statements – Within SapphireOne, there is a dedicated field to capture the Email address specifically designated for statements. This field allows users to input the email address to which electronic statements will be sent..
- URL – The provided area within SapphireOne’s Address section includes a space for storing the Client’s URL (Uniform Resource Locator), also known as the website address. Users can input the relevant URL associated with the client in this field.
- SpliceCom – If the SpliceCom telephone system is installed, is installed and integrated with SapphireOne, users can take advantage of a convenient feature. By clicking the telephone
button associated with a contact’s phone number, SapphireOne will prompt the SpliceCom system to initiate a call to the entered number.
SapphireOne Mapping Feature – Apple/Google Maps
SapphireOne has incorporated functionality that allows users to obtain a map view from a physical address record. To access this feature, click on the underlined “Physical Address” label in the Address Area. This feature is available throughout SapphireOne, including in the Sapphire Web Pack and the Sapphire Custom Web Pack. With this capability, users can obtain a visual representation of the physical location associated with a contact’s address, which can be helpful for planning and logistics purposes.
Whether using a mobile device, tablet, or desktop computer, the map view feature in SapphireOne remains accessible, providing users with a consistent experience regardless of their chosen device or platform.
Contacts Area
The Contacts area displays a list of Client Contact Details, limited to contacts linked to the currently selected Client. To Look or modify Client contact details, simply double-click on the Client in the contact details area. This will open up the Client Contact Details page as a new screen.
There are four buttons above the client contact list for managing the Contact list as follows:
- New – Selecting the
New button will initiate the creation of a new contact, bringing up a new screen to allow entry of all contact details. Users must complete all required fields. Any contacts created here under the Client Inquiry function will automatically be linked to this Client.
- Delete – Highlighting a contact and selecting the
Delete button will remove the selected contact.
- Link – This
Link button is for updating contact links. It is strongly recommended that new contacts be added from within the function they are to be linked to, in this case, a Client Inquiry. This will automatically create the link to the client being modified.
- Full-Screen – This
Full-Screen button allows users to view the list of contacts in full-screen mode, which is beneficial when viewing large contact lists.
There is a Contacts item on both the Inquiry Pallet drop-down menu, and the General drop-down menu when using Workbook mode. This Contact item in Workbook mode displays all contacts within the data file. Any contacts created there must be manually linked.
Importing Contacts into a Client
In this documentation, while the item mentioned is Vendors, it’s important to note that any of the other seven items (Clients, Projects, Employees, Assets, Contacts, Client Address, or Vendor Address) mentioned can also be used in place of Vendors for the importing context. All of the items are in fact inquiries automatically performed when relevant item is selected from the drop down list.
The process of importing contacts involves the steps as follows.
- Commencing – Begin by clicking on the
Import Contacts button.
- Link Contact pop up – Clicking on this will prompt the appearance of the Link Contact pop-up. Within this pop-up, you will find a drop-down menu providing a selection of eight Inquiries to choose from, which are as follows:
- Inquiries – Clients, Vendors, Projects, Employees, Assets, Contacts, Client Address, or Vendor Address. Each of these Inquiries contains a number of items within them, allowing users to select a specific item from the selected inquiry.
- Inquiries – After selecting the desired Inquiry from the drop-down menu, proceed to enter the exact ID of the item you wish to access into the light blue data entry field. Alternatively, you can utilise the wildcard entries @ and ? to perform a standard search within SapphireOne. Based on your selection from the drop-down menu, SapphireOne will generate a list of items to choose from, considering the search criteria you entered.
- For example, if you have chosen Vendors from the drop-down list, SapphireOne will display a Relate screen with a list of Vendors based on the specific search function criteria you provided. This enables you to easily access the relevant items within the selected Inquiry, streamlining the process of working with contact information in SapphireOne.
- Item Selection – After choosing the desired item from the Link Contact pop-up, simply double click on your selection or click on the
button. This action confirms your selection takes you to to the next step, the Select Contacts screen
- Select Contacts Screen – For the selected Vendor, sapphire one will now display a list of contacts to choose from who are linked to this Vendor.
- Checkboxes – The user will find that there is a checkbox at the end of each line for a contact. Select these check boxes as required and then select the
Button. the checked contacts will be entered into the required contact area for the selected Vendor.
- Checkboxes – The user will find that there is a checkbox at the end of each line for a contact. Select these check boxes as required and then select the
It is possible to add one or more contacts simultaneously; however, it is essential to note that importing these contacts may lead to duplication.
More Details Page
The More Details Page serves as a comprehensive repository of internal credit information and additional details pertaining to the Client. This page provides valuable insights and in-depth information, allowing for a more thorough understanding of the Client’s profile and credit history.
Last Transaction Area
This area is non-editable and automatically populated with details extracted from various sections of SapphireOne. It includes essential information such as the amount of the Last Receipt, the date of the Last Transaction, and the most recent modification date of the Client details. Users cannot directly interact with this area, as it serves as a summary of the latest activities and updates related to the Client.
Loyalty Points Area
The Loyalty Points Area is a non-editable section that automatically displays and updates details extracted from the client’s current loyalty points. Users cannot directly modify the information within this area, as it serves as a summary of the Client’s loyalty points status. It provides an at-a-glance view of the accumulated loyalty points without requiring manual input from the user.
Tax Details Area
- Tax No – This is the Tax Number, which corresponds to the Client’s Australian Business Number (ABN). The Tax No heading is underlined, and clicking on it triggers SapphireOne to launch the default web browser and direct the user to the ABN lookup service. In this process, SapphireOne automatically enters the Tax Number as provided in the software and checks its validity and active status. It’s important for the user to input the number without spaces, but once they move away from this data entry field, SapphireOne will automatically insert the necessary spaces for them. This functionality streamlines the process of validating and managing ABNs within SapphireOne.
- Tax Code – Users can input the Tax Code for the Client. For instance, in Australia, the Tax Code is typically represented by a single character, such as S for 10% Goods and Services Tax (GST). Users should enter the appropriate code based on the applicable tax regulations in their region. This allows SapphireOne to accurately calculate and apply the relevant tax rates to the client’s transactions.
- Tax Rate – The Tax Rate displayed in the this area is dependent on the Tax Code entered by the user. SapphireOne will automatically populate the applicable tax rates based on the settings configured in Utilities Mode. It’s important to note that for regular usage, these rates should not be altered by the user. The predefined rates are designed to ensure accurate and consistent tax calculations, maintaining compliance with relevant tax laws and regulations. Any changes to these rates should be made with caution and only in specific circumstances where it is necessary and authorised.
- Exempt Checkbox – The Exempt checkbox serves as a useful feature for Australian companies that engage with overseas Clients. When selected, it indicates that overseas Clients will be exempt from any Australian tax charges. This feature is particularly relevant in cases where transactions involve Clients located outside Australia, and it ensures that no Australian tax is applied to those specific dealings.
- Exempt on Special Rules Checkbox – This checkbox is directly linked to the Periods and Taxes page within a Company Inquiry. In this context, the checkbox is associated with the tax exempt area within the tax codes section. When this checkbox is selected, SapphireOne will use the data entered into that area to establish a tax-exempt setup for special rules related to specific periods or taxes.
- Operation – By checking the Exempt on Special Rules checkbox, SapphireOne implements the tax-exempt configuration based on the data provided in the designated area. This ensures that special rules pertaining to tax exemptions are applied as intended for the specified periods or taxes, streamlining tax management and compliance for specific scenarios.
- Use Checkbox – This Checkbox functions as an instruction to SapphireOne, allowing it to override the tax settings specified in a Company Inquiry and instead apply the tax rate manually entered in the Tax Code data entry field.
- Operation- This feature provides users with the flexibility to customise tax rates for specific transactions or scenarios that require deviations from the standard tax settings defined in the Company Inquiry. When the Use Checkbox is selected, SapphireOne acknowledges the manual entry in the Tax Code field and applies the corresponding tax rate accordingly, ensuring accurate and personalised tax calculations as needed for individual cases.
- Price Round to Checkbox – This checkbox provides the option to round prices to a specific number for each individual Client. By selecting this checkbox, users can enable price rounding for the particular Client in question.
- Data entry Field – This Data Entry Field allows users to input the desired rounding figure or amount. When a value is entered in this field, SapphireOne will automatically round the prices for that specific Client to the specified figure or amount, ensuring consistency in pricing and simplifying transactions.
Miscellaneous Area
- Facsimile No – This field is designated for entering fax numbers. Users can input fax numbers associated with the respective entity or contact within this section. It serves as a specific location to store and manage fax contact details for easy reference and communication purposes.
- Default GL Code – This field allows the recording of a Default General Ledger (GL) Code account number. When a Default GL Code is set for a Client here, it will automatically populate the GL Code field for any Client Invoices entered in Accounts & Inventory mode. This feature streamlines the invoicing process by automatically applying the specified GL Code to relevant transactions, ensuring accurate accounting and consistent financial reporting.
- Currency – The Currency drop-down list allows the selection of the currency in which the Client conducts their trades. This drop-down menu is available exclusively during the creation of a NEW Client. However, after a single transaction has been executed against this Client, the Currency drop-down menu will be permanently removed. Therefore, it is essential to choose the appropriate currency during the initial setup to ensure accurate currency management for all subsequent transactions with the Client.
User Defined Area
Users have the option to rename these field headings according to their preferences. This can be accomplished by navigating to Utilities / Controls / Master Defaults / Client, where custom heading names can be assigned to each of the four user-defined fields. This feature empowers businesses to tailor the data entry and retrieval process to suit their unique needs, maximising the utility of the software and streamlining data management tasks. This area provides the flexibility to set up four custom fields based on specific requirements.
The first two fields are indexed, enabling them to appear in the Find Command/Ctrl F screen, facilitating swift searching for secondary data. Additionally, all four fields can be queried using the Detailed Query Command/Ctrl Y, allowing for comprehensive and detailed data analysis.
Serial Shipping Container Code (SSCC) Area
Area consists of simple data entry fields that are used for capturing relevant SSCC information. These fields serve as a means of recording and storing SSCC data associated with specific shipping containers or packages.
- Number – In the Number field, users have the option to set up a starting number by directly entering the desired value. This feature allows for manual configuration of the initial number from which subsequent numerical sequences or series will commence.
- For instance, if users wish to start numbering a series of items, transactions, or documents from a specific number, they can input that starting number directly into this field. The software will then use this specified value as the beginning point for generating subsequent numbers automatically.
- Prefix – In addition to setting up a starting number, users have the option to add a Prefix to the number if required. The Prefix is a string of characters that will be appended at the beginning of the generated number.
- Suffix – Users can also include a Suffix to the number if needed. The Suffix is a sequence of characters that will be added at the end of the generated number.
Addition/Deduction Area
- Ignore Levy Rules Checkbox – This area features an important functionality called the Ignore Levy Rules checkbox. By selecting this checkbox, SapphireOne will be instructed to disregard any levies that have been configured for this specific Client. This means that the Client will be exempt from any levies set up in SapphireOne, and these levies will not be applied to transactions involving this Client.
- Ignore Royalty Rules – This checkbox in the enables users to direct SapphireOne to exclude any royalty rules that have been configured for this specific Client. By selecting this checkbox, SapphireOne will not apply any royalty-related calculations or charges that have been set up in the system to transactions involving this client.
- Pallet – The Pallet Data entry field is closely integrated with the web pack marketing function offered by SapphireOne. For more detailed information about this feature and its extended capabilities, it is recommended to contact SapphireOne support directly at 02 8362 4500. The support team will be able to provide comprehensive assistance and insights into how the Pallet function operates in conjunction with the web pack marketing feature, ensuring a better understanding and utilisation of the system’s capabilities.
Periodic Invoice Area
Overview
This area is a crucial feature in SapphireOne that efficiently handles scenarios where customers make repeated purchases of the same items on a daily or weekly basis. These recurring sales result in multiple Sales Client Invoices (SCI) being generated over time. To simplify the payment process, payment terms are set up for the Clients on a recurring basis, often based on specific periods.
SapphireOne’s periodic Invoicing functionality plays a pivotal role in streamlining the management and processing of these recurring transactions. It automates the generation and tracking of invoices within the defined payment periods, allowing for seamless and consistent invoicing and payment collections. By using periodic invoicing, businesses can optimize their invoicing process, improve cash flow management, and provide a convenient and predictable payment schedule for their Clients. This feature proves especially beneficial for businesses with customers who make regular and ongoing purchases on a fixed payment cycle.
Setting Up Periodic Invoicing
To configure a Client for Periodic Invoicing, users need to enter relevant data into the Periodic Reference area within the Client’s Master Record. Once the data entry fields are set up, SapphireOne will generate all future invoices for that Client as periodic invoices.
In this Periodic Invoice Area, it’s worth mentioning that each periodic invoice will be assigned a unique number, which can be viewed in a Company Inquiry for easy reference and tracking.
When using the Periodic Invoice function from Inventory mode, only invoices marked as periodic will be displayed. However, it’s important to note that these periodic invoices can still be treated as normal invoices if necessary, providing the flexibility to handle them like regular transactions when required.
By leveraging the Periodic Invoice Area, businesses can streamline invoicing processes for recurring sales, ensuring smooth management of periodic invoices while maintaining the option to treat them as standard invoices if needed. This feature is especially beneficial for Clients with regular payment schedules and repeated purchases.
Periodic Invoicing Data Entry
- Period – This field provides various options for setting the frequency of invoices generated for a Client in the Periodic Invoice Area. Users can choose from the following options, Daily, Weekly, Fortnightly (Every two weeks), Monthly or None.
- None – If this option is selected, the invoices will still be generated periodically, but they will require a manual entry for the invoice date. In other words, SapphireOne will mark the invoices as periodic, but the user will need to manually specify the date for each individual invoice.
- Output – This field is a valuable feature designed to facilitate efficient invoice identification and processing within the Periodic Invoice Area. It automatically assigns a predetermined internal reference number to each invoice generated through periodic invoicing.
- Details – By using the Output field to generate unique internal reference numbers for the periodic invoices, users can streamline their invoicing workflows and easily distinguish one invoice from another. This internal reference number serves as an identifier that aids in record-keeping, tracking, and management of the periodic invoices.
Invoice Reference Area
This area within the Clients section allows for the assignment of a unique prefix and number to each Client. This functionality facilitates the automatic generation of invoices with the correct prefix and sequential number, streamlining the invoicing process and ensuring a consistent and organised approach.
For instance, if the client is IKEA, invoices can be automatically generated with reference numbers like IKEA0001, IKEA0002, IKEA0003, and so on. The system will increment the number accordingly as each new invoice is generated for the client.
By utilising the Invoice Reference Area, businesses can create customised invoice references for each Client, enhancing professionalism, and making it easier to manage and track invoices for different clients. This feature saves time and effort in invoice generation while also providing a clear and uniform system for organising invoice records.
General Message Area
This General Message Area allows users to enter comments or information about a specific Client. This message will automatically trigger an alert when a new transaction is created for that Client. By entering relevant details in this area, users can provide important notes or reminders about the Client, ensuring that any pertinent information is brought to the attention of employees processing transactions for that Client.
When the General Message Area is left empty, no alert message will be displayed during transaction creation for that Client. However, by utilising this feature, businesses can effectively communicate critical information related to the Client, enhancing communication and promoting better customer service. The alert system helps users stay informed and make well-informed decisions when interacting with the Client’s transactions, improving overall efficiency and accuracy in Client management.