Has anyone ever "hard deleted" an AR_Salesperson record?

We've gathered a collection of a few dozen salesperson records that essentially "dead" - meaning there are no open orders/invoices, there are no assigned customers or shipto records, no sales activity at all for years..... and they are starting to get in the way.

It's frustrating that Sage doesn't have a way to deactivate old salesreps or hide them (other than customizing views) so I spun up a testing environment to see what would happen if I deleted the AR_Salesrep record via Data File Display and Maintenance.

..... so far, it doesn't seem to have much of an impact....

  • I can still search by the (now deleted) salesperson code in Sales Order and Quote History Inquiry
  • I can still search by the (now deleted) salesperson code in Invoice History Inquiry
  • I was able to run the Salesperson Sales History By Period for the (now deleted) salesperson code and it reported correct totals.
  • I was able to run the Salesperson Commission Report for the (now deleted) salesperson code and it reported correct totals.

What am I missing? What other data / reports would be impacted by a hard-delete of a completely dead salesrep number? 

Thanks in advance for your help and advice! 

Parents Reply Children
  • in reply to Brett-AAG

    Any Sage report that links to the business object for AR_Salesperson would have unpredictable results for a missing SP record.

  • in reply to Kevin M

    OK so no problems running Customer Sales History or any of the other standard Sage reports.

    I was just overestimating the CPU resources of my test environment. I narrowed the parameters and was more patient with the next run, it completed with accurate data.

    It will still show totals for the deleted salesrep record.... it just isn't able to lookup the salesrep's name to populate it on the report next to the initials. 

    So far, so good - still looking for a reason NOT to do this but I haven't found one so far.

    These salesreps have unused since pre-2021 but just to be safe I think I might try to do July month-end early in the test environment to see if there are any issues.