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

Notifications

Announcements

No record found.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans