Price Estimate Overview
SapphireOne Price Estimate function is an inventory price estimating tool used to calculate the Final Selling price. This is based on the Buying Price, Buying Costs and Selling Costs to get a final Selling Price of an inventory item. This function does not normally interact with any of your prices in SapphireOne, it is a tool solely dedicated to performing price estimates from your actual buying price through to a final Selling price.
When the list of Price Estimates is on screen, there is a Sapphire Tool named Push Price, which allows the user update the Price or create a Price Book entry for the selected Price Estimate item. This tool will be documented at the end of this article.
The inventory planner pricing tool takes into consideration the total costs of the inventory item, including the Foreign Currency, Buy Price, Discounts, Surcharges, Freight Costs, Insurance Costs, Landing Costs, Import Duty Costs, OnCost Price, Sell Foreign Currency Price, Finance Charges, Guarantee Charges, Interest Charges, Commissions, Rebates and other included costs.
This Price Estimate functionality may be applied to a selected Inventory Item, or to an Inventory Class. For either an Inventory Item or an Inventory Class, SapphireOne will display:
- Inventory Item – SapphireOne will display, Unit, Weight, Carton and Pallet which is for viewing only.
- Inventory Class – SapphireOne will display Type, Brand and Detail, all of which should have the appropriate data entered to ensure that the correct calculations are performed by SapphireOne.
FX Currencies
Within this Price Estimate function there is provision for viewing the dollar values in both local and FX currencies. This functionality will not work unless the exchange rate for these FX currencies has been set up in SapphireOne.
To set up FX your currencies go to Utilities > Controls > FX Currency Settings. If it is anticipated that these FX rates are to be used on a regular basis, your FX rates will require regular maintenance or updating.
Once the Price Estimate function has been selected SapphireOne will display a list of any price estimates already completed and saved as seen below. Any of these items may then be re-opened by selecting them and viewed or modified as required.
To enter in a new Price Estimate select the new icon on the main toolbar. We will commence with a Price Estimate for an Inventory item as seen in the screen shot below.
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.
Price Estimate Area
The Price Estimate Area of SapphireOne Price Estimate Tool is used to enter the Inventory Item or Class details relating to the Price Estimate being created. The user will notice that there are two screen shots above. The user may elect to enter all dollar values in your local currency and then switch to the FX currency. Alternatively, the reverse could be done. Enter prices in the FX currency and then switch to the local currency to see the dollar values in your local currency.
- Sequence – A Sequence number is automatically generated by SapphireOne. The user has the ability to set unlimited price estimates. All price estimates created have a unique sequence number for the user to refer back to.
- Company – SapphireOne will automatically enter the company that the user is logged into.
- Start – Enter the start date price estimate period. Click on the underlined heading to bring up the SapphireOne Calendar. SapphireOne will automatically enter in a Finish date for the end of the month following. This should be checked and altered as required.
- Finish – Enter the finish date of the price estimate period. Click on the underlined heading to bring up the SapphireOne Calendar.
- Option Selection – The user has two options from this drop down menu, Inventory & Class. It should be noted that the Price estimate screens for both Inventory and Class are identical, except when an item is selected from this drop down menu. The displayed information or data entry field related to the Option drop down menu alters as follows.
- Data Entry field – For both an Inventory Item and Class, there is a light blue data entry field immediately to the right of the drop down menu. When Inventory is selected, the user may use the wild card ‘@’ or ‘?’ search function in SapphireOne to look for the Inventory ID. If Class is selected, the exact same data entry field and procedure is used to look for the Class ID.
- Inventory – Enter the Inventory ID, or enter ‘@’ or ‘?’ to select from a list of all inventory items within your SapphireOne data file. SapphireOne will display the Unit, Weight, Carton and Pallet values all of which are populated automatically from the inventory item and are for viewing only.
- Class – SapphireOne will display the Type, Brand and Detail. It is critical that all of these should all have the appropriate data entered to ensure correct calculations to be performed by SapphireOne. The user will find that these are directly linked to the first three tags in the Grouping area in an Inventory Class.
- Document Paperclip – Click on the red Paperclip icon to add any documents related to the particular price estimate.
- Active Checkbox – You can deselect the Active checkbox to deactivate the price estimate. This will not delete the price estimate, just remove it from the Price Estimate list.
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.
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 time saver.
Calculation Area
The Calculation Area of SapphireOne Price Estimate Tool is used to enter all inventory, in order to calculate the final landed Buy Price, the OnCost Price and then the final Sell Price.
- Buy FX – The foreign currency the inventory item is being purchased in.
- Buy Price – The quoted price of the inventory item from the Vendor.
- Discount – Any discount the Vendor is providing on the product.
- Surcharge – Any surcharges incurred on the purchase of this product.
- Final Buy Price – The Buy FX, Buy Price, Discount and Surcharge costs will automatically calculate the final Buy Price of the inventory item.
- Freight 1 – Any freight cost related to the inventory item. For example, any international shipping costs incurred in the transport of the inventory.
- Freight 2 – Any secondary freight cost related to the inventory item. For example, the freight cost incurred from the landed port to the warehouse.
- Insurance – The insurance cost of the inventory.
- Landing Cost – Any additional landing costs incurred with the shipping of the inventory. For example, the cost to unpack the container.
- Import Duty – The sovereign cost, being the duty or tax.
- OnCost Price – The Buy Price, plus the Freight 1, Freight 2, Insurance, Landing Costs and Import Duties are calculated in order to determine the final OnCost Price of the Inventory Item.
- Sell FX – The foreign currency that the inventory is being sold in.
- Finance Charge – Any charges incurred from money borrowed to purchase the inventory. For example, Letters of Credit (LC).
- Guarantee – Any guarantee cost incurred in the purchasing of the inventory item.
- Interest Charge – Any interest charged in the purchasing or the inventory item.
- Commission 1 – Any commissions owed in the sale of the inventory item. For example, commissions paid to commission agents.
- Commission 2 – Any secondary commissions owed in the sale of the inventory item.
- Rebate – Any rebates owed in the sale of the inventory item. For example, statutory rebates owed to government authorities.
- Other Cost – Any other costs incurred in the selling of the inventory item.
- Sell Price – The final Sell Price of the inventory, calculated based on the Final Buy Price, On Cost Price and all sell costs – including the Finance Charge, Guarantee, Interests Charges, Commissions, Rebates and other additional costs.
History Area
The History Area of SapphireOne Price Estimate Tool keeps a complete history of every price estimate created for the particular inventory item. This gives the user the ability to review the historical pricing estimates of inventory items as a reference for any future price changes. SapphireOne allows for the keeping of an unlimited number of price estimates.
Notes Area
The Notes Area of SapphireOne Price Estimate Tool allows the user to add the Time and Date by selecting the green stamp and include any notes about the action. The user can also highlight the text in the Notes area and right mouse click to customise the Font, Style, Colour and Background Colour to your preference.
Sapphire Tools Push Price Function
While the Price Estimate function does not interact with prices in your data file, this Push Price tool allows the user to Push the estimated prices directly to your Inventory Items or to create Price Book entries.
First select a Price Estimate and the go to the Sapphire Tools icon. At the top of the list will be Push Price Tool.
On this Sapphire Tool there are two drop down menus and two buttons as follows.
- Inventory Drop down menu – This drop Down menu allows the user to select how the price is to be pushed out.
- Inventory Location – Push the price out to Inventory items in Inventory Locations only.
- Inventory Base – Push the price out to Base Inventory Items only.
- Class – Push the price out to a Class only.
- Class + Tag1 – Push the price out to Class plus the first tag.
- Class + Tag1 + Tag2 – Push the price out to Class plus the first tag and Second Tag.
- Class + Tag1 +Tag2 + Tag3 – Push the price out to Class plus the first tag plus the second Tag plus the third. Tag.
- Price formula – A number of formulas may be applied when pushing prices out.
- Update Sell Price / Weight – Update the selling Price divided by the weight
- Update Sell Price / Carton – Update the selling Price divided by the Carton.
- Update Sell Price / Pallet – Update the selling Price divided by the Pallet.
- Update Sell Price – Update the selling price only.
- Update Price Button –When this button is selected SapphireOne will update the Inventory Standard Sell price from the selected Price Estimate record.
- Create Price Book Button – When this button is selected SapphireOne will create a new Price book entry for the selected Price Estimate record. As soon as this has been done the user is strongly advise to open the new Price Book entry and check the details are correct.
You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.