Problem in number sequence of payment journal

(0) Share

Report

Posted on by Saadi

I have a problem in payment journal. it was working fine with 8 digits number, today I increase number sequence from 8 to 10 digits. when we create new journal, it give us new journal number like 1000115599 but when I click on lines of same journal, system truncate last 2 digits like 10001155 and open the existing journal of 10001155 number.

All responses (13)

Answers (2)

Suggested answer

Khurshid Wali 928 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

I agree with Gunjan,

you are missing the possibility of different classes which can responsible for transferring your value on that way from the source table to destination.

Here is Visual Help

you are expecting that value is transfer directly from source table to destination table as the black arrow.

but in reality, It goes through the green arrow. in between, it gets passed from EDT to EDT before landing to the Final Table.

First Try to do full DB Sync so that it AX will update all LedgerJournalId Reference in all the table.

if dB sync does not resolve this issue. then you have to find this Some EDT 10 container through debugging and update it as well.
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

The EDT LedgerJournalId is used in LedgerJournalEngine class as well which is used in the journal lines form(s). It might be getting truncated there.

Please make sure you have done a DB synchronization as well after changing the field size.
Saadi 5 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

You can see same changes has done in ledger journal trans.
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

This makes sense. Since you increased the field size in the table, it did not increase it across the application. You can try increasing the size of the EDT "LedgerJournalId" to 12 instead. That should increase the size in the the LedgerJournalTrans table as well.

You should do a full round of testing in Dev/Test system after increasing the string size. Since this EDT is used in a lot of places, you have to make sure no process is broken by this change.
Saadi 5 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

Well I already increased my string size to 12, but still save same issue.
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

Hi Saadi,

The maximum length of the Journal number EDT is set at 10 chararcters. The new number sequence setup by you is 12 characters which is why the number is getting truncated. It is, however, surprising that the journal header is displaying 12 characters (instead of 10), which might be because of some customizations. Please check the field JournalNum in LedgerJournalTable and find out if there are any modifications done there.
Saadi 5 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

Yes
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

Did you try with a different type of journal as well?
Saadi 5 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

Yes same behavior in test environment.
Suggested answer

Khurshid Wali 928 on at

Like (0)

Report

RE: Problem in number sequence of payment journal

Hi Saadi,

Kindly Check the EDTs behind both the fields. if we put 10 character length EDT to 8 character Length EDT. It will truncate the extra bits.