Client Overview
SapphireOne’s Client is the foundation for all revenue base with in your SapphireOne application. Once set up, the Client will be the repository for all transactions for that particular Client whether that be Inventory Transactions, Job Project Based Transactions or Account Transactions. All interactions will be monitored with the inbuilt Client Relationship Management (CRM) within the SapphireOne Client, and a complete history of all Transactions is stored for the life on the data file.
SapphireOne has a total of 22 unique pages within a Client Inquiry. Each one of these pages has a very sophisticated interface relating to a particular heading of these 22 pages. The 22 pages are as follows. First we have the Details page where we store the Client ID, Name, Address, Contact Details, etc. and unlimited CRM contacts. When the user moves to the More Details page, there is additional information of the Client including Last Transaction, Loyalty Points, Tax Details, Miscellaneous, User Defined, General Message, etc. The next page is Custom page containing 12 alpha fields, 8 Real fields, 8 Date and Time fields, 14 Client Custom fields and 2 Client Text fields. In Current Balances we have the Balances and Payment Performance. FX Balances presents an aged view of transactions, notes and contacts in the Client’s home currency. Credit Control is an interactive view of aged transactions interactive you with balances and notes. The Terms page contains Payment Terms, Discount, Payment Defaults, Credit Card Defaults, Internal Credit Control, General Ledger Defaults Controls, EDI Settings and Control Log. Transactions provides a list of all current transactions. History provides a complete list of every single transaction for the life of the data file from the day it began for that client. Sales Analysis provides a graphical interpretation of sales by product or service and an interactive ability to pick a date range. Sales displays all sales from Inventory and Job Projects mode, and it also has the ability to include history. The Keywords & Notes page presents unlimited keywords per client and unlimited notes per client. Addresses has unlimited, multi-delivery or billing addresses per client, which is the same as page one and includes post or physical contact details, marketing, keywords and notes. Price Book provides a link to SapphireOne’s Price Book and each Price Book that is set up for a particular client. Period Balances page records the current period +1, +2, +3 and turn over by period unlimited history. Standing Sales is a complete list of all standard transactions for the client. Job Project are repository for all Job Projects linked to your client. The Email Log page is a complete history of all email interaction from within SapphireOne to your client. Rating can be linked to an electronic campaign where we have our clients rate us. Action is a complete list of all actions for this client. Documents (DMS) is a record of all attached documents to this client. Digital Assets provides unlimited digital assets. These may be PDFs, videos, photographs, JPEG, RAW, and HEIC any type of digital asset attached to your client.
SapphireOne Client Relationship Management (CRM) is fully integrated into every aspect of the SapphireOne application and collects Client data from a range of different communication channels, including a companies website, telephone, email and marketing materials. For example, feedback from technical support calls can help provide direction for marketing products and services to that particular client in the future.
SapphireOne CRM gives businesses the ability to learn more about past, present and potential Clients in order to improve customer relationships and retention. As an example, through the analysis of Client buying behaviour, a company might be able to determine that a client base has not been recently purchasing a particular SKU inventory. After analysing client data in SapphireOne CRM, the company can use this opportunity to better focus their marketing strategy to this subset of clients.
Client Benefits of SapphireOne CRM
With SapphireOne CRM clients are better supported on a daily basis with real-time information in a timely manner. Below are the eight core benefits of SapphireOne CRM.
- Identifying a businesses most profitable clients.
- Fully integrated across all companies and departments within the one data file.
- Superior sales team effectiveness and efficiency.
- Targeted and responsive pricing.
- Tailored products and services.
- Improved client services.
- Personalised targeted marketing.
- All SapphireOne products and services linked by both Vendors and Clients.
Dictation and Speech to Text Overview
SapphireOne’s implementation of both Dictation (MacOS) and Speech to Text (Windows) is a game changer for data entry. Any data entry field you can type into using a keyboard can use this feature.
You can also use this functionality on all inquiry screens within SapphireOne. For example, the user is in a Contact within a Client. They may have made a phone call to that particular client using the Softphone technology. Consequently, this will automatically date and time stamp both the contact and the phone number you called.
As soon as the call is completed, the user has the ability to use Speech to Text (Windows) or Dictation (MacOS). They can dictate into the memo field of the CRM contact, adding as much description as they require.
Dictation and Speech to Text Procedure
This functionality applies across every single Data Entry screen. For example, the SapphireOne user is entering a Vendor Invoice (VI). Additionally, you may want to add a memo within the Vendor Invoice (VI). The user can utilise the tool and simply dictate the memo.
Another example is if the user wants to add additional lines to the General Ledger account, within each General Ledger account. When the user is completing data entry using a General Ledger, there’s always a unique memo field for each GL account line.
The user can then utilise this feature to quickly add the information they need to add. Alternatively, you may have an interview with an employee. After the interview process is completed, the user can then make notes about the employee.
Speech to Text or Dictation is an extremely powerful tool. It is something that we at SapphireOne, as well as our clients, utilise daily. It is a massive timesaver.
Client Inquiry Overview
SapphireOne’s Client Inquiry screen is the single repository for all master Client information. There are many additional pages available in a Client Inquiry.
When opening a Client Inquiry the user is displayed with a list of the basic details of each Client, including ID, Name and Address as well as the Telephone number and Main Contact.
To obtain full details for the Client you can Look by selecting a Clientand then selecting . To Modify a Client item, you can double click on the Client, you can click on the Client once and select the
icon or use keyboard shortcut. Both screens look the same but only by selecting Modify can you amend the data. To create a new Client item, click on the New icon or use the keyboard shortcut.
- In other areas of the SapphireOne program whilst entering data you may alter Client Details which are created by the default setting and they will not become a permanent part of the Client Record. ANY alterations you make here will become a permanent part of the Client record and will appear in any screens with Client Information subsequently.
- If a Transaction is created for an Inactive Client or Vendor SapphireOne will re-activate them automatically. SapphireOne will not display Inactive Clients unless the user selects ‘Show Inactive’ in a query.
Choosing between a Standard Inquiry and a Custom Inquiry Screen
All inquiry screens in SapphireOne offer the option to customise the list of items displayed on the page. This feature, known as Custom Inquiry, allows you to select the data fields to be shown and the order in which the columns of data appear across the screen. Although a client list is used as an example below, any type of inquiry can be customised within SapphireOne.
The list below represents the standard inquiry list, displaying a basic set of data fields for each client record:
Swap to Custom Inquiry
When you select the ‘Swap to Custom Inquiry’ button in the lower left-hand corner of the screen, SapphireOne will display the default Custom Screen, as shown below. This Custom List screen provides the user with two main options for organising the data display:
- To add or remove the data field columns displayed on the screen, click the ‘Setup’ button in the bottom right corner of the screen. Within the Setup screen, you can right-click on the column lines and choose from Delete, Move Left, or Move Right. More information on the Setup screen is provided below.
- To change the order in which the data field columns are displayed, click the ‘Setup’ button in the bottom right corner of the screen. Within the Setup screen, you can right-click on the column lines and choose from Delete, Move Left, or Move Right. More information on the Setup screen is provided below.
Once you have customised the Custom Inquiry screen, the screen view will be unique to you, and each time you log in, you will see the same custom view. You also have the option to select and save an unlimited number of custom views. This can be done in the ‘Setup’ screen, as detailed below.
The Inquiry screen below is the initial Custom Inquiry screen, which can be modified by the user.
Custom Inquiry Screen ‘Setup’ Function
To begin setting up your Customised List screen, click the Setup button, as shown above. The Setup screen will appear, as displayed below.
From this screen, users can add and remove data columns as needed. Almost every field within the SapphireOne data tables can be included in the Custom List screen, provided the user has the necessary authorisation.
The screen features several menu items across the top, which include:
- Reset to Default – Clicking this button resets the display to the default settings determined by SapphireOne. When you add a new data field, SapphireOne will place it on the right-hand side of the data columns. You can then click on the field heading and drag it to your desired location on the screen.
- Show Related Record – This option allows you to add related fields from other tables. By ticking the Show Related checkbox
at the top of the screen, you can select a related record, and a mini view of that related record for the chosen entry will be displayed for the currently selected record. You will need to select the fields to be displayed.
- Favourite Set – Located at the top left of the screen, this option enables you to save a custom-created screen for future use. For instance, you can have a simple Inquiry screen for general use and a more complex screen view when auditing specific information.
Details Page
When first Looking or Modifying
a Client Inquiry the Details page is the first page the user is presented with. You can change the Page you are viewing by navigating to the Page drop-down menu on the left hand side of the SapphireOne Toolbar.
Client Area
This area displays information about the Client such as the ID, Name, Area and Class.
- ID – The Client ID is the very first item to be created in the Client Inquiry screen. SapphireOne recommends establishing a criteria before entering any Client ID’s, as once saved these ID’s may not be deleted i.e. SapphireOne can be entered as Client ID SAPONE. Once the ID has been created it will become the default Client ID for the Client. Under normal circumstances the Client ID will not be changed or modified, however it can be amended by going to Utilities > Utilities > Sapphire Tools > Change ID. Only an authorised user can modify a Client ID.
- Name – The name of the Client will be entered here. The Client Name can be modified at any time.
- Area – This data entry field is used for grouping clients for reporting purposes. For example, if you wished to group your clients by a rating system i.e 1-9 or A-E, you would use the Area field.
- Class – This data entry field is used to assign the Client to a Client Class. Client Classes are important as they may be used for a number of items. For example, you can organise your Clients into different classes such as Prospects (P), Inquiry (I), and Client (C) to distinguish and group.
- Company – SapphireOne will by default enter the Company that the user is logged into and this may not be altered by a user logged into a specific company.
- Department – The entry of a department is optional depending on a number of factors. One factor would be if reports are to be generated at the department level. This is an optional field.
- Rep – This data entry field is used to assign a particular sales representative to the Client. Sales Representatives are set up through the Inventory screen. This is also important as Sales Reps can be limited to only viewing their own Clients. This is an optional field.
- Job Project – The Client may be linked to a Job Project if a Job Project ID is entered into the data entry field. Job Projects are set up in the Job Project Inquiry screen. This is an optional field.
- Reseller – This checkbox is directly linked to the Reseller Page in Inventory Inquiry. Any Clients who have the Reseller check box selected will be displayed in the list of Resellers. For example, when you have a prospective buyer for a particular product you can easily inform them of Resellers in their area or Resellers that have stocked the particular item in the past. This is an optional field.
- Open Item & Active Check Boxes – The checkbox when a new Client is created is automatically set as Active and its state may be altered to Inactive at any time provided that the Client has a ZERO balance. It is not advised to change these checkboxes as this can cause confusion in the Client datafile which can not be easily altered at a later point.
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 organized 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 digitize 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 organized 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 organized 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 organized 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 centralized 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 organized 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.
In SapphireOne, making a record inactive removes it from the standard inquiry list. This is applicable to most items in SapphireOne, not just clients and vendors, which are used as examples in this article. For instance, if you have an employee who is no longer employed with the company, you can make the employee inactive within SapphireOne.
Deleting records is not allowed in SapphireOne for audit purposes. Instead, you can make a client, vendor, or any other record inactive so that it is no longer displayed 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.
- Unselect the Active checkbox.
- SapphireOne will display a warning to the user if the deletion is not allowed.
To access the Include Inactive function when viewing a list of items in SapphireOne, 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.
How to View Inactive Records in SapphireOne
To view inactive records in SapphireOne, follow these steps:
- Use the Find ‘Command/Ctrl F’ function within SapphireOne.
- Select ‘All Records’ from the drop-down, which will include all active and inactive records within your search.
Grouping Area
The Grouping Area in the Client Inquiry screen includes three tags which are by default named: Tag, Tag2 and Tag3. These tags are default headings and the user may go to Utilities / Controls / Master defaults / Clients Page and rename the tags as required.
These same three tags are also displayed as part of the details displayed when the list of Clients is on screen. These tags are mainly used for reporting and reconciling Clients details.
When a detailed query is executed they form part of the list of Fields when a Detailed Query is executed.
When a Quick Report is executed they are listed as part of the Master Table and all SapphireOne report writers have these fields accessible.
Address Area
- In the upper section of the Address area, there is a drop-down menu that has three option for addresses that are to be automatically used for this client and SapphireOne defaults to displaying the Standard address.
- There is also provision for the entering of a Statement or Invoice addresses by selecting from the drop-down menu. These addresses are all interdependent of each other.
The user should remember that these addresses will be automatically entered into any reports that are hard coded into SapphireOne. It should also be noted that when standard or any custom reports are used, allowances will have to be made for the number of lines in the address and how many characters wide the addresses will be.
- The
button allows the copying of the Postal address details across to the Physical address area in the Standard Address selection previous page, or the copying of the Invoice Mailing address to the Invoice Delivery address on the Invoices address screen seen above.
- In the Standard address field area the Country field is preconfigured and the user can select the Country code they require.
- In the Standard address field area the Postcode field is eleven characters to cater for international standards.
- Also in the Standard address field area is provision for inserting specific Delivery Instructions and Telephone numbers for each individual Client.
- Also included in this Address area is the provision for storing the main Telephone and Email.
- If the SpliceCom telephone system has been installed double clicking on telephone
button will tell the SpliceCom telephone system to ring the number as entered.
- Provision is made here for the storing of Client Email and URL.
The Clients email address inserted here is essential for the correct functioning of the email process when emailing Remittances and Invoices. Unlimited email addresses can be entered by putting a comma ( , ) with no spaces between emails.
For further information on sending emails please refer to the Navigation and Procedures.
SapphireOne Mapping Feature – Apple/Google Maps
A useful feature available in SapphireOne is the ability to obtain a map view from a Physical address record. To access this functionality, click on the “Physical” heading in the Address Area. This feature is available throughout SapphireOne, including in Sapphire Webpack and the Sapphire Custom Webpack. With this feature, the user can obtain a visual representation of the physical location associated with the contact’s address, which can be helpful for planning and logistics purposes.
The map view feature in SapphireOne is device/platform agnostic, meaning that it can be used on any device or platform. When the user clicks on the “Physical” heading in the Address Area, the default mapping application in either an app or web browser will be utilised to display the map view. This means that the feature is not dependent on a specific mapping application or device, and can be accessed and used on a variety of platforms and devices.
Contacts Area
The Contacts area in the Client Inquiry screen displays a list of client contact details. This list will be limited to the contacts linked to this Client only.
To amend and update Client contact details, simply double click on the Client in the Contact Details area and enter the new details.
There are four icons just above the Clients contact list for user management of the Contact list. These include:
Highlighting a contact and selecting the button will remove the selected contact.
Selecting the button will start the creation of a new contact. This brings up a new screen to allow entry of all details for a contact. The user will have to complete all details required. Any contacts created here under the Client Inquiry function will automatically have a link to this Client.
The Link button is for the updating Contact links. It is strongly recommended that new contacts are added using the function that they are to be linked to, in this case, a Client Inquiry. This will automatically create the link to the client that is currently being modified.
If there are too many Contacts to comfortably view in the normal viewing mode of the Details Page of a Client Inquiry, select the button to view the list of contacts full screen.
There is a Contacts item on both the Inquiry Pallet drop-down menu and also from the General drop-down menu when using Workbook mode. Any contacts created there can be manually linked.
Importing Contacts
Selecting the button will display the Select Contact Master pop-up. There is a drop-down menu available for the user to select contacts.
For example, if Clients is selected and the ‘@’ symbol is entered into the data entry field SapphireOne will display a list of Clients to choose from.
Highlight the Client that you want the contacts for and select OK. SapphireOne will then display a list of contacts for the selected Client. Tick the contacts that you want to Import and select OK.
NOTE: One or more contacts may be added at once and the contact is duplicated when imported. The contact may be copied from any function within SapphireOne not necessarily from another Client as documented here.
More Details Page
The More Details Page holds internal credit information and additional details about the Client.
Last Transaction Area
This area contains details taken from other areas of SapphireOne, including the amount of the Last Receipt, the date of the Last Transaction and when the Client details were Last Modified.
Loyalty Points Area
Displays the current loyalty points for the client.
Tax Details Area
- Tax No – The Tax Number is the ABN of the Client (in Australia).
- Note that this Tax No is underlined. Double clicking on it will tell SapphireOne to execute the default web browser on SapphireOne and to go to ABN look up. It will then automatically enter in the number as entered on SapphireOne and check if the ABN is both valid and active.
- The user must enter the number without the spaces. When the user tabs away from this data entry field SapphireOne will automatically enter the space for you.
- Tax Code – Enter the tax code for the Client. For example, in Australia this would usually be S for 10%GST.
- Tax Rate – The Tax Rate displayed depends on which Tax Code is entered. These are set up in Utilities Mode.
- Exempt Checkbox – The Exempt checkbox is used for Australian companies that deal with overseas clients. For example, selecting the Except Checkbox will mean that overseas will not be charged any Australian tax.
- Use Checkbox – Selection of the Use checkbox tells SapphireOne to override SapphireOne Settings and to use the tax rate entered in the Tax Code data entry field here.
Miscellaneous Area
- Facsimile No – Fax numbers can be entered here.
- Default GL Code – A Default GL Code account number can be recorded here. This will automatically enter the GL Code for any Client Invoices entered in Accounts mode.
- Currency – This Currency drop-down list is where the currency that the Client trades in is selected from a drop-down list. This drop-down menu will ONLY be displayed when a NEW Client is being created. Once a single transaction has been performed against this Client it will be permanently removed.
User Defined Area
In this area, four user defined fields can be set up as required. The first two fields are indexed and will appear in the Find ‘Command/ctrl F’ screen to allow fast searching for secondary data. All four fields can be queried by using the Detailed Query ‘Command/Ctrl Y’.
These fields can be renamed by going to Utilities / Controls / Master Defaults / Client.
Serial Shipping Container Code (SSCC) Area
These are simple data entry fields and may be used for reporting when a Custom Report is set up.
- Number – A starting Number may be setup by direct entry of the number.
- Prefix – A Prefix to the number may be added if required.
- Suffix – A Suffix may also be to the number if required.
Addition/Deduction Area
- Ignore Levy Rules Checkbox – Selecting this checkbox will tell SapphireOne to ignore any levies setup in SapphireOne for this client only.
- Ignore Royalty Rules – Selecting this checkbox will tell SapphireOne to ignore any Royalties setup in SapphireOne for this Client only.
Periodic Invoice Area
In some cases, customers will be making a number of purchases for the same items on a daily or weekly basis and these sales will generate a number of SCI’s. Payment terms for the Clients are set up so that payments are made on a recurring basis which is usually period based. SapphireOne periodic invoicing helps to streamline the management and processing of these transactions.
To set up a Client for Periodic Invoicing the user will have to enter data into the Periodic Reference Area in a Client Inquiry. Once the data entry fields have been setup SapphireOne will generate all invoices for the Client as periodic invoices moving forward.
It should be noted that these invoices will also receive their own unique number and this number will be setup in a company inquiry.
When the Periodic Invoice function is selected in Inventory mode, SapphireOne will then only display invoices marked as periodic. All period invoices may still be treated as normal invoices if necessary.
- Period – The options are Daily, Weekly, Fortnightly, Monthly and None. If None is selected the periodic invoices will be marked but will require that the user manually create the Invoice date.
- Output – The user will need to have the ability to quickly identify these periodic invoices, and then process them, usually in the order they are raised. For this reason provision has been made to automatically enter in a predetermined internal reference number.
Invoice Reference Area
Each client may be given a unique prefix and number. This function can be used so that each time you generate an invoice for that particular client, SapphireOne will automatically generate the invoice with the unique prefix and number for that client. For example, if IKEA was a client, your invoices have the ability to be generated as IKEA0001, IKEA0002, IKEA0003.
General Message Area
Any comments or information about the Client may be entered here. When a new transaction is created for the particular Client this general message will automatically appear to alert the user. If nothing is entered here, no alert message will be displayed.
Custom Page
Custom Page Overview
SapphireOne’s Custom page features text fields designed for versatile, user-defined purposes. Each field is assigned a variable by SapphireOne, which is displayed as the default field heading label. Users can take note of the desired field or heading variable for customisation and modify it by navigating to Utilities > Controls > Change Names. Detailed instructions on this process will be provided below.
The Custom page is organised into the following sections:
- Alpha – Allows letters and numbers, but cannot be used for arithmetic functions
- Real – Allows numbers only, and can be used for arithmetic functions
- Date / Time – Date fields store date values and can be used for date functions, while Time fields store time values and can be used for time functions
- No Heading Defined – Features eight alphanumeric fields that cannot be used for arithmetic functions
- Text – Accepts letters, numbers, and special characters, but cannot be used for arithmetic functions
The data entry fields in these Custom Pages can also be employed in Sapphire Custom Reports, Quick Reports, Custom Inquiries, 4D View Pro, and 4D Write Pro Reports, just like any other data entry fields within SapphireOne.
The example Custom Page below is from an Asset Inquiry; however, the process for customising this page remains the same, irrespective of the function in which the Custom Page is located.
Default Variable Values
In the default variable values defined by SapphireOne, the first number signifies the position of the field within the group, while the second number denotes the maximum number of characters for the data entry field.
For instance, ASAlpha_1_20 indicates that it is the first data entry field in the group and can hold up to 20 characters. Similarly, ASAlpha_8_80 shows that it is the eighth data entry field in the group, with a capacity for a maximum of 80 characters.
To modify the headings on a Custom Page:
- Write down the exact names of the headings you wish to modify.
- Navigate to Utilities > Controls > Change Names. Keep in mind that when performing this procedure, you will be warned that only one user should be logged into the data file.
- Upon accessing the Change Names function, a dialogue box will appear. Then, refer to your list of names and scroll down the list to find the headings you want to modify.
- For each heading:
- Highlight the name.
- Enter your new name in the lower data entry field.
- Click the Update button to save the changes in SapphireOne.
The Current Balances screen shows current aged balances for the Client.
Include Unposted Checkbox
The value of entered but un-posted transactions can be shown by ticking the un-posted checkbox in the center of the screen. The new values will not be visible in the chart until the screen has been re-drawn. You can force this by re-selecting the Column or Pie button radio button in sequence.
A Balances graph gives a visual appraisal of the Client’s current status as a Column chart.
Client Inquiry FX Balances Page
This screen displays the foreign exchange information for balances relating to the Client. The Currency that each Client trades in is set in the More Details Page when a new Client is first created.
We have selected USAABC for this FX page that is displayed above.
The user should note the Type column which is the third column from the left in the transaction lines area. For Clients that trade in a foreign currency the currency Type will be added to the type as a suffix i.e. Client Invoice USD (CI USD).
The Aged area will display aged balances, in the top right hand corner of the screen in the currency selected, such as Current 30 Days, 60 Days, 90+Days and Total Due.
Transaction Details Footer
- Discount % – This displays any discounts applied for the Client.
- FX – This displays the current exchange rate for the FX Client.
- Discount Days – This displays the number of days that the discount will be applied to.
- Look Button – For the highlighted line selecting this button SapphireOne will display the transaction enabling the user to see what is in the transaction itself.
- Invoice Button – At the bottom of the screen, if it is an Invoice there will be an Invoice Button. This enables the viewing of the original Invoice
- Print Source Button – When this button is selected SapphireOne will print the currently selected transaction with today’s date on it.
Client Inquiry Credit Control Page
This screen displays all the Client information, i.e. all current Transactions, Balances, Contact Details and Notes.
This screen is designed for real time Credit Control and gives the user the ability to set notes and alarms for reminders.
By clicking on the column headings, you may sort any column into ascending or descending order. Highlighting a transaction brings up the allocations linked to it and this allows viewing of the data in more detail.
The top right-hand corner of the screen displays the Aged which includes the Opening Balance, Current, 30 Days, 60 Days, 90+ Days and Total Due. By selecting any one of these underlined headings in the Aged area, an immediate filtering for the ageing of the displayed transactions is performed. For example, in the screenshot below, the transactions have been filtered to display Current transactions only.
- Terms Based Checkbox – Alternatively, you may alter the data being displayed in the Aged Balances area by selecting the checkbox in the center of the screen.
- Credit Stop Checkbox – This checkbox puts the client on stop credit which prevents them from processing any new transactions until their account is bought back within their credit limit. This checkbox is linked to the Stop Invoices data entry on Credit Stop checkbox on the Client page of Master Defaults. If the Master default above is not selected, users will only receive a warning that the Client is on Credit Stop, but will still be permitted to raise invoices for the Client. Once that has been selected, users will not be permitted to raise any invoices for any Client placed on Credit stop.
- For the following procedures to work correctly the Contacts must have both a Telephone number and their E-mail address entered into their respective files.
- If linked with the SpliceCom Maximiser telephone system, users can click on the underlined Phone Number of the contact to make and end a call from within SapphireOne. This will also log the call within the notes section of the Credit Control Screen.
- Users can also click on the underlined email address to directly open a new message to the required contact.
There are ten buttons across the lower section of the screen and the list below gives a short description of what each one does. A number of these buttons have provision for the E-Mailing of various reports to the selected Client. When a user selects a record within the Credit Control screen that is linked to an Inventory Mode Transaction, the Open Invoice and Print Invoice buttons will become active.
- Open Invoice – This button is for the purpose of E-Mailing invoices to customers. The procedure is as follows:
- First highlight the transaction in the list and then select the Open Invoice button. A list displaying the required invoice will then be displayed and the user may then view or modify it as required.
- Open the invoice by double clicking on the invoice. Once the invoice itself is displayed the user may then select the small arrow on the right side of the Print icon on the main toolbar. All of the standard print options are displayed in the drop-down menu including the Email option.
- From there the user is able to enter the relevant recipients if not pre-filled in and which type of report is to be attached to the email.
- Print Invoice – When this button is select SapphireOne will immediately display the print dialog popup enabling either the printing or re-printing of the linked invoice.
- Look – When the Look button is selected SapphireOne will display a screen showing the Transaction details.
- Retrieve Linked – When this button is selected SapphireOne retrieves linked transactions that have been moved into History via allocation. The user will be presented with a pop-up confirming this.
- Reload Screen – Selecting this button will reset the screen to its original opening view.
- Statement – Selecting the button will cause SapphireOne to display the Client Statement Reports print dialog popup. This allows the user a number of options for the printing of Client statements as of today’s date. It should be noted that one of the options is the provision for the E- Mailing of the statement to Clients.
- Allocation – This button provides a convenient short cut to the Client Allocation function. When a transaction has been highlighted and the Allocation button selected, SapphireOne will then check to see what Client is linked to the transaction that was selected, and then display any un-allocated transaction for that Client in the list. To allocate any of the transactions in the list, first highlight it, and then select Allocation from the Tools menu on the main toolbar. The standard allocation page will then be displayed enabling the user to immediately allocate the transaction.
- Find – When the find button is selected, SapphireOne will display the detailed query function enabling detailed query to be performed.
- Open – When the Open button is selected, SapphireOne does a specific search for historical transactions in SapphireOne for the currently selected Client.
- Process Payment – When the Process Payment button is selected the user now have the ability to process payments directly from this credit control page.
Processing Client Receipts within the Credit Control Page
Once the process receipt has been selected SapphireOne will display the popup as seen below. It display all details that are required when processing a Client Receipt (CR).
The Receipt Detail area will display some details about the Client. Both the Date and the bank account details may be altered if required. Any credit card payments may be entered in the Credit Card Setting area.
To select the invoices for payment, select the checkbox at the right-hand end of each line that a transaction is listed then select Create Client Receipt Button.
SapphireOne will then display a pop up asking for confirmation that the receipt is to be created.
Until it is posted alterations may be made to it if necessary.
Client Inquiry Terms Page
The Terms screen is the main Credit Control Screen allowing you to set payment terms and credit limits for each individual Client. There is some default information entered by SapphireOne in this screen and these are from the settings in: Utilities / Controls / Master Defaults / Clients Credit.
This Clients Credit Page in Master Defaults has a Defaults area which allows you to enter default payment terms when setting up new Clients.
What you see in the screen above has been entered by SapphireOne from the settings in Master Defaults. When you alter the details here on a Client by Client basis the information you enter will override the details that SapphireOne enters here from Master Defaults.
Please refer to the Utilities Reference articles for more information on System Controls and Master Defaults.
You will also note that the details entered by SapphireOne have also been altered and the settings entered here will be the ones used for this Client only.
Payment Terms Area
Normal
For the Normal drop-down menu field, the options available are as follows:
- The 7 days, 14 days and 21 days drop-down data entry fields specify the normal payment terms for the client.
- The 20th and the 25th of the month following options will cause the client to be overdue from the end of the current month. The user will receive a warning when the Client exceeds their payment terms. Depending on the manner that the Client record is setup in Master defaults it may be possible to override this. These settings are to be found by going to: Utilities \ Controls \ Master Defaults \ Client Credit Page
Below are examples of payment term settings:
- If 30 days from invoice date, Select the: Other option and enter 30 days.
- If due date is end of the next month, select the Other option and enter -31 days (Note the minus symbol leading the number)
- If the due date is 60 days from the invoice date, select the Other option and enter 60 days.
- If the due date is 60 days and at the end of the following month, select the Other option and enter -61 days. (Note the minus symbol leading)
- If the due date is 45 days from the invoice date, select the Other option and enter 45 days.
- If the due date is 45 days and the following month, select the Other option and enter -45 days. (Note the minus symbol leading)
If the Client has been set up as Cash on Delivery or Prepaid SapphireOne will not allow an order, OCI, to be converted to a sale, SCI until the payment details have been correctly entered on the More Details Page.
Auto Credit Stop After
SapphireOne calculates the Credit stop terms on the oldest Invoice in SapphireOne for this Client based on the day it was entered. SapphireOne then monitors the number of days set in the terms data entry field plus the number of days set in the Auto Credit stop after data entry field. This may also be setup in Master Defaults for all Clients. Users will not be able to raise any invoices for them until the credit balance is rectified.
Auto Credit Stop may be set here on a Client by Client basis or it may be set in master defaults for all Vendors. SapphireOne will check here first and if it is set at zero disabled, it will then check in Master Defaults.
Prompt
This is also where you set up any individual Prompt Payment Terms for a Client. Prompt is set as a percentage, and Discount Within is set within a number of days. This then becomes a default Prompt Payment Discount for this Client.
Discount Area
- Product Discount % – Entering a number (up to the 2nd decimal place) in the Product discount % field will apply a discount to all products purchased by the Client.
- Price Code –This data entry field allows you to select a particular price code to use for all Inventory items for this Client. Price Code is set in each individual inventory item.
- Lookup – This data entry field links to Price Book if a price code beyond the standard ones is being used.
Payment Defaults Area
This area allows you to set up the Client’s normal payment method.These details include the Bank, Branch / BSB, Account Number, Swift Code, Drawer and Preferred Payment Method The user should note that any spaces or dashes in the BSB number will be removed by SapphireOne.
These details will automatically be inserted by SapphireOne from the Client file to help reduce data entry. You may alter these details on any individual transactions if the need arises when the transaction is being entered.
Preferred Payment Method – The user should be aware that the selection for the Preferred Payment Method set up here determines the automatic selection of the Payment Type by SapphireOne when a payment is made by the Client. So the correct selection made here will help reduce Payment Type errors and data entry when receipts are created by users for the Client later on.
Credit Card Defaults Area
In this area the Clients Credit Card details may be entered, including the Credit Card Number, Expiry date and Security Code. When a Payment Type of Credit Card is selected when receipt is being processed SapphireOne will automatically enter these details into the Client Receipt.
Internal Area
The main use of the Internal Area is for when you treat a branch of your company as an internal client, you may then generate a Order Client Invoice (OCI) and handle it as normal OCI which on conversion generates a Transfer.
Do not enter any data into this area unless you intend to use this Client for internal transfers. SapphireOne has created Internal Client functionality so that another department/branch may create an OCI that will appear in the standard pick list, however when converted the transaction converts to a Transfer General Ledger Journal Entry (TGJ) instead of an Sales Client Invoice (SCI).
The benefit of this is that Price Book records can be set-up against the Inventory Items as Margins on Last Cost using the Internal Client as a price book reference and the difference in these set prices will be On-Costed to the Inventory item in the TGJ transfer.
- Once the Internal Branch checkbox is selected any orders created for this Client now declared to be an internal Client when processed, will create a TGJ, transfer entry and not an SCI.
- Location If inventory is held in a number of locations the user may enter here, the location that the TJG entry is to be processed to.
- Variance Account by entering a G/L account any variances may be stored in the as entered G/L account.
- Margin On Cost a figure may be entered here for SapphireOne to automatically add in a Margin to the On-Cost figure.
- And the user may select from Last or average cost radio buttons if it is to use the Last or Average cost for the calculations for the Margin On Cost figure above.
Credit Control Area
- Credit Limit – The Credit Limit field sets the maximum credit limit for each Client. When this limit is exceeded you will still be able to process new invoices for this client, however you will receive a warning that the Client is over their credit limit in the form of a dialog screen.
- Message – The Message area allows you to add additional text to the maximum credit limit message that will be shown to a user creating a transaction when the Client is over their credit limit.
- Credit Stop – When the Client has a negative Credit Limit and this checkbox is ticked this halts all invoicing to the Client.
- Once the status of this checkbox alters SapphireOne will make a log entry into the area just below the check box. This is a non-editable log that shows when users have activated and deactivated the credit stop of a client. This log is activated from all areas where a credit stop can be applied. A Client Inquiry on both the Credit Control & Terms Pages plus also from the Allocations Inquiry Screen.
- While you can ignore the warning dialog screen and continue to create an Invoice for the Client it will be saved with a Posted Status Code of err. When you look at the Invoice you will find in the Information area Controls Tab that the error code is set at CL.
- Order No Required – Selecting the Order No required checkbox will cause SapphireOne to prompt the user for an order number as seen to the right when creating a transaction for this Client. Saving of the transaction will not be allowed until an Order number is entered.
- Do Not Ship – The DoNotShip check box gives the SapphireOne user the option of excluding a transaction from a Shipment Report on a Client invoice. This check box enables the user to make a transaction inactive or to hide the transaction from the shipment. If the Do Not Ship checkbox is selected, all shipment to the Client will be halted.
- Exclude from Overdue email function – Selecting the Exclude from Overdue email function checkbox here in the terms page of the Clients master record will remove them from automatically generated emails by SapphireOne if they are overdue in Payments.
- In Master defaults there is a specific page for Credit Settings for Clients so that when they are overdue in their payments SapphireOne may be set up to automatically send emails to these Clients. Some Clients may be offended by these emails so businesses may use other means of communication the problem of the Clients overdue accounts. I.e. A personal Telephone call.In this same page there is a BCC Sales Rep checkbox. When this is selected, SapphireOne will also send an email to any Sales Reps entered for that Client when SapphireOne sends the email to the Client.
Controls Area
The Controls area is where default General Ledger accounts are set for individual Clients.
- Control Default – The Control Default data entry field is where an alternative GL account to SapphireOne GL account may be entered.
- Tax Default – The Tax Default field account ID is where an alternative GL account to SapphireOne GL account can be entered.
- Sales Default – The Sales Default data entry field is where a Sales Default account may be entered that is different to SapphireOne sales Default account.
- Linked Client – The Linked Client account data entry field is where you establish the Parent Child linking account. When a Client is to be a child, the Parent ID must be first entered. For a parent, the Client is linked back to itself. For example, if ARCRES was to be a parent the user would enter ARCRES in this field to indicate to SapphireOne that it is a parent. Once a parent child relationship has been established the way that credit control is applied by SapphireOne will change. The user has 2 options:
- Set a gross limit for the parent and leave the children’s limits blank.
For example set the Parent at $20,000. No action will be taken by SapphireOne until the children as a group exceed the $20,000 limit. The warnings or stop signs will only be applied by SapphireOne when the children as a group have exceeded $20,000. - Leave the Parent blank and set a limit for each individual child. SapphireOne will then look at each child’s credit limit individually and take an action when each child exceeds that limit.
- Set a gross limit for the parent and leave the children’s limits blank.
- Payment account – If a value is entered here SapphireOne will override the control G/L accounts as setup and use the G/L account entered here for this Client.
- No back order on this client – If the True radio button is selected, ANY orders for this Client that will raise a backorder component will cause the Alert to be displayed. This may be ignored if you wish.
EDI Setting Area
This area is where the Clients Electronic Data Interchange details may be stored. On applying for EDI you should be given these areas:
- EDI Link – This data entry field is for the entry of your EDI ID or Link.
- Ship ID – This data entry field is for the storing of the Shipping ID.
- Location – This data entry field is for the storing of the Location.
- Order Acknowledgement – Selecting this checkbox will tell SapphireOne to generate an Acknowledgement to any orders received from this Client.
- No Invoice – Selecting this checkbox tells SapphireOne not to print an Invoice at this stage.
- No Shipping Notice – Selecting this checkbox tells SapphireOne not to send any shipping notices for this Client.
- Include Product Code – Selecting this checkbox tells SapphireOne to include a produce code with the item/s delivered for this Client.
Control Log
Changes to your terms are tracked in the Control Log. This information can not be edited.
Print Trade Reference
In the lower right-hand corner of the screen there is a Print Trade Reference button. Selecting it will cause SapphireOne to display the print dialog popup. This will then enable the printing of a trade reference. This print out contains the Clients Payment Terms, Average Monthly Sales, and the Average Pay Days in days that they take to make payment on their account based on the day that the invoice is raised.
Client Inquiry Transactions Page
The Transactions screen shows details of the current transactions including Dates, References, Totals and Transaction types. It also shows whether or not the transaction has been posted in the Posted status column.
Double clicking onto a transaction will display the information as entered into SapphireOne including the GL Account detail lines as seen below.
Invoice Button – If the transaction was entered as a Sales Client Invoice (SCI)/Job Client Invoice (JCI) the Invoice button will become active. When selecting the button, the original SCI or JCI will open with all relevant information. From there selecting the more button will display the Inventory line allocation.
Client Inquiry History Page
This screen shows details of all Current and Historical transactions for the selected Client.
Selecting the Open button will tell SapphireOne to open the same Inquiry that is performed when the user goes to: Utilities / History / Transactions.
Double clicking onto a transaction will display the information as entered into SapphireOne including the GL Account detail lines.
If the transaction was entered as a Sales Client Invoice (SCI)/Job Client Invoice (JCI) the Invoice button will become active. When selecting the button, the original SCI or JCI will open with all relevant information. From there selecting the more button will display the Inventory line allocation.
Client Inquiry Sales Analysis Page
This screen displays Sales Analysis for the selected Client.
- Line or Pie – The chat is displayed in either Line or Pie graphs, and numerical formats selectable by the appropriate radio button.
- Qty or Total – The two radio buttons Qty and Total enable the chart to display the breakdown by Qty (Quantity) or Total dollar amounts.
- Period Drop down Menu – The period that the Sales Analysis is displayed is selected by the drop-down menu on the left side of the screen. At present there are 6 options for periods, including roll your own.
- The user may also select using the checkboxes provided to Include Unposted and to Group the inventory items by their Classes.
Client Inquiry Sales Page
This screen by default only shows transactions entered through the Sales menu in Inventory Mode for the current period for the selected Client, in this case ARCRES for period 8.
It should be noted that this screen updates from the History file and therefore does not show un-posted records.
To include a full history of Transactions for the selected Client you have to select the Include all Sales checkbox in the bottom right-hand corner.
Client Inquiry Keywords and Notes Page
Keywords & Notes Overview
The Keywords and Notes page is a standard feature found on all inquiry pages in SapphireOne, providing a central location to add and manage keywords and notes for each record.
Keywords Area
The Keywords and Notes page is consistent across all inquiry pages in SapphireOne. Users can add customisable keywords to the list and reuse them. Additionally, keywords can be added that apply specifically to the current record. To remove keywords from the list, users can hold down the Command key on a Mac or the Ctrl key on Windows.
Notes Area
The notes area serves as a diary, allowing users to enter notes and include a date and time stamp by clicking on the green clock button. Users can also customise the font, style, colour, and background colour of the text in the Notes area by highlighting it and right-clicking.
Client Inquiry Address Page
This screen shows you the information pertaining to the address of a particular Client. It allows you to have more than one address for the Client. The screen below shows the addresses set up as a Demo for ARCRES Architects Resource Group.
You can review current address or add new ones by double clicking on the address or clicking the ‘+’ button in bottom right corner of the screen. This will bring up the below window for data entry.
These addresses may also be linked to a contact using the Lookup data entry field in a Contact Inquiry on the Details Page. This Lookup data entry field provides the Lookup names for the Address list seen above. It should be noted that while the Address and Contact forms are the same, the links that are Address here the Lookup field in Contacts operate differently.
Client Inquiry Price Book Page
This screen allows you to see the prices of items linked to a particular inventory item that is specific for this Client.
Client Inquiry Period Balances Page
This screen displays the balances period by period for this Client as at the period end. It also displays the turnover for the current month.
Client Inquiry Standing Sales Page
The Standing Sales Page has been created so that the user may set up Clients who order the same item or items from inventory over a very regular time period. This is particularly so when deliveries are conducted on a daily basis and during the course of the day multiple transactions are created for the one client.
To enter in a new Standing Sales record, select the button to create a new record or highlight the required record and then select the
button to delete it. Double clicking on a highlighted record will allow the user to modify it.
Standing Sales for a Client may be set-up on a Client by Client basis.
When set up SapphireOne will create the OCI or SCI on the day that you use as the trigger. We advised that you enter the order before the due date to be prepared. The Delivery Day Delay field allows you to add the number of days that the order is to be raised by SapphireOne before it is to be delivered.
For example, a company may deliver orders Monday to Friday. For the Tuesday to Thursday orders, you would enter 1 day so that the OCI or SCI would be raised by SapphireOne a day early from Monday to Thursday.
However, the Monday order would have to be prepared on the last working day of the Week which is a Friday so the Delivery Days would then be set at 3. The OCI or SCI would be raised by SapphireOne on the preceding Friday allowing the company to prepare the order before the weekend for delivery 3 days later on the Monday.
Data entry for this function is as follows:
- Enter in the inventory Item to be delivered and the quantity.
- Next make a selection from the Recur drop down menu and choose from three options. The selection of an option will alter the options available from the Day drop down menu as follows:
- With Weekly you have any of seven days to select from, Sunday through to Saturday.
- With Monthly you have from day 1 through to 31, or end of month.
- With Yearly you have a specific date to be entered in the format dd/mm/yy.
- Next select if SapphireOne is to raise an Order Client Invoice (OCI) or a Sales Client Invoice (SCI).
- Finally select the delivery day Delay in days.
- Then select the
on the main tool bar to save the newly created Client Standing Sales record.
Client Inquiry Job Project Page
Job Project Page displays all Job Projects that this Client is linked to. The screen is populated with consolidated data drawn from each Job Project that the Client is linked to. The data as seen below must be entered into each project before it will be displayed here.
For each Job Project a Start Date and the estimated Finish Date will be displayed. Each Job Projects Estimated Cost and Estimated Billing will also be displayed as it is entered into the Job Project. Finally, SapphireOne will display the Actual Cost and the Actual Billing at the present time.
Client Inquiry Email Log Page
When any email is sent from within SapphireOne a log is kept of the email. SapphireOne then filters all of these log entries and displays all emails unique to that client. If the user double clicks on a log record they may then view the body of the email as it was sent.
Client Inquiry Rating Page
Records any feedback from the rating systems clients may have made. For example, the rating system on this page could be linked to an API with MailChimp and record client feedback.
Action Page
Action Page Overview
The Action Page is a versatile tool that can be added to major records and transaction tables. It includes various actionable items such as Calendar Reminders, Meeting Invites, Alarms, Emails, To-Do Lists, General Notes, Private Notes, Meeting Notes with Date and Time, Start and Finish stamps, as well as All Day Notifications. This provides users with a centralised location to manage and organise their tasks, meetings, and notes, improving efficiency and productivity.
The Action Page allows users to use the add or delete
buttons to add or delete actions as required. Simply select the relevant button to add or delete an action.
Diary Area
The Diary Area in SapphireOne provides users with a comprehensive range of options to customise their actions. It includes a sequence number, title, type, action, user, privacy settings, status, tag, and link fields.
- Sequence – SapphireOne automatically generates a unique sequence number for each action.
- Title – Enter a title for the action.
- Type – Choose from the customisable drop-down menu to input a type. This will subsequently become a permanent type within the drop-down.
- Action – Utilise the user-customisable drop-down menu to input an Action. This will then become a permanent action within the drop-down.
- User – SapphireOne automatically inputs the user creating this action, though it can be modified if necessary.
- Private – If this checkbox is selected, SapphireOne will only permit the specified user to view or modify this action.
- Status – The user has three options: Open, Hold, and Completed.
- Open – Action is open and active.
- Hold – Action is active, but no alarms will be active.
- Completed – Action is now Inactive and won’t be displayed in any list of actions.
- Tag – Users may attach a tag to an action, which will create a permanent tag within the drop-down. To add a new tag, type the name of the new tag into the tag box and press the tab key. Select “Yes” from the pop-up window to confirm. To remove a tag from the list, click on the tag name while holding down the Command (MacOS) or Control (Windows) key. Select “Yes” from the pop-up window to confirm the deletion.
- Link – When created within a transaction or record, SapphireOne automatically generates a link to the transaction or record. When created from the Options Menu, Palette, or Workbook, users must select an item or function from the drop-down menu to link the action. There are 12 items on this list, ranging from Clients to Manager.
Check List Area
SapphireOne offers a user-friendly checklist tool to create and track actions, allowing users to check off completed items as they progress.
Dates and Times Area
- Start/Finish – Set a Start and Finish time for the action, or select the checkbox for an all-day option.
- Completed – Entering a completion date for an action deactivates it, and it will no longer appear in action lists.
Alarm Area
Never forget a task again – set up alarms to send reminders via email at specific dates and times. Users can also receive email notifications with the provided email address.
Recurring Area
If necessary, the alarm can be set to recur at intervals selected from the Type drop-down menu. Additionally, the recurring period can be defined by date.
Notes Area
Click the green clock button to add time and date stamps to your notes. You can also customize the font, style, color, and background color of the text in the Notes area by highlighting it and right-clicking.
Invite Attendees Area
In the event module, you can invite multiple attendees to your event and track their acceptance or rejection of the invitation. You can also send them an email notification if their email addresses are provided. Additionally, you can manage and track attendees’ RSVP status in real-time.
Documents Page
Documents Page Overview
The Documents Page centralises document and information storage for transactions and master tables, streamlining organisation and management for easy access and improved efficiency.
Documents Area
The Documents Page simplifies file management by allowing various document types to be attached via drag and drop, including PDFs, spreadsheets, photos, and more. It provides a centralised location for document and information storage for transactions and master tables, streamlining organisation and management for easy access and improved efficiency.
Documents can only be attached once the corresponding record has an assigned ID.
Documents List Screen Options
There are eight buttons on the Document List screen, as follows:
- Open
– Allows viewing of the currently selected document.
- Update
– Prompts the user to import a new version of the selected document while maintaining links to any associated transactions.
- Scan
– Accesses a scanner for scanning documents directly into the data file and linking them to the current transaction (requires a compatible scanner with software).
- Save
– Saves the currently selected document.
- Link Document: Enables linking of the selected document to other transactions in the data file, presenting a popup for user selection.
- Link Document
– Allows linking of an existing document in the data file to the current transaction or record, displaying a popup with a list of documents to choose from.
- Link Existing Document
– Allows linking of an existing document in the data file to the current transaction or record, displaying a popup with a list of documents to choose from.
- Delete
– Deletes the currently selected transaction or record.
- Add
– Displays a search function for selecting a document from the local computer or device.
Details Area
The Details area allows users to add a custom name, description, and tags to each document, enabling easy search and location of specific documents. These details can be customised to meet the specific needs of the user or organisation, further improving the efficiency and organisation of the Documents Page.
Last Modified Area
The Last Modified section displays the date and time when the document was last modified, as well as the user who made the changes. This feature helps maintain accountability and enables efficient tracking of document modifications.
History Area
The History area records changes made to the document, including the date, time, and user who made the changes. This provides a valuable tool for tracking and managing document revisions.
Links Area
The Links area allows users to record links to other places where the document has been attached. Links can be added or removed using the (+) and (-) buttons, providing an efficient way to manage and organise related documents.
Notes Area
The Notes area allows users to add any relevant notes related to the document. Clicking the green clock button will add a date/time stamp, further improving document tracking and management.
You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.