- Last Updated: 17 May 2017 17 May 2017
Easier access to Dear Inventory advanced pricing
Dear Inventory has a powerful advanced pricing module in addition to the standard ten price lists and customer-level discounts. Not many clients use the advanced features because it's hard to understand and hard to set up; for example, the second step requires a CSV upload in many cases.
Dear has now put a graphical front end to advanced pricing, making it easier to use.
What is 'advanced pricing'?
The advanced pricing rules can either provide over-riding prices, that is, the rules acts like a new price list, or they can merely modify the price the customer was going to receive anyway (discounts for higher order quantities, for example).
Advanced pricing is also the only way you can make special pricing for some but not all products for some but not all customers. Finally, the rules can have start and end dates, something else you can't do with standard price lists.
The spur for this has been the drive to add B2B and later B2C portals to Dear, and there are some features added to the advanced pricing module which are only for these new sales channels.
There are two concepts: Discounts and Deals.
The 'Discount' says what will happen, and the Deal defines when it happens, based on the date, the customer and the product.
The rules have start and end times (for promotions) and can trigger on products based on SKU, tag, brand or category, and on customer code, customer type or tag. That's very powerful.
You can access it via Settings -> Reference Books -> Product Deals. Although first, you need to define a Discount rule to add to the Deal.
To use it:
The new form lets you apply a discount to some customers for some products, over some period.
You need to create the "discount" first, though.
Also, you must click the "Apply Discounts" button in order entry. I don't know why. I guess this is a transitional setting.
Step 1: Create discount rules
Creating discounts is done in Settings -> Reference Books -> Stock -> Product Discounts
There are three types of discounts, but 'Free Shipping' and 'Order Level' are only applicable to the Dear B2B portal.
So for the usual Dear order flow, you consider "simple discount" and "volume discounts". Volume discounts are commonly known as quantity breaks. The "volume" refers to the quantity sold on the order line.
The Dear support article is: http://dearsystems.freshdesk.com/support/solutions/articles/1000132666
"Discounts" are the "what happens" part.
Simple discounts are the most common.
The discount and markup rules apply to the price the customer would get if the discount rule were not applied.
From the Dear article:
Types of Discount values:
- Discount amount – all prices will be reduced by this Amount, e.g. ‘$10 off all stock’ campaign. That is, the change modifies the price calculated by the standard pricing (based on the price list and any customer or product discounts).
- % Discount– all prices will be reduced by the percent specified, e.g. ‘10% off all stock’ campaign.
- Markup Amount – all prices will be increased by this Amount.
- % Markup – all prices will be increased by the percent specified.
- Price Override –this Amount is new price for the product, with no reference to what was there before.
- Flat Amount – total line cost will be this Amount.
Note that Flat Amount caps the line price, completely regardless of quantity ordered.
Step 2: Create Deals
This step is not documented by Dear yet. A Deal lets you choose when a discount rule is triggered.
Deals also include new functionality for "order-level" discounts, which is not documented yet. Probably it is designed for the next round of improvements to the B2B and eventual-B2C portals. I have tested if this module works with the POS module.
- Last Updated: 17 May 2017 17 May 2017
Allocation Logic in Dear Inventory, explained
Dear Inventory has two order flows, Standard and Advanced. They both let you prioritise stock with soft and hard allocations if you use manual picking. The Advanced module has another option: authorised orders with no allocation at all. In this article, we see the differences between soft and hard allocations, and how to override soft allocations to prioritise which customers get scarce stock.
You can swap a Standard order to Advanced. An order created in the standard process can move to the Advanced process via the Convert button. See the picture below.
- Last Updated: 16 March 2017 16 March 2017
Some tips on getting per-location costing in Dear Inventory for more accurate margins.
Dear Inventory is a cloud-based inventory system which is currently GrowthPath's default recommendation for general purpose cloud ERP systems.
Dear has a well-thought approach to stock valuation. From the beginning Dear was designed to give users the chance of activate batch and serial number tracking for receipts, and Dear decided to fully support this with FIFO product costing per batch or serial. In fact, Dear users FIFO costing as its costing method for standard stock as well; the common choice is weighted average. FIFO and weighted average are the same over time.
Like its competitors, such as Unleashed, Trade Gecko and Cin7, Dear allows multiple locations, but it does not keep costs per location.
Imagine that you are receiving stock into an Australian warehouse and a New Zealand warehouse from a Chinese supplier. You may have the same FOB price, but different landed costs. Dear handles landed costs very well and they are practical to use, so you would like to see different costs at the two different sites. However, if you have a standard product without batch or serial, the FIFO calculation is maintained across all locations: the next item you sell with have the same cost price regardless of the warehouse it is shipped from. Not what we want.
But if you activate batch costing for this product, you can solve the problem. When you receive goods, you provide a batch number. You can leave it blank, and Dear will create a batch code based on the PO number. If you apply landed costs to the order, they are also tracked against the batch. Because the batches are stored by location, shipments from the NZ warehouse will only involve batches received there. Auto-pick is smart enough to manage that if you don't want to manually choose batches.
With this approach, costing per warehouse is quite easy, and you will have more meaningful margins. The one thing we can't do with this is keep NZ stock in NZD: if AUD is the base currency of the system, stock with supplier and third party costs in non-AUD is converted to AUD and only AUD. There is no solution.
A note about Dear's landed costs: costing is updated retrospectively, so with Dear, you can receive and ship goods without waiting for supplier and third-party invoices, and still get the benefit of landed costing.
- Last Updated: 13 March 2017 13 March 2017
Applying relevant information to make better decisions is a very important outcome of a medium-term IT plan. Cloud solutions are really good at enabling this, even if the first phase focuses more on the operational foundations. There are many options available for cost-effective business intelligence solutions in the cloud. Amazon, for example, has developed a rich layer which has stimulated many offers: Google for “Amazon Redshift marketplace”.
Advanced reporting, or business intelligence, has three components. It has a reporting or data visualisation front end (graphs, dashboards, reports etc). It has a data store and analytical logic layer, which imports data from different sources and allows us to group and relate the data to support the visualisation layer. Business Intelligence products always include these two layers. Many of the cheaper cloud solutions, such as Zoho Reports, effectively stop with these two layers.
The third layer is very important. Technically it is know as Extract and Load, (or data transformation). This retrieves the data and processes it ready for import. It would certainly include sales data at the invoice line level, but may include other data such as Google Analytics, Facebook analytics, marketing spend, out-of-stock scores, inventory aging KPIs etc. Extracting that data is some times not simple. Possibly you have sales data coming from different systems (perhaps due to an acquisition): this extract and load layer needs to standardise the data into a common format.
The benefits from this phase really leverages the investment in the cloud-based foundation layer; it taps the potential of cloud-based systems … for a fairly small incremental cost, there is a lot of value.
- Last Updated: 10 May 2016 10 May 2016
A hidden gem: Neto/Saasu Integration
Neto is an excellent hosted online store. It handles wholesale and retail very well (simultaneously), and has the best-on-the-market integration with Australian shippers, anywhere. Better than Unleashed, Dear Inventory, Shopify ...
On top of that, Neto looks after multiple price lists, variations, multiple stock locations,has a decent template engine, a fast backend, good ebay integration. It does backorders like MYOB, which is actually much more suited for smaller wholesalers than the current approach of Dear and Unleashed. A startup from Queensland with Telstra as a significant shareholder. It's not perfect: It doesn't do multi-currency, its reporting is average. And it has no purchasing module. It doesn't do supplier invoices, receipts and costing. For this, is expects you to integrate it with something else. A Neto / Saasu integration offers a lot for the money.
- Last Updated: 05 May 2016 05 May 2016
Common questions about cloud ERP
Cloud ERP (Dear Inventory, Unleashed, CIN-7, Trade Gecko, Stitch...) has huge advantages: fast to deploy, easy to learn and with much better reporting and insights that traditional ERP software. Above all, these packages integrate so easily with CRMs, accounting, online stores, third-party fulfilment, shippers. The business model is different: you pay per month, you no longer host the data. Here we quickly cover the main questions, advantages and disadvantages of cloud ERP for SMEs.
We have a much more in-depth review of common cloud ERP solutions here: A review of cloud ERP for Australian SMEs
- Last Updated: 04 March 2017 04 March 2017
Here is the IT in use at GrowthPath.
Since our foundation, GrowthPath has used cloud accounting. Initially we used MYOB Essentials, then Saasu, and as of 2016 we are on Xero.
CRM and Project Management
We use Pipedrive. Pipedrive is an excellent CRM for deal-based businesses.
We have become big fans of Trello.
Quotes are prepared with Nifty Quoter.
Email & Cloud Apps, Client OS
We use Google Apps/Google Drive. Desktop OS is a mix: OS X preferred, Chrome OS and Windows get some use. Mobile devices are now mostly Android.
Web services, Analytics
We have servers, and client servers, hosted with AWS and Digital Ocean. We use Ubuntu as the platform of choice. We use namecheap for SSL certificates, and a variety of registrars for domain names. Analytics is 100% Google.
GrowthPath uses Joomla, self-hosted, although we have good Wordpress skills.
GrowthPath does not currently use any paid traffic generation techniques. Our SEO is good and organic traffic is sufficient.
- Last Updated: 24 May 2016 24 May 2016
Business risks of cloud software
Cloud software has security risks, data-lock-out risks and connectivity risks. These risks can be avoided, and cloud software eliminates other major IT risks. Overall, moving to cloud apps such as Xero probably increases overall security and lowers data risk if sensible policies are in place. Before moving to cloud accounting such as Xero, or to a cloud ERP system, it's worth reviewing these risks.
- Last Updated: 04 March 2017 04 March 2017
Xero Transaction Limits and larger businesses
There are questions about how well Xero performs under "higher loads". Our first concern was for medium-sized wholesalers. Xero talks about limits as low as 1000 'transactions' a month. Our testing shows that Xero performs well at much higher transaction volumes. The first test results are based on 3 years of 2500 transaction rows per month (and then matching payments uploaded via a bank CSV). The second test run was much larger.
Note that after some discussions with Xero and based on our own experience, we (GrowthPath) believe that businesses can interpret the 'limit' of 1000 invoices a month as advisory. This limit does not form part of the terms of service. In Jan 2017 Xero published some small changes to the API limit, and these limits, which are enforced, allow a much, much higher load than Xero's advisory limits. Hence, stress testing is relevant because you will reach the practical limits of Xero before you exceed API limits. Exactly what are those practical limits? That's the point of this article.
For a medium sized wholesaler, we assume that Xero is the backend to a cloud-based inventory package, such as Unleashed or Trade Gecko, so we did not use Xero's inventory module.
Compared with a B2C (retail) business, a wholesaler has fewer customers, fewer invoices but invoices which have many more lines. Most sales are on credit, so reconciliation of bank feeds is important.
Testing was carried out in June 2015 with a standard Xero trial account. Browsers used were Firefox and Chrome on a Macbook. Data was imported with CSV files, and some browser automation was done for bank recs and document approvals, using Python & Splinter. We also did some uploads via the API mainly to load Xero for testing.
- Last Updated: 12 January 2017 12 January 2017
Cloud ERP inventory for wholesalers, manufacturers and importers
Unleashed, Dear Inventory, Cin7 and Trade Gecko compared and reviewed, in a nutshell
GrowthPath has migrated clients in Singapore, New Zealand and around Australia to cloud ERP solutions. The clients left MYOB and other legacy systems for cloud-based accounting and supply chain solution (ERP). We have success with Xero + Unleashed, Xero + Dear Inventory and Xero + Cin7. At the moment, we recommend Dear Inventory for most clients needing a supply chain solution. We find it clearly superior to Unleashed except in certain backorder workflows; the reasons are below. Cin7 is a much more expensive but much more capable solution. Trade Gecko has fallen off GrowthPath's radar, which we will aim to fix.
Broadly, Unleashed, Dear Inventory and Trade Gecko are competing for the same target market. They are good general purpose supply chain solutions for wholesalers, and they provide a number of integrations for e-commerce sales channels and cloud CRMs.
Cin7, in my opinion, targets more complex businesses. It is more difficult to use and considerably more expensive, but it has features not found elsewhere, such as some multi-entity support, EDI and forecasting, and the best POS and B2B portal, a mobile-friendly Pick & Pack module and more rigorous accounting integration tools. Cin7 currently prices by turnover and users, unlike its competitors, which price purely by users. Cin7 offers both deeper ERP functionality and much broader functionality. It is the only option if you want to weight landed costs by dimensions (weight and volume), for example. It has better multi-entity support. In terms of broader functionality, it offers EDI and forecasting, includes goods POS and B2B portals, a mobile-friendly Pick & Pack module, a basic CRM and rigorous accounting integration tools. Cin 7 is more open to customising functionality.
Unleashed has the best user interface. Dear is radically overhauling its interface in the second half of 2017 so it is perhaps a bit harsh to judge until we see where it ends up, but it is the main product focus at the moment. The first phase of this was the introduction of an advanced sales module which enabled a more sophisticated multiple-fulfilment workflow and some faster processing of orders, but at the cost of losing bulk actions, so I think Dear users are looking forward to this being completed (and bulk actions coming back).. Trade Gecko's interface is quite nice, no complaints.
Cin7 has a complicated and information-dense user-interface, which is overwhelming but rewards those of us who take time to read the documentation. I suspect the developers have been the most influential rather the UI experts.
Who is moving to Cloud ERP? Not just MYOB upgraders.
It's not just a question of upgrading from MYOB. GrowthPath implements cloud ERP for businesses leaving SQL Server-based mid-tier packages such as SAP Business One, MYOB Exo, Prism and Attache. Integrated cloud ERP can't match the core accounting power of mid-tier systems such as multiple legal entities, but they have advantages in cost, speed of deployment and vastly superior integration with CRM and online commerce. They remove the need for servers and remote access, which are both expensive and security risks. Cloud ERP systems are much easier to use. Clients see a much greater use of features among staff because these systems are simpler to understand. New hires get up to speed faster, and existing staff get more information more quickly.
The heavy lifting is done by the cloud accounting and supply chain combination (the traditional ERP scope), commonly Xero + Unleashed, or Xero + Dear Inventory. The loosely coupled nature of the systems is not all positive, but as a business looks to add more automation and business intelligence to the way it works, the plug-and-play approach becomes vastly superior. SMEs can access IT as good or better than anyone had five years ago. This is an incredible levelling of the playing field between medium sized SMEs and large businesses. It's bad news for traditional ERP vendors. The functionality gaps are closing fast and in core ERP and fulfilment, there are already clients leaving legacy ERP who don't find any backwards steps. The rate of innovation in the cloud ERP is concentrated among a small number of products, unlike the hundreds of SQL Server-based ERP choices, which means potential clients are getting a lot more innovation bang-for-buck.
- Last Updated: 29 November 2017 29 November 2017
It's great to have a well used accounting system quietly gathering thousands of data points about your business. Your bank transactions. Your invoice detail lines. Your purchases. Your stock movements. Your postage and electricity costs. The location of your customers. Their history with you. And so on.
But how to turn it into profitable insights?
- Last Updated: 02 April 2016 02 April 2016
A tutorial about accessing data from MYOB Premier using SQL.This technique opens up much better insights, interactive reporting and feeding data into dashboard tools, as well as making data migration into a new system much easier. You can also automate or partially automate intercompany reconciliations, and detailed cashflow analysis.
- Last Updated: 04 March 2017 04 March 2017