Reply To: GP 18.6.1695 (2023) Sales Cards Customers Deletion

  • Jo deRuiter

    May 3, 2024 at 7:34 am

    Hi @bctaittaitdistributors-ca

    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.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!