General ERP articles

general erp articles

Is your ERP helping or hindering your E-Commerce operations?

The growth of E-commerce has rewritten the books on retail business. In 2017, online E-commerce sales represented 49% of the growth for the retail sector. The result was over $450 billion spent in one year, a six-year high within this industry. With the continued erosion of brick & mortar retail sales in favor of online [...]

2019-08-19T07:41:36-08:00April 11th, 2019|General ERP articles|Comments Off on Is your ERP helping or hindering your E-Commerce operations?

How Power BI and OLAP Cubes improve your business

The way businesses use their data has continuously changed. Once, it was acquired and accumulated in your internal servers. Now, such information has taken on an entirely new dimension within day-to-day operations. Data is now becoming part of major decisions undertaken by firms in various industries. To accomplish this, visualization tools are needed to transform how your [...]

2019-04-11T05:16:33-08:00April 1st, 2019|General ERP articles|Comments Off on How Power BI and OLAP Cubes improve your business

What are PowerApps

Business software is made for a wide range of companies and industries to fulfill multiple needs. Yet every firm is different and has unique processes they perform regularly to achieve their goals. Now with PowerApps, you have a way to easily create purpose-built business applications for your specific organizational needs that fit according to your [...]

2019-07-19T11:28:08-08:00March 29th, 2019|General ERP articles|Comments Off on What are PowerApps

Microsoft PowerApps: Canvas Vs Model-driven Apps

“There’s an app for that,” how many times have you heard this and thought it’s just too repetitive. An app for this and an app for that, what does it matter, it’s not helping you directly. With Power Apps, Microsoft has provided a platform to create custom applications (Mobile and Desktop). Requiring no heavy coding [...]

2019-08-06T06:59:48-08:00March 29th, 2019|General ERP articles|Comments Off on Microsoft PowerApps: Canvas Vs Model-driven Apps

Two Trends Shaping the Food Service Distribution Industry

Two Trends Shaping the Food Service Distribution Industry Over the years, Food Service Distributors have maintained a strong national presence. With sales over $280 billion annually and $51 billion in additional output, this remains a major industry. From restaurants and cafes to hospitals and health care facilities, many businesses depend on them to perform. As [...]

2019-03-12T12:34:56-08:00March 12th, 2019|General ERP articles|Comments Off on Two Trends Shaping the Food Service Distribution Industry

How to know when you’ve outgrown QuickBooks

A business is a well-oiled machine filled with various components that make it perform. Yet sometimes those parts start to wear out and break down over a period of time. For many startups, QuickBooks is the perfect resource for their financial needs. It’s simplistic architecture and functionality provides you with the right accounting tool in [...]

2019-08-19T06:53:28-08:00February 25th, 2019|General ERP articles|Comments Off on How to know when you’ve outgrown QuickBooks

Power BI: The add-on for every ERP system

Businesses rely on data to achieve their ultimate goals. Often, a key problem is information being scattered among different departments and lacking connectivity with each other. With the growing amount of data, trying to extract what you want for major decisions can be frustrating. Gaining insight from this knowledge is known as Business Intelligence and [...]

2019-08-19T07:14:42-08:00February 25th, 2019|General ERP articles|Comments Off on Power BI: The add-on for every ERP system

What is Microsoft’s Power Platform?

Since it’s introduction, Microsoft’s Power Platform has transformed how companies operate. With three distinct options, Power BI, Power Apps and Flow, this can reshape the way you compete and grow. Power BI If you’ve been in business a long time, chances are you have a lot of data. No matter how much you plan, its [...]

2019-02-25T06:38:59-08:00February 25th, 2019|General ERP articles|Comments Off on What is Microsoft’s Power Platform?

Using ODBC with SAP Business One via the Data Transfer Workbench (DTW)

Using ODBC with SAP Business One via the Data Transfer Workbench (DTW) If you’ve ever wanted to import data into Business One (B1) directly from another data source such as SQL Server, Access or some other data source that supports ODBC (Open Database Connectivity) there is a new article on how to do this as [...]

2019-06-17T04:10:19-08:00May 21st, 2018|General ERP articles, SAP Business One|Comments Off on Using ODBC with SAP Business One via the Data Transfer Workbench (DTW)

SAP Business One Add Actions to your HANA Dashboards

Are you already using SAP Business One dashboards? If you are, you will be fascinated that there is more information you can gather by adding “Actions” to your dashboards! These actions allow you to quickly gain insight from the data that displays in a dashboard. In the example below, I added the following “Actions” to [...]

2019-01-16T11:48:37-08:00May 1st, 2018|General ERP articles, SAP Business One|Comments Off on SAP Business One Add Actions to your HANA Dashboards

Free Copy of SAP Business One To Go for Version 8.8 Available

Free Copy of SAP Business One To Go for Version 8.8 Available We’ve just uploaded the latest version of the always excellent SAP Business One To Go document for version 8.81  This includes all of the latest capabilities and new functions.  You can think of this as the comprehensive product manual that doesn’t really exist [...]

2019-01-16T11:48:37-08:00May 21st, 2018|General ERP articles, SAP Business One|Comments Off on Free Copy of SAP Business One To Go for Version 8.8 Available

Auto Numbering Of SAP Business One Master Files

Auto Numbering Of SAP Business One Master Files In version 8.82, you are now able to auto number Master files – Customer, Vendor and Items. The screenshots below, display how to setup auto number for Customers. The same would also apply for vendors and items. To Start: Go to – Administration -> System Initialization -> [...]

2019-01-16T11:48:37-08:00May 21st, 2018|General ERP articles, SAP Business One|Comments Off on Auto Numbering Of SAP Business One Master Files

User Defined Prompts in SAP Business One Queries

Customizing the prompts in Business One Queries SAP Business one provides a powerful way to prompt users for parameters when running a query you define.  One tip is the ability to change the name of prompting text from the default to something more meaningful. This method, gives you the ability to define any table/field combination [...]

2019-01-16T11:48:37-08:00May 16th, 2018|General ERP articles, SAP Business One|Comments Off on User Defined Prompts in SAP Business One Queries

SAP Business One Common Table Names and Queries

/* Business Partners */ SELECT * FROM OCRD /* Chart of Accounts */ SELECT * FROM OACT /* Item Master */ SELECT * FROM OITM /* Terms Codes */ SELECT * FROM OCTG /* Business Partners and their assigned payment terms */ SELECT OCTG.PymntGroup, OCRD.* FROM OCRD LEFT OUTER JOIN OCTG ON OCRD.GroupNum = [...]

2019-05-14T09:51:09-08:00May 16th, 2018|General ERP articles, SAP Business One|Comments Off on SAP Business One Common Table Names and Queries

So You Want to Build Your Own PC? Tips for the Beginner

In this post, we invited a guest blogger, Jackie Edwards to write about the idea of building your own PC.  This is a surprisingly popular past time.  It's a great way for you or your children to learn much more about what makes that PC on their desk actually tick and is a way to [...]

2019-01-16T11:48:37-08:00May 26th, 2017|General ERP articles, SAP Business One|Comments Off on So You Want to Build Your Own PC? Tips for the Beginner

Upgrading from Microsoft Dynamics GP or SL to NAV

Microsoft currently offers four on-premise ERP solutions as well as two SaaS based solutions. The four on-premise (Which can also be hosted in the cloud) are: Dynamics Gl, Dynamics SL, Dynamics AX and Dynamix NAV.  The two SaaS solutions are Dynamics 365 for Financials and Dynamics 365 for Operations. In THIS article we go into [...]

2019-01-16T11:49:26-08:00April 26th, 2017|Dynamics 365 Business Central (Dynamics NAV), General ERP articles|Comments Off on Upgrading from Microsoft Dynamics GP or SL to NAV