Price Estimate - Empower Your Inventory Pricing

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.

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:

  1. 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.
  2. 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.

digi

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.

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 Paperclip Green or Attach-Red-Button 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.

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:

  1. Select/highlight the document you wish to link.
  2. Click the Link Document button.
  3. The Files pop-up window will be displayed.
  4. From the File drop-down menu, select the item you want to link the document to.
  5. 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:

  1. Confirm that you wish to import a new version of the document by selecting Yes.
  2. The user will then be prompted to choose the updated document to open.
  3. After selecting the updated document, a secondary dialogue will appear, asking the user to enter an alphanumeric value for the new version.
  4. 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
Paperclip 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.

Was this helpful?

Previous Article

Inventory Class

Next Article

Price Book