Hi Alec, Thanks again for replying. I'm afraid not - I have lost all the history. I ran Change > Delete History / Clear Files last year sometime. I consolidated everything which was older than 2 years. When I run the below against the Pastel database I get absolutely no rows returned. I have no history for very old and redundant customer.
Code:
select * from HistoryLines WHERE CustomerCode = 'FLSM01' // ZERO rows returned
.
.
QUESTION: Knowing that I have no history, anyone got any idea on how I can zero this amount out such that:
- It no longer appears in my age analysis
- My reporting numbers don't get thrown out
- I can delete this customer once and for all
As always, thank you
Did you like this article? Share it with your favourite social network.