SQL view for last sale by customer and item | Victoria Yudin

SQL & Data Payables & Receivables Sales, Purchasing & Inventory

Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

Victoria Yudin delivers a new SQL view for last sale by customer and item. This got me thinking. With this as a base, I could figure out an average time between orders and then flag customers for followup if they haven’t ordered recently. hmmm…

Original article: https://victoriayudin.com/2011/03/29/sql-view-for-last-sale-by-customer-and-item/