Creating a ledgerJournalTrans record in an existing LedgerJournalTable (2012 R3 CU8) with a valid ledgerDimension

(0) Share

Report

Posted on by Community Member

I'm trying to import some data from an external database into a general journal. I've got it working in general minus the fact that my ledgerDimension values are not coming up correctly.

These are line items that will contain a date, an account type of ledger, and either a debit or credit. So they are all main accounts. To get the ledger dimension I simply call this for example:

ledgerTrans.parmLedgerDimension(DimensionStorage::getDefaultAccountForMainAccountNum('1234567'));

where 1234567 is the main account. When I launch the general journal form I am getting stack trace errors now because it's reaching back to a dimensionAttributeValueCombination that no longer exists.

How can I get this to construct the proper ledgerDimension recid on insert.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Brandon Wiese 17,790 on at

Like (2)

Report
Copy link

Link copied!

You cannot use a Default account in a ledger journal.

Take the value that you get back from DimensionStorage::getDefaultAccountForMainAccountNum() and pass it through DimensionDefaultingService::serverCreateLedgerDimensions() to arrive at a DAVC record ID that you can put on LedgerJournalTrans.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,126 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Brandon is correct.

I was just looking for the exact name of the same method. Then I noticed Brandon already answered.

Was this reply helpful? Yes No
Brandon Wiese 17,790 on at

Like (0)

Report
Copy link

Link copied!

I believe starting in R3 CU9 or CU10 you can pass a default dimension through one of the merge methods on the same class and it will translate implicitly also. So, there are many ways to accomplish that specific task.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

That worked perfectly. Thank you so much

Was this reply helpful? Yes No