Microsoft Dynamics AX (Archived)

How to import Ledger Closing trans

(0) Share

Report

Posted on by Modiseh

Hi guys

I want to import data in the LedgerClosingTrans table.

Have you already experienced it ?

Path of form : Gl\periodic\Fiscal year close\Closing Period adjustment\Bottom:Transfer

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Martin Dráb 237,978 Most Valuable Professional on at

Like (1)

Report

Hi Rahele, please separate individual tags with comma, words with spaces and don't prefix tags with comma. You attached a single tag #Import_By_DIXF #Import_By_Excel #Import_Data #Year_End_Close #Finance_Closing instead of five tags Import By DIXF, Import By Excel, Import Data, Year End Close and Finance Closing.

Was this reply helpful? Yes No
Modiseh 85 on at

Like (0)

Report

OK. :)

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Rahele Kakavand,

What do you want to achieve through this upload?

Is it that you want to post some transactions in closing periods or do you simply want to post some year end adjustment transactions?

Best regards,

Ludwig

Was this reply helpful? Yes No
Modiseh 85 on at

Like (0)

Report

Hi Ludwig Reinhard

Actually, I want to close any cost account with its dimension.

There are many dimensions for each profit/cost accounts , then I can't enter it manually.

Br

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Rahele Kakavand,

Do you necessarily need the closing sheet for that or can't you do this upload via an ordinary GL journal?

The difference is that a GL journal does not allow you posting in a closing period. Do you have to make those postings in a closing period?

Best regards,

Ludwig

Was this reply helpful? Yes No
Modiseh 85 on at

Like (0)

Report

As far as I understood, It is impossible ?

And I have to search for another solution .

Was this reply helpful? Yes No
SebastienVerspeelt on at

Like (0)

Report

I would follow the advice of Ludwig.

It of course depends what the real needs are about the aspect of "close a cost account". But if it is just to offset the account with all the specific dimensions in the transactions, I would also use the upload through GL journal.

If you want to keep track of this, which ledger transactions are related to this "closing", you can make a new journal name with a dedicated number sequence which has a prefix that indicates this "closing".

Regards,

Sébastien.

Was this reply helpful? Yes No