Ledger journal validation error catch and store using X++

(0) Share

Report

Posted on by CU03061214-0

Hi experts,

I am working on ledger journal validation. I want to store validation error into one of the table.

I have wrote following code to catch validation error but unable to catch validation error and following

code showing the standard error message where as I want to catch and store validation error.

I am getting following validation error message but requirment to catch and store error

Code:

public class TestClass
{
public static void main(args _args)
{
LedgerJournalTable ledgerJournalTable;
LedgerJournalCheckPost ledgerJournalCheckPost;
SysInfoLogEnumerator infoLogEnum;
SysInfologMessageStruct infoMessageStruct;
str integrationMessage;

LedgerJournalTable = LedgerJournalTable::find('JB2551921');

try
{
ledgerJournalCheckPost = LedgerJournalCheckPost::newLedgerJournalTable(ledgerJournalTable, NoYes::no);
// ledgerJournalCheckPost.run();
LedgerJournalCheckPost::processOperation(ledgerJournalCheckPost);
}
catch(Exception::Error)

{
info('Catch');
infoLogEnum = SysInfoLogEnumerator::newData(infolog.infologData());

while(infoLogEnum.moveNext())

{

infoMessageStruct = SysInfologMessageStruct::construct(infoLogEnum.currentMessage());

integrationMessage = integrationMessage + infoMessageStruct.message() + '/';

info(strfmt('Error message of failure is %1',integrationMessage));

}
}
}

}

I have the same question (0)

All responses (6)

Answers (2)

Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Ledger journals already stores messages in a database: LedgerJournalTable.Log field. Can't you use that?

Was this reply helpful? Yes No
CU03061214-0 on at

Like (0)

Report
Copy link

Link copied!

Thanks export.

LedgerJournalTable.Log stores the validation error but this field doesn't store full validation error because this field length are 255 char.

Kindly advice the solution which can store full validation error message.

Many thanks in advance.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can create a log table with fields, Journalid, error message and error created date time (if required) and get the error into a list and pass the list to the log table.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

One option is extending LogText EFT and increasing the length. Another approach is adding custom logic in a extension of LedgerJournalCheckPost.updateTableInfoLog(). You can also take log entries collected in LedgerJournalCheckPostResults and save them to your table. Use ledgerJournalCheckPost.parmPostingResults() to get the results object.

Was this reply helpful? Yes No
Verified answer

Kevin Xia Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

As Martin said, there are many ways to achieve your goals, depending on your needs or business scenario. If you just need to store the complete error message, you can increase the length of the field so that it can accommodate the complete error message. If there are more complex requirements or business scenarios, you can consider creating a new table to store error information.

Best regards,

Kevin

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Has your problem been solved? If so, you can mark the thread as verified so that other users of the forum can view the post.

Best regards,

Kevin

Was this reply helpful? Yes No