Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
paulchacko 9/7/2017 11:04:53 AM

Fixed Assets Posting Edit List - how to identify Inactive account

Hi everyone,

When I attempt to post a Fixed Assets Batch, I get the message "You can not distribute to an inactive account"

So I ran an edit list [Fixed Assets Posting Edit List] to identify the inactive accounts but there are no indication of whether the account is active or not in the report. So then I edited the report in Report Modifier and added "Active" field from Accounts Master but when I run the report, it shows just an 'X' next to the account string. The whole report is 418 pages and it's not easy to identify them all.

So I exported the report into Excel as CSV but the report is messy and no way to sort them.

Any ideas how I can identify the accounts from the edit list whether they are active or inactive?

I am running GP 2013 R2


Paul Chacko

Version: GP 2013
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables