Getting JE validation warning "account structure management ........"

(0) Share

Report

Posted on by Mav

Hi Experts,

I am trying to create JE line items for company B & C in journal created in company A.

My x++ code creates the line item with the required dimensions/account combination, however when i validate the journal i get below warning message.

What is weird is that when i select the problematic line item & merely re-enter the same values for account combinations for which it was throwing the warning, the warning goes away .

Also when i change my code to create the same JE line items but in company A instead of B & C i get no validation warnings.

Apparently i may to have to se crosscompany , but unable to figure out how to use cross company in my code as i am just inserting the values directly into ledgerjournaltrans without using select/while select.

and also not sure if that would fix this issue because i can see JE line items created with expected account combination in expected companies ,i.e company B & company C.

Please suggest a solution so that i am able to create JE line items in company B & C for journal created in company A with no validation warnings.

Thanks

Mav

I have the same question (0)

All responses (20)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Mav,

Could you please share the code you are using to create the entries?

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

Like (0)

Report

Hi Mav,

Are the accounts that you want to post included in the account structure 'Management'?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mav on at

Like (0)

Report
Thanks for replying

@Gunjan

public createJE(_CreateJEDC,_voucher,_CreateJETmp) { ledgerJournalTrans.LedgerDimension = this.getLedgerDimension(dim1,dim2,dim3); ledgerJournalTrans.TransDate = _CreateJEDC.TransactionDate(); ledgerJournalName = LedgerJournalName::find(_ledgerJournalTable.JournalName); ledgerJournalTrans.Voucher = _voucher; ledgerJournalTrans.JournalNum = ledgerJournalId; ledgerJournalTrans.LineNum = LedgerJournalTrans::lastLineNum(ledgerJournalId) 1; ledgerJournalTrans.CurrencyCode = _CreateJEDC.TransactionCurrencyCode(); ledgerJournalTrans.Txt = _CreateJETmp.desc; ledgerJournalTrans.Company = _CreateJETmp.LegalEntityDimVal; ledgerJournalTrans.BankDepositVoucher = NoYes::No; ledgerJournalTrans.ReverseEntry = NoYes::No; ttsbegin; ledgerJournalTrans.insert() ttscommit; }

@lDr Ludwig

Yes, the configuration states that it should show all accounts with value greater than 000000

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Mav.

Please share the code for the method - "getLedgerDimension" as well.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report
Sure, here is the code.

public RecId getLedgerDimension(Mainaccount _mainaccount, str dim1,dim2,dim3) { DimensionServiceProvider DimensionServiceProvider = new DimensionServiceProvider(); LedgerAccountContract LedgerAccountContract = new LedgerAccountContract(); DimensionAttributeValueContract ValueContract; List ListValueContract = new List(Types::Class); dimensionAttributeValueCombination dimensionAttributeValueCombination; DimensionStorage dimStorage; if (dim1) { ValueContract = new DimensionAttributeValueContract(); ValueContract.parmName('dim1') ; ValueContract.parmValue(dim1); ListValueContract.addEnd(ValueContract); } if (dim2) { ValueContract = new DimensionAttributeValueContract(); ValueContract.parmName('dim2') ; ValueContract.parmValue(dim2); ListValueContract.addEnd(ValueContract); } if (dim3) { ValueContract = new DimensionAttributeValueContract(); ValueContract.parmName('dim3') ; ValueContract.parmValue(dim3); ListValueContract.addEnd(ValueContract); } LedgerAccountContract.parmMainAccount(_MainAccount); LedgerAccountContract.parmValues(ListValueContract); dimStorage = DimensionServiceProvider::buildDimensionStorageForLedgerAccount(LedgerAccountContract); dimensionAttributeValueCombination = DimensionAttributeValueCombination::find(dimStorage.save()); return dimensionAttributeValueCombination.RecId; }

Thanks

Mav

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Mav,

Are you using the changeCompany keyword while creating the journals? Something like this -

public createJE(_CreateJEDC,_voucher,_CreateJETmp) { changeCompany (_CreateJETmp.LegalEntityDimVal) { ledgerJournalTrans.LedgerDimension = this.getLedgerDimension(dim1,dim2,dim3); ledgerJournalTrans.TransDate = _CreateJEDC.TransactionDate(); ledgerJournalName = LedgerJournalName::find(_ledgerJournalTable.JournalName); ledgerJournalTrans.Voucher = _voucher; ledgerJournalTrans.JournalNum = ledgerJournalId; ledgerJournalTrans.LineNum = LedgerJournalTrans::lastLineNum(ledgerJournalId) 1; ledgerJournalTrans.CurrencyCode = _CreateJEDC.TransactionCurrencyCode(); ledgerJournalTrans.Txt = _CreateJETmp.desc; ledgerJournalTrans.Company = _CreateJETmp.LegalEntityDimVal; ledgerJournalTrans.BankDepositVoucher = NoYes::No; ledgerJournalTrans.ReverseEntry = NoYes::No; ttsbegin; ledgerJournalTrans.insert() ttscommit; } }

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

I tried change company code & still getting that validation warning

It is really weird that when you re enter the same account combination & re validate the validation warning goes away.

Or warning goes away when you change your code for creating JE line item to below code

ledgertranscompany = _CreateJEDC.DataAreaId(); (Which provides values of company as company A in which the journal is created)

from this code

changeCompany(_CreateJETmp.LegalEntityDimVal)

ledgertranscompany = _CreateJETmp.LegalEntityDimVal; (Which provides values of company as company B or company C).

Please suggest a fix so that i am able to create JE line items for ledgertranscompany = company B or company C.

Thanks

Mav

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Mav,

Did you use the changeCompany keyword for creating the journal header as well? What I mean is something like this -

changeCompany(_company) { createLedgerJounalTable(); createLedgerJournalTrans(); }

A quick test could be to try creating the journal when logged into company B to check if the lines get created properly (for company B) and can be posted without errors.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

Hi Gunjan

I cannot use changeCompany while creating header because the journal has to be in company A with line items having ledgerjournaltrans.company as company B or company C.

However for testing i did created a journal JB in company B & in line item provided the account combination for which i was getting warning when using in company A & got no validation warning when using same account combination for journal JB.

Thanks

Mav

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Mav,

Could you please try something?

Instead of assigning values a buffer of LedgerJournalTrans, could you please try using AxLedgerJournalTrans class?

AxLedgerJournalTrans journalTrans; journalTrans = new AxLedgerJournalTrans(); journalTrans.parmJournalNum(ledgerJournalTable.JournalNum); journalTrans.parmTransDate(_CreateJEDC.TransactionDate()); journalTrans.parmCurrencyCode("USD"); journalTrans.parmAmountCurDebit(200); journalTrans.parmCompany(_CreateJETmp.LegalEntityDimVal); journalTrans.parmAccountType(LedgerJournalACType::Ledger); journalTrans.parmLedgerDimension(this.getLedgerDimension(dim1,dim2,dim3); // Fill in the remaining fields here. journalTrans.save();

Was this reply helpful? Yes No