ASUG Blog

Useful SAP Business One Queries: When Did Your Customers Last Purchase from You?
Richard Duffy
Richard Duffy in SAP Business One, SQL Queries 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 SAP Business One, SQL Queries 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...
2018_Talent_Hub_300 (002).jpg
Subscribe to First Five Newsletter
Membership-Internal-Ad.jpg
*