Microsoft Dynamics AX (Archived)

Which table should i migrate to if i need to migrate to the Accounting Currency and the Reporting Currency Amount Field?

(0) Share

Report

Posted on by Abdo Khoury

14,855

Dear

we need to migrate a journal entry to offset difference of exchange(DOE) amounts

my DOE amount have 0 in transaction amount (LedgerJournalTrans.AmountCur) but does have decimals in the Accounting Currency and Reporting Currency Field amount;

is which table should i migrate to in order to migrate the Accounting and Reporting currency ?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you post a transaction record gets created in tables LedgerTrans and GeneralJournalAccountEntry and data can be retrieved through following fields:

LedgerTrans.AmountMST == GeneralJournalAccountEntry.AccountingCurrencyAmount

and

LedgerTrans.AmountMSTSecond == GeneralJournalAccountEntry.ReportingCurrencyAmount

and

LedgerTrans.AmountCur == GeneralJournalAccountEntry.TransactionCurrencyAmount.

Please check below link to understand the relationship between these two tables:

download.microsoft.com/.../Mapping_the_LedgerTrans_table_to_General_Journal_tables_AX2012.pdf

Was this reply helpful? Yes No
Suggested answer

Galyna Fedorova 3,566 on at

Like (0)

Report
Copy link

Link copied!

Why do not you want to migrate a journal entry in the accounting currency and populate LedgerJournalTrans.AmountCur with decimals?

Was this reply helpful? Yes No
Abdo Khoury 14,855 on at

Like (0)

Report
Copy link

Link copied!

the system generated difference of exchange transactions to the wrong account and we want to reverse them

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

Those fields are stored in GeneralJournalAccountEntry after posting.

Was this reply helpful? Yes No
MyDynamicsNAV 77 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Please help!

what I'm doing wrong here, generalJournalEntryTmp.CreditAmount, generalJournalEntryTmp.DebitAmount are not displayed on the report

ttsbegin;

while(queryRun.next())

{

generalJournalEntry = queryRun.get(tableNum(GeneralJournalEntry)) as GeneralJournalEntry;

generalJournalAccountEntry = queryRun.get(tableNum(GeneralJournalAccountEntry)) as GeneralJournalAccountEntry;

Amount creditAmount;

Amount debitAmount;

Amount amount;

//generalJurnalAccountEntry_W = queryRun.get(tableNum(GeneralJournalAccountEntry_W)) as GeneralJournalAccountEntry_W;

generalJournalEntryTmp.clear();

generalJournalEntryTmp.SubledgerVoucher = generalJournalEntry.SubledgerVoucher;

generalJournalEntryTmp.JournalNumber = generalJournalEntry.JournalNumber;

generalJournalEntryTmp.MainAccount = generalJournalAccountEntry.MainAccount;

generalJournalEntryTmp.MainAccountName = MainAccount::findByLedgerDimension(generalJournalAccountEntry.LedgerDimension).localizedName();

generalJournalEntryTmp.AccountingDate = generalJournalEntry.AccountingDate;

//generalJournalEntryTmp.AccountingCurrencyAmount = generalJournalAccountEntry.AccountingCurrencyAmount;

amount = generalJournalAccountEntry.TransactionCurrencyAmount;

if(amount < 0)

{

generalJournalEntryTmp.CreditAmount = amount;

}

else if(amount > 0)

{

generalJournalEntryTmp.DebitAmount = amount;

}

generalJournalEntryTmp.Text = generalJournalAccountEntry.Text;

generalJournalEntryTmp.AccountNum = generalJournalAccountEntry.LedgerAccount;

//LedgerDimensionFacade::getDisplayValueForLedgerDimension(generalJurnalAccountEntry_W.ledgerDimensionCorr_RU());

generalJournalEntryTmp.insert();

}

ttscommit;

Was this reply helpful? Yes No