Notifications
Announcements
No record found.
Hi All ,
If we want to import the Fixed Asset master using Excel -addin what are all the tables need to consider ?
Thanks in advance.
*This post is locked for comments
Hi AXERP,
You need to have:
AssetTable
AssetBook (1 or more per Asset)
perhaps also
AssetDepBook (1 or more per Asset)
AssetLocation
This depends on the information you need to use.
Thanks Andre ,
Could you share me about the FA opening entries using Excel Addin ?
Thanks in advance
The best way is to use a fixed asset journal (or general journal) to create the opening balances for acquisition, depreciation and other possible revaluations.
The general journal service was not suitable in AX2012 to enter transactions on subledgers. I haven't checked if this is improved in AX2012 R2. Which version are you exactly using?
Version : AX 2012 R2 . I have checked in R2 , FA opening journal service was not suitable in AX2012 R2.
We have the assets almost 500- 700 , for these assets need to import the acquisition and depreciation entries .
Could you share me the best method which you prefer to import the entries ?
About a year ago, I managed to import it with the help of DMF. We used the first beta release and had to fix things to make it work for this customer.
I have not yet had the opportunity to check it again with the latest version of DIEF, but the base entity is: "Opening balance". This is an entity to import all Ledger journal related entries.
Hi Andre,
AX version : AX 2012 R2.
I have tried as you mentioned Using Opening balances in DIEF but
LedgerDimension: "Main Account"
DefaultDimension: "Business Unit-Department-Cost centre".
but when i import the dimensions are not updating in the general journal along with the account ,just it is updating accounts only.
What would be the problem ?
and if i take the format ledger dimension in the following way in the CSV file
Leder Dimension : main account number>-<CostCenter string>-<Department string,
in above format system is throwing the error to import the data .
Financial dimension 0 does not exist.
Could you help me how to resolve the problem ?
Please ask your questions per topic in a separate threads. The subject now changes as you are talking about Main accouts and not Assets. Also you asked the question twice. Should I answer twice as well?
For the error you mention, there is another thread stating it might be a standard bug.
community.dynamics.com/.../data-import-export-framework-financial-dimension-0-does-not-exists.aspx.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
Ali Zaidi 2
