upload of Trial balance

(0) Share

Report

Posted on by Chandrakala

180

1. Instead of doing day to day transaction in Dynamics AX, whether we can upload monthly trial balance at the end of every month to prepare the financials in Dynamias AX

2. Whether we can upload the closing balance of ledger directly to the system or should we take difference between closing balance and opening balance and variance upload as an adjustment entry through upload

3. Which functionality will allow technology team to upload trial balance directly to the system every month.

Please help me out for the above questions.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Chandrakala,

This question is related to your previous question. There are some additional questions, but I think still the same question.

The balances tables in AX 2012 are updated based on accounting entries. There are some features which will update or rebuild the balances based on existing accounting entries.

So you need to post a ledger journal to get the balances for your trial balance.

The advantage is that you can use the standard periodic job to create the closing and opening transactions. These are also input for your trial balance.

I would strongly recommend using journals and post the lines to get your report. I don't see any reason why having balances without also having the transactions.

You can use the excel add in with the General journal service or Data import export framework to import the ledger journal and then post them.

Was this reply helpful? Yes No
Suggested answer

Chandu Naresh 982 on at

Like (0)

Report
Copy link

Link copied!

Hi Chandrakala,

What is the purpose of direct upload? is it for Consolidation.

If it is for Consolidation, the Consolidation Company allows direct upload to do consolidation.

If it is through a company (Legal Entity), Then you could upload using the DIXF (Data Migration Framework) on a monthly basis using the entity "Opening Balances" in the required format

Was this reply helpful? Yes No
Suggested answer

Chandu Naresh 982 on at

Like (0)

Report
Copy link

Link copied!

When you are uploading the Trial Balance for the 1st time upload full balances

for all subsequent uploads, please make the differential upload. i.e., balances belonging to the particular period.

You can use Data Migration Framework (DIXF) for a monthly trial balance upload. The entity in DIXF is named "Opening Balances"

Was this reply helpful? Yes No
Chandrakala 180 on at

Like (0)

Report
Copy link

Link copied!

Hi naresh,

Is it the solution for all my three questions or still we have any solutions.

Thanks & Regards

Chandrakala S

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Naresh, how direct upload done in consolidation company?

Was this reply helpful? Yes No