web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Intelligent Data Management Framework (IDMF) tool related query

(0) ShareShare
ReportReport
Posted on by 29

We are implementing Microsoft Intelligent Data Management Framework (IDMF) tool at our client's place. the intent was to archive the data from 2002 till 2013. initially we tried using the "ByFiscalPeriod" template, but it was observed that the template doesn't archive the data for tables like CustTans and VendTrans. The template ha sits own set of pre-defrined rules which we cant modify.

So we decided to use individual archive templates for the tables and created logical templates by selecting CustTrans, VendtTrans, GeneralJournalAccountingEntry tables as driver tables and modified them by adding rules such as "Archive the data from tables where transdate is < 12/31/2013". it did archive the data from tables but it archived the open transactions as well. That means if a vendor has an open transaction on 12/25/2013 then that also got archived which resulted in incorrect data in Source DB. The user wasn't able to see the transaction and couldn't make a payment against it.

Has anyone used the tool with AX 2012 FP CU7? is there any documentation available to create individual templates for archival which will allow carry forward of the balances of open transactions?

Any help is highly appreciated

-Tushar Joshi

*This post is locked for comments

I have the same question (0)

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Community Member Profile Picture

Community Member 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans