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

Thanks

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
3