Customer Purchase Prompt Report
  • JeffG
    Posts:91
    Joined:Sat Aug 31, 2013 6:50 pm
    Location:Sydney
    Customer Purchase Prompt Report

    by JeffG » Tue Feb 03, 2015 7:01 pm

    Hi All,

    I want to design a report that will prompt my staff when a customer is next due, based on past purchase history, to order a specific item.

    For example if a customer buys the same item every two months, then for some reason three months have passed and the customer has not re-ordered, I want that item to appear on a report so my staff can contact the customer and seek a sale.

    Any ideas?

    I am very good with Access and Excel, but just cant seem to nail this one.

    Thanks in advance.
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Tue Mar 03, 2015 7:19 pm

    The information you require is found in the table CRMHIST. This table contains the product code, date, quantity purchased, who it was sold to, and so on. Working out a sensible tactic for inspecting the data inside the table would be the challenge.

Who is online

Users browsing this forum: No registered users and 4 guests