Inventory Allocations in Acumatica
With almost all of our clients I have worked with in the past, Inventory Allocations have been one of the more vital pieces of data end-users work with on a daily basis…. not only for allowing their customer’s calling in for product to know what is available to be...
read more
How to Fetch FIFO Cost in NetSuite Based on a Date
This blog post is about fetching FIFO cost in NS based on a particular date. Currently NS does not seem to have an option to directly show the FIFO cost for an item (and also bin if required). The saved search below also helps to find out the stock of an item as of a...
read more
Steps to be an Effective NetSuite Trainer
As a MIBAR consultant I have the privilege of training staff in the NetSuite environment and this is a role that I enjoy very much. Training is an important part to the implementation as it involves your staff and their buy in to the new software. To be an effective...
read more
Set Values of Every Column to the Appropriate Non-Null Default
Ask any SQL developer to tell you about what is more exasperating than having to account for dividing by zero and they’ll probably say the word “null”. Dividing by zero can be handled with a simple CASE statement, but unless you’re calculating gross profit % on an...
read more
Don’t Believe These Acumatica Cloud ERP Myths
You may be worried that ERP software is too great of an investment for your growing company. Don’t fret--Acumatatica’s cloud-based ERP has something for every-sized business, as it can be scaled to suit individual needs. If you haven’t introduced cloud-based business...
read more
What is Multi-factor Authentication?
Multi-factor authentication is a security model to identify a user and grant them access only after successfully presenting two or more different pieces of evidence (factors) to a particular authentication mechanism. A user provides something they know (a password)...
read more
Digital Transformation and the CFO
What does digital transformation mean to the modern CFO? With user-friendly visibility available thanks to today’s cloud-based business systems, the finance function is evolving and CFOs will need to create a road map for digital transformation. It’s a journey that is...
read more
Preserving Carriage Returns While Integrating Data From a Legacy System to NetSuite
Preserving carriage returns in item descriptions when transitioning from a legacy system to NetSuite can be tricky. Below are the steps I use to accomplish this. Export the data to a CSV from the legacy system with a special character like the pipe or a tilde...
read more
Error While Restore SQL 2008 Dynamics GP Database From Backup
When performing a full restore over an existing database, SQL Backup sometimes reports that the database cannot be restored because it is currently in use. This error shows not only during restore backup, but also for drop database or alter database as well. In this...
read more
What’s Next for ERPs? Artificial Intelligence and Machine Learning – Part 2
In our previous post, we explored the powerful technologies of artificial intelligence (AI) and machine learning (ML), and how they’re making their way into modern, cloud-based ERP systems. Growing businesses are adopting cloud-based technology to scale operations,...
read more
