ONE.Source | Blog

Useful SAP Business One Queries: Comparing Monthly Sales Across Multiple Years
Richard Duffy
Richard Duffy in SQL Queries, Microsoft SQL Server June 26, 2018

Useful SAP Business One Queries: Comparing Monthly Sales Across Multiple Years

For many businesses, one of the foremost reporting needs is to measure monthly sales throughout the year and compare those results to the previous year. This fundamental analysis of whether sales are trending up or down is often the starting point for discovering important insights that shape your path forward.  

For SAP Business One customers running on Microsoft SQL Server, the easiest way to begin this analysis is to extract the relevant data through a SQL query. From there, you can visualize and analyze the data using Microsoft Excel or..

Read more...

SAP Business One 9.3 is Now in General Availability

Exciting news for SAP Business One customers! Yesterday, SAP announced the general availability of SAP Business One 9.3. This release is available on both Microsoft SQL Server and SAP HANA databases. 

Read more...
Useful SAP Business One Queries: When Did Your Customers Last Purchase from You?
Richard Duffy
Richard Duffy in SQL Queries, Microsoft SQL Server January 25, 2018

Useful SAP Business One Queries: When Did Your Customers Last Purchase from You?

Part two of our series on useful SAP Business One queries. If you missed part one, sales orders with multiple deliveries, you can access it here.

Today's focus is on query that can help you identify customers that haven't purchased from you in a certain amount of time.

Read more...
Useful SAP Business One Queries: Sales Orders with Multiple Deliveries
Richard Duffy
Richard Duffy in SQL Queries, Microsoft SQL Server January 08, 2018

Useful SAP Business One Queries: Sales Orders with Multiple Deliveries

In my role as SAP Business One Subject Matter Expert and Community Evangelist for ONE.Source (long title, I know), I help moderate our community forum. Each month, one of the oldest posts ranks as our most popular, both for ASUG members as well as those who stumble upon our community via search engines: Useful SAP B1 Queries from August of 2009. 

There are a number of queries shared throughout the thread, but the first query shared fits nicely with our inaugural Logistics month as we kick off our year-round curriculum for 2018. With that lucky..

Read more...
SAP HANA vs. SQL and Other Hot Topics: Stay Informed  with SAP Business One Webcasts from ASUG
Richard Duffy
Richard Duffy in SAP HANA, Webcasts, Microsoft SQL Server October 05, 2017

SAP HANA vs. SQL and Other Hot Topics: Stay Informed  with SAP Business One Webcasts from ASUG

As part of our normal program of benefits and education for ASUG members, we deliver regular webcasts on current topics of interest to our SAP Business One members. These sessions feature speakers from across the ecoystem: SAP, customers, software solution partners and, of course, from our SAP Business One subject matter expert — me.

In 2018, we will be focusing each month around a topic or theme, but you need not wait until next year to take advantage of these webcast opportunities. As a special invitation to the broader SAP Business One..

Read more...
About ONE.Source
Community Forum
Membership-Internal-Ad.jpg
300x300-B1-Blog.png
2018_Talent_Hub_300 (002).jpg
*