2,935
I have created a smartlist under fixed assets book. I need to add a column for account group. I don't see this option. was going to create one in smartlist builder but can't figure out what table the account group for each asset is stored in.
thanks
Rachel
*This post is locked for comments
Rachel - I think this might be what you're looking for.
The Default Account Group ID, is maintained at the Asset Class ID Level, I linked the Asset Class table to get to the Default Asset Group ID.
select a.ASSETID,a.ASSETDESC,ag.ACCTGRPID,ag.ACCTGRPDESC,* from FA00100 a
inner join FA40201 c on a.ASSETCLASSID = c.ASSETCLASSID
inner join FA41300 ag on c.DEFACCTGRPINDX = ag.ACCTGRPINDEX
I believe Rachel is shedding a light on an important point in here. Unlike other modules in Dynamics GP which commonly have a consistent and common behavior; such as the "Parent-Child" relationship of the class and its associated sub entities (Items, Customers, Vendors ...etc), the fixed asset module goes against the flow. Several other "inconsistent" behavior characteristics are clearly seen as well such as the FA GL posting which is processed before the journal entries are generated on the General Ledger level.
I do understand that this is the behavior of the module and is usually justified by the fact the Microsoft brought it into Dynamics GP to be part of the ERP system as a whole, several enhancements have been introduced which I personally admire. Although, I still wish to see to same behavior of the other modules prevailing in the Fixed Asset module.
Regarding the account group point, I have heard several justifications about the fact that the current behavior is the correct one. I would humbly disagree as I do believe that the same parent-child relationship should be applied to ensure that any changes on the account group is to be rolled down to the entities within this group. Furthermore, why not to have a class and associated accounts (as it is with the vendor class, item class and customer class ), and then just to have the asset assigned to a class which shall roll down all the parent characteristic !
The bottom line is, as Mr. Frank said, this is not going to be "fixed" as it is the normal behavior of the module. Therefore, workarounds are born
Rachel, this is not something that's going to be 'fixed' as it is normal behavior in GP. However, if you have a GL account that is specific to each of the Account Groups setup in your system, you could pull the Account Group ID into a SmartList based on that unique Account for each asset. For instance, if your Asset Cost account is the same for every Furniture and Fixture asset, you could link that account index back to FA41300.ASSETCOSTACCTINDX and pull the Asset Group ID in that way.
I need the actual account group name in the smartlist for sorting purposes. We sort the assets by the account group name to tie to the GL. I think we will add the account group name to the physical location id field since they are not using that field and it can be pulled into the smartlst. There is room for error though if the account group gets changed and the physical location id does not. Can't wait until this is fixed so annoying that you cannot see which account group id is linked to the asset.
The Asset General Information are stored in the table FA00100 and Account information are stored in the table FA41300. These two are separate table and stored the values separately. While you choosing account group id , the account number values will be stored to the asset account table without account group id. If you change the account group id, the account number for the asset will also change.
Hope this helps!!!
Rachel,
The account group is not actually stored with an asset, it is only used to initially populate the account numbers when as asset is created. If you open an existing asset you will see the account group ID is blank.
You could possibly link to the account group ID from the Asset Class, but there is no guarantee that the accounts on the assets are the same.
An alternative would be to use something like the code I have here to get the actual account numbers for each asset: victoriayudin.com/.../sql-view-for-asset-account-numbers-in-dynamics-gp.
Share
Report
All responses (
Answers (
