DynamicAccounting.netYou, Me, and Dynamics GP

2012-11-26 · 2012

Weekly Dynamic: Clear Data Physical Tables

Tips & Hidden FeaturesSQL & Data

Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

There are a few cases where it makes sense to clear data from tables in Dynamics GP. The classic case is when testing something like loading Fixed Assets into a test company. You may need to load, adjust, clear data and reload several times.

When you open Dynamics GP > Maintenance > Clear Data you get a list of logical tables to clear. Logical tables can actually include more than one table. To clear just a specific table, click Display and select Physical. This provides a list of physical tables that you can select to clear.