Exporting GeneralJournalEntry / GeneralJournalAccountEntry for trial balance to another environment

(0) Share

Report

Posted on by BrandonSA

1,673

I need to export Trial Balance information from one environment 'A' to another 'B'. ie. ALL data from GeneralJournalEntry and GeneralJournalAccountEntry from one environment to another. Since it's not wise to export these tables themselves from 'A' and import them into 'B', I thought it better to take the take the information from the GeneralJournal tables from 'A', export it as CSVs and then import the CSV into 'B' as new Journal's and post them there.

1) Is this the best way to do it

2) If this is the best way to do it, is there a method/way to retrieve LedgerTransType and LedgerJournalACType information from the PostingType found in the GeneralJournal tables.

I understand these tables partially, but not well enough to know that I'm not making a mistake here or that there isn't a better way. Any help would be much appreciated!

Thank you very much

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Kindly have a look at next thread.

community.dynamics.com/.../191178

It is possible to export balances/Trail Balance of one server and import it on second server, using General Journal, but definitely you will miss SubLedger entries. Don’t expect any details of Original documents such as vendor invoices, customer payments, sale orders etc. because by doing above practice you will be directly hitting GL accounts.

Was this reply helpful? Yes No
BrandonSA 1,673 on at

Like (0)

Report

Thanks Sohaib

In that thread you were very helpful in answering my question! Unfortunately, I need the sub-ledger entries though. The problem I'm struggling with now is how to use the Posting type of the GeneralJournal table to determine the correct LedgerTransType and LedgerJournalACType information so that I can re-post the record. And I want to avoid one massive switch statement that works out all the combinations. Any suggestions.

Thanks!

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

Unfortunately, I need the sub-ledger entries though.

If you need sub-ledger entries then, only possible way is to post transactions in proper way. E.g. take vendor invoices from one system and recreate/import on other system, post those. Similarly take all PO(s), SO(s), Payment(s), etc.

Regarding your 2^nd part of question, I am unable to get what do you meant by struggling with LedgerJournalACType. Seems you are trying to do something with code. If you can explain bit more, might be we can answer.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sohaib

did you get a chance to try using DIXF?. Using DIXF is should be possible since it doesn't affect any relational data.

Also, if you are able to understand the table dependencies you can even try with creating a custom definition group to export the data and import it to other environment.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

by the way, if you need everything from one server to other, why you don't think of a shortest solution such as Restore Database

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

@Manish

we are NOT talking about ways to import data. I do understand different ways to import data. we are talking about something given in question header.

Was this reply helpful? Yes No
BrandonSA 1,673 on at

Like (0)

Report

Sorry, my requirements aren't so clear.

All of this for the sake of keeping environments synchronized. I'm not sure why they don't run one AOS with different companies or why they don't have another solution or anything like that. But what I need to do is that when a transaction is created in 'A' (like creating a PO, Stock movement, Journal posting), it needs to push through to 'B' so that their trial balance still works. I need to take all transactions in 'A', in the GeneralJournal tables, and push them through to 'B', to it's GeneralJournalTables. This needs to be a solution that works everyday as they create transactions in 'A'. It's not a once off data migration exercise.

So I'm trying to use the data in the GeneralJournal tables in 'A', to create a CSV, which I push through to 'B', and then in 'B', reconstruct the journal data with AxLedgerJournalTable / AxLedgerJournalTrans, and then to post it there. My question is how do I set LedgerTransType and LedgerJournalACType on AxLedgerJournalTrans based on the posting type of the GeneralJournal data that comes in.

Of course, I probably making a really bad assumption that anything that exists in the GeneralJournal tables can be recreated using AxLedgerJournalTable. Please let me know if I'm way off course here...

Thanks for your help!

@Manish. The problem with DIXF is that when Journals are posted, there are so many side affects. I want to post records freshly so that I catch all of those side affects in the target environment.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report
Let’s go one by one for possibilities

Database Replication (SQL Replication )

This does not works perfectly with dynamics AX, it can bring issues. I have into this at past at one client.

Using import mechanism such as DIXF

This way can take a lot of effort. It’s not that we want to transfer only GeneralJournalEntry records. You also want to import sub ledger entries. That means you should start importing from sub-ledger to journal entries. Also prior to that you should import latest master data such as new customers, vendors etc. In short using DIXF or TDTT can be much time taking.

Using real-time integration, by x++ or AIF

This can be very costly as it may need a developer for many days, which should develop solution.

Using Database Restore

This can be least time taking but can always you need to restore back original metadata tables after restoring database(transactional)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sohaib,

How about using Test Data Transfer tool by Including only the required tables? This will take some time to identify the tables required.

Was this reply helpful? Yes No
BrandonSA 1,673 on at

Like (0)

Report

Hi Sohaib

You said "Unfortunately, I need the sub-ledger entries though.

If you need sub-ledger entries then, only possible way is to post transactions in proper way. E.g. take vendor invoices from one system and recreate/import on other system, post those. Similarly take all PO(s), SO(s), Payment(s), etc."

If i wanted to recreated every transaction that gets written to the GeneralJournal tables, then in how many different places would I have to capture transactions to re-post them properly?

Thanks

Was this reply helpful? Yes No

Community site session details

Exporting GeneralJournalEntry / GeneralJournalAccountEntry for trial balance to another environment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Exporting GeneralJournalEntry / GeneralJournalAccountEntry for trial balance to another environment

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates