Fixed Assets Account Groups review?

[dbant2009]

I am trying to figure out a way to review the account groups that have been attached to an asset id. Once you select the account group and when the save button is pressed the account group disappears. I want to review the groups before I committ everything to the GL but can't find a way or report that will do this for us. Any suggestions.

 

[VictoriaYudin]

Since the account group is not saved, as you have seen, you would need to verify each account individually, instead of at a group level. The easiest thing might be to do this in SmartList - start with the Fixed Assets SmartList and add all the columns with a Type of Account Index.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[RobertC22]

Here is a query that will show the Account Group ID that the asset may have originally been based on.
It will only show an Account Group ID if the combination of account numbers is unique to an Account Group ID.
That is, you cannot have more than one Account Group Id with the exact same set of account numbers.

Trust this helps.

select 
	(
	select ACCTGRPID
	from FA41300 Grp
	where 
	Acct.DEPREXPACCTINDX = Grp.DEPREXPACCTINDX
	and Acct.DEPRRESVACCTINDX = Grp.DEPRRESVACCTINDX
	and Acct.PRIORYRDEPRACCTINDX = Grp.PRIORYRDEPRACCTINDX
	and Acct.ASSETCOSTACCTINDX = Grp.ASSETCOSTACCTINDX
	and Acct.PROCEEDSACCTINDX = Grp.PROCEEDSACCTINDX
	and Acct.RECGAINLOSSACCTINDX = Grp.RECGAINLOSSACCTINDX
	and Acct.NONRECGAINLOSSACCTINDX = Grp.NONRECGAINLOSSACCTINDX
	and Acct.CLEARINGACCTINDX = Grp.CLEARINGACCTINDX
and Grp.DEPREXPACCTINDX != 0 
and Grp.DEPRRESVACCTINDX != 0 
and Grp.PRIORYRDEPRACCTINDX != 0 
and Grp.ASSETCOSTACCTINDX != 0 
and Grp.PROCEEDSACCTINDX != 0 
and Grp.RECGAINLOSSACCTINDX != 0 
and Grp.NONRECGAINLOSSACCTINDX != 0 
and Grp.CLEARINGACCTINDX != 0 
and exists (
	select * from FA41300 Grp2
	where
	Grp2.DEPREXPACCTINDX = Grp.DEPREXPACCTINDX
	and Grp2.DEPRRESVACCTINDX = Grp.DEPRRESVACCTINDX
	and Grp2.PRIORYRDEPRACCTINDX = Grp.PRIORYRDEPRACCTINDX
	and Grp2.ASSETCOSTACCTINDX = Grp.ASSETCOSTACCTINDX
	and Grp2.PROCEEDSACCTINDX = Grp.PROCEEDSACCTINDX
	and Grp2.RECGAINLOSSACCTINDX = Grp.RECGAINLOSSACCTINDX
	and Grp2.NONRECGAINLOSSACCTINDX = Grp.NONRECGAINLOSSACCTINDX
	and Grp2.CLEARINGACCTINDX = Grp.CLEARINGACCTINDX
	having count(*) = 1
	)
) As GroupID
, Main.ASSETINDEX, ASSETID, ASSETIDSUF
from FA00100 Main 
join FA00400 Acct on Main.ASSETINDEX = Acct.ASSETINDEX

Robert

 

[dbant2009]

Thank you the query worked like a charm.