icon Chat with support search-icon
Share counter 0 SHARES
Blog post

New Release – 28th JUNE 2020

28 Jun, 2020 | Release Notes

Get A Consultation

New Features

Feature 1: Production Module improvements – Inputs/Outputs, Wastage posting

Impact area: DEAR Production Module.

Introduction: The Production module is aimed at addressing the needs of the production process. New production features will provide our current customers with powerful, logical manufacturing solutions to add to their inventory solution. Following on from our most recent releases, we are continuing to improve the Production module functionality and add features.

Pre-conditions: None.


Some production processes need to stock the intermediate results (products) of their operations for use in later operations. Such intermediate products can be reflected in the Production BOM to increase accuracy in production reporting and transparency for the production process. These are known as intermediate or semi-finished products in DEAR.

In the course of production some wastage can appear. These can include intermediate or semi-finished products which are unsuitable for production or finished goods which are unsuitable for sale. Waste costs can be either included into the production cost or posted to an expense account. This setting can be managed from Settings → General Settings → Purchase Process Customisation.

When posted to an expense account, cost of waste is based on the sales price. Wastage quantities are input …

More information:


Feature 2: Bulk deletion of Product Suppliers via CSV file import

Impact area: Inventory module.

Introduction: While it was possible to add supplier product prices to products in bulk via CSV import, DEAR lacked the option to bulk delete them. Bulk deletion of product suppliers has now been added..

Pre-conditions: None.


  1. Go to Inventory → Products → Export → Product Prices by Supplier and download the CSV file.
  2. Open the file. Type Delete in the action column of all the supplier product prices you wish to remove from your products.
  3. Save the file and re-upload the edited file via Inventory → Products → Import → Product Prices by Supplier.

More information:


Feature 3: Product images can now be added to stock task document templates

Impact area: Document templates.

Introduction: Product images can now be added to Stock Adjustment, Stocktake and Stock Transfer document templates.

Pre-conditions: None.


Document templates are customised from Settings → Document and Email templates. ProductImage mailmerge field has been added to the StockTransferOrder, StockTransferDetail, and InventoryAdjustment field code tables. This means product images can now be added to documents of type Product Label (Inventory Adjustment and Transfer), Stocktake, Stock Adjustment, Stock Transfer, and Stock Transfer Order.

Use this mail merge to display image:

More information:


Feature 4: Dedicated DB Server removes API call limit

Impact area: DEAR Inventory.

Introduction: Users with a dedicated DB server no longer have restrictions on numbers of API calls. Using a dedicated database server ensures that your DEAR application performance cannot be affected by other DEAR users, giving a more stable and consistent experience. This option is recommended for customers with high volumes of sales.

Pre-conditions: Upgrade subscription to include dedicated database server.


There are three dedicated database server options, all three options remove the API call limit:

  • Small database server (6 CPU cores, up to 50,000 sale orders per month) – $2,000 USD/Month
  • Medium database server (8 CPU cores, up to 100,000 sale orders per month) – $2,500 USD/Month
  • Large database server (10 CPU cores, more than 100,000 sale orders per month) – $3,000 USD/Month

This change is permanent. If you move to a dedicated database server, it is not possible to return back to a shared database.


Feature 5: DEAR POS – Search additional attributes from POS register

Impact area: DEAR POS.

Introduction: Additional attributes of a product can now be searched from the POS register. This allows POS users to use the feature to store additional or multiple barcodes for a product.

Pre-conditions: None.

Functionality: Detailed instructions are provided in the link below. Other information stored in additional attributes product fields can also be searched from the POS register. Exact match search only.

More information:


Feature 6: eCommerce, DEAR POS – process order adjustments for unfulfilled returned items

Impact area: DEAR POS, Amazon Integration, eBay Integration, Shopify Integration, Magento Integration, Magento 2.0 Integration, WooCommerce Integration, Shipstation Integration, Etsy Integration, Square Integration.

Introduction: Unfulfilled sales may occur when there is insufficient stock availability in the system but an eCommerce or POS sale is completed anyway. Previously when an eCommerce or DEAR POS sale is unfulfilled (for example, if an order was cancelled), the incomplete fulfillment would block credit notes from being issued and refunds from being issued.

DEAR has applied a fix to the logic of how credit notes, refunds and restock for such sales are handled. Credit notes and refunds are now processed for the authorised invoice amount, regardless of invoice status. Restock of unfulfilled orders is now controlled by new setting Ignore Restock for non-fullfilled Sales.

Pre-conditions: Active eCommerce integration.

Functionality: For DEAR POS and affected eCommerce integrations, credit notes and refunds are issued for the authorised invoice amount regardless of the fulfillment status of the order.

On the eCommerce/POS integration settings tab, a new setting Ignore Restock for non-fullfilled Sales has been added. This setting will be displayed only when the Pick, Pack and Ship processing mode setting value is set to Auto Pick+Pack+Ship.

  • When the setting is enabled, restock/stock allocation quantities will be edited to match the fulfilled items of the sale.
  • Keep setting disabled in order for current system logic to be maintained.

In DEAR POS, a notification pop-up will appear informing the user if they about to process a sale for a product with insufficient stock availability. The user must confirm if they wish to go ahead with the sale.


Feature 7: Shiptheory – Select SO # or Invoice # as reference number

Impact area: Shiptheory integration.

Introduction: Orders are passed from DEAR to Shiptheory with a reference number which is printed on Shiptheory shipping labels. Previously this was set to the invoice number. Fulfilling a customer request, a new setting also allows the sale order number to be used as the reference number.

Pre-conditions: Active Shiptheory integration.

Functionality: In Integrations → Shiptheory, set Use as Document Number to either Invoice number or Order number.

More information:


Feature 8: Shopify – separate fulfillment settings for POS/website sales

Impact area: Shopify Integration.

Introduction: For DEAR Shopify integrations, the same business could have their operations running through a website and POS for the same Shopify store. Shopify users would like to have different fulfillment processes defined for the sales initiated through Shopify POS compared to through their Shopify website. An extra layer of validation has also been added to correct issues with fulfillment of Shopify POS orders containing serial/batch products.

Pre-conditions: Active Shopify integration.


  • Integration setting Pick, Pack and Ship process mode for online sales selects fulfilment type (Auto pick, auto pick + pack, etc.) for sales originating from the organisation’s Shopify website.
  • In Shopify POS settings, mark orders automatically as fulfilled can be enabled or disabled (typically enabled if customers take their purchase with them upon payment). This fulfilled/not fulfilled status is passed to DEAR when the sale is downloaded to DEAR.
  • Shopify POS orders are marked as not fulfilled even if the POS setting is set to mark orders as fulfilled when there is at least one product with serial/batch costing method in the order. These orders must be manually fulfilled in DEAR.

More information:


Feature 9: B2B Portal – appearance redesign

Impact area: DEAR B2B Portal.

Introduction: Some improvements have been made to the appearance of the B2B portal. The changes will not affect users’ own customisations.

Pre-conditions: Active B2B Portal.


  • The default B2B portals have been changed. This will not affect existing custom colours set by users, new colours will be applied only to new stores. Users can restore all colours to default by clicking Restore all colours in the Appearance tab of B2B portal settings.
  • Quick view has been implemented for product items in the catalog so the customer can see some information about the product and add it to the cart.
  • Previously, the vertical Navigation bar could only display either Categories, Tags, or Brands. Now all three options can be included on the navigation bar together.

More information:


Fix: Allow editing sale order/invoice prices when Allow Editing Authorised Documents permission is Full Access

Impact area: Sale module.

Functionality: Fix has been applied to allow editing sale order and sale invoice prices when Allow Editing Authorised Documents permission is set to full access.

Recent Posts

Blog post 8 Reasons to Switch From PC to a Tablet POS System

31 Mar, 2023 | Purchase

Read more icon
Blog post Everything you need to know about last mile delivery

24 Mar, 2023 | Business Tips

Read more icon
Blog post How to find the right type of warehouse for your business

22 Mar, 2023 | Uncategorized

Read more icon
Blog post The 5S method of warehouse management explained

21 Mar, 2023 | Business Tips

Read more icon

#1 Rated Cloud ERP Software in USA

Get a big picture view of your business, without losing sight of the details. DEAR makes enterprise-level inventory management, manufacturing, sales channel integration, reporting and more accessible to businesses of all sizes.

Start Free 14 Day Trial
Dear Systems Dashboard