About David Brennan

This author has not yet filled in any details.
So far David Brennan has created 56 blog entries.

Clients First Achieves Highest SAP Business One Customer Retention

Clients First Business Solutions announced today that it has been honored at the 2019 SAP Innovations Summit for achieving the highest customer retention rate of any partner in North America. "Clients First places a heavy emphasis on ongoing customer communication," Ryan Howe, Managing Partner of Clients First Business Solutions, said. "We have invested significantly [...]

2019-07-09T05:48:01-08:00June 25th, 2019|General ERP articles|Comments Off on Clients First Achieves Highest SAP Business One Customer Retention

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-02-25T07:09:56-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-02-25T06:49:47-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?

SAP Business One Reaches Major Milestone

SAP Business One, the comprehensive Enterprise Resource Planning (ERP) suite, has just reached a major milestone, surpassing 60,000 customers worldwide. This makes Business One the most popular of SAP’s current product lineup. In context, over 1,000,000 users from 60,000 firms in 170 countries are currently running B1. As the user base grows, SAP continues to [...]

2019-06-14T03:57:18-08:00June 28th, 2018|SAP Business One|Comments Off on SAP Business One Reaches Major Milestone

Using Reference Field Links in SAP Business One

Have you ever wished you had the power to CHOOSE what information gets added to the journal entries that are created by documents? If the answer is YES, then you will be ecstatic to know that now you get to decide what additional information can be brought over to the journal entry by using SAP [...]

2019-06-14T03:56:52-08:00January 23rd, 2018|SAP Business One|Comments Off on Using Reference Field Links in SAP Business One

SAP B1 Report – Production Order Status for related Sales Orders

In SAP Business One, you have the ability to link Product Orders to Sales Orders. Additionally, at release 8.82 of SAP Business One, the Procurement Confirmation Wizard can automatically create Production Orders directly from Sales Orders, or after Sales Orders have been posted. However, this is not a report that list all Production Orders associated [...]

2019-06-14T04:00:39-08:00March 3rd, 2016|SAP Business One|Comments Off on SAP B1 Report – Production Order Status for related Sales Orders

SAP Business One – Sales Summary total for last 24 hours

Sales Summary total for last 24 hours This query in SAP Business One returns 1 value, the total sales dollars in the last 24 hours. This is a great query to turn into an alert, or use in a Dashboard on release 8.8 or SAP Business One. SELECT sum(T0.[DocTotal]) AS 'SO$' FROM ORDR T0 WHERE [...]

2019-06-14T04:01:06-08:00February 3rd, 2016|SAP Business One|Comments Off on SAP Business One – Sales Summary total for last 24 hours

SAP Business One – Query – Production Planning Board

Query - Production Planning Board SAP Business One Production Production Planning Board. This is a great report and drill down, providing production planners a tool to help manage their planned and released production orders. SELECT T3.[CardName], T3.[CardCode], T0.[DocNum], T0.[Status], T0.[ItemCode], T0.[DueDate], T0.[PlannedQty], T0.[CmpltQty], T0.[RjctQty], T1.[ItemCode], T1.[PlannedQty], T2.[OnHand] FROM OWOR T0 INNER JOIN WOR1 T1 ON [...]

2019-01-16T11:22:41-08:00January 11th, 2016|SAP Business One|Comments Off on SAP Business One – Query – Production Planning Board

SAP Business One – Query Generator

Sub Queries can be extremely useful. Let’s say you want to get a list of business partners (Customers) who have ordered 1000 or more cases of your products in total. Because your report would be getting data from the RDR1 table, without a sub query, the best you could do is sum quantities for all [...]

2019-01-16T11:22:41-08:00November 24th, 2015|SAP Business One|Comments Off on SAP Business One – Query Generator

SAP Business One – Change Item Descriptions

SAP Business One Change Item Descriptions on Marketing Documents Did you know that you can change an item description on all marketing documents such as Purchase Quotations, Goods Receipt, Goods Returns, AP Invoice, Sales Quotations, Purchase Orders, AP Invoice, Sales Orders, Delivery Notes, etc?) This nice feature is either forgotten or never learned by many [...]

2019-01-16T11:22:41-08:00October 12th, 2015|SAP Business One|Comments Off on SAP Business One – Change Item Descriptions

SAP Business One – Incoming Payments with Payments On Account

SELECT T0.DocNum AS 'Inc Pay Numb', T0.DocDate AS 'Post Date', T0.CardCode AS 'Cust Numb', T0.CardName AS 'Customer Name', T0.DocTotal AS 'Total Check Recd', T0.NoDocSum AS 'Overpayment' FROM ORCT T0 WHERE T0.[NoDocSum] < > 0 AND T0.DocTotal < > T0.NoDocSum AND T0.DocDate >= '[%0]' AND T0.DocDate ORDER BY T0.CardName, T0.DocDate FOR BROWSE We hope you find [...]

2019-01-16T11:22:41-08:00September 28th, 2015|SAP Business One|Comments Off on SAP Business One – Incoming Payments with Payments On Account

SAP Business One Reaches Milestone

SAP AG (NYSE: SAP) announced their 40,000th customer with the selection of SAP® Business One by 4G Identity Solutions Pvt. Ltd.  A pioneer in providing large scale biometric identity management solutions, 4G Identity Solutions was interested in streamlining critical business areas, including accounting, finance, HR, sales, customer relationship management, and purchase and inventory management  The [...]

2019-01-16T11:23:58-08:00October 4th, 2013|SAP Business One|Comments Off on SAP Business One Reaches Milestone

Multiple Units of Measure – SAP Business One 9.0

Multiple Units of Measure using SAP Business One 9.0 is what we will discuss in this post.  SAP Business One 9.0 (now available) contains enhancements and additions meant to support the growing needs of the small and medium enterprise companies.  So, what’s new in SAP Business One 9.0? Single UoM’s can be grouped together as a [...]

2019-01-09T11:37:17-08:00August 4th, 2013|SAP Business One|1 Comment
>