Dynamics GP
Dynamics GP
Organizer:
- Organized by
-
-
Reply To: GP 18.6.1695 (2023) Sales Cards Customers Deletion
-
I would advise against removing vendors and customers. And I’m not sure a delete would work in the user interface even if we archived many of your old sales.
You can mark them as inactive, with a SQL script, and then we can set the vendor and customer lookups to ignore inactive master records.
Other than that, I can suggest a new GP company where you only move over the data from the last 10 years – including customers, vendors, inventory and GL accounts – this will clean GP up nicely and you’d still have all of the records in the legacy company.
The only other option, which I HIGHLY discourage, would be to run a delete statement in the vendor and customer tables removing those entities. The only problem with that is you will likely get an error message in GP if you try to view anything or report on anything that these master records existed on.
