Dynamics GP - Vendor DBA

If you've recently updated to Dynamics GP on the modern life cycle, you might want to take a minute and check out the new Vendor DBA function.

The latest version of GP includes a field called "DBA" in the Vendor Maintenance Options window (Purchasing>>Cards>>Vendor>>Options) where you can identify a single vendor DBA.

This field is automatically added to several reports including the vendor set up list and the 1099 forms (including the new NEC form).

For those of you who integrate or import data into GP for vendors, the field itself is called VENDDBA and lives in the PM00200 SQL table.

It is also important to note that according to Microsoft, no changes were made to account for this field in either eConnect or Integration Manager so if you utilize one of those for the integration/import be sure to account for the change properly!

For more tips and tricks be sure to follow our blog or on Linkedin.