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...
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...
About ONE.Source
Community Forum
Membership-Internal-Ad.jpg
300x300-B1-Blog.png
2018_Talent_Hub_300 (002).jpg
*