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.

I have the same question (0)

All responses (13)

Answers (2)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Saadi,

Could you please provide screenshots for the trucated journal number in lines?

Was this reply helpful? Yes No
Saadi 5 on at

Like (0)

Report

Here you can see I have created new journal with T-PB01002738, if I clicked on lines of this journal, you can see 2nd screen shot there is different journal with T-PB010027 was opened, system truncate last 2 digits. and opened a already posted journal instead of lines of same journal.

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

Like (0)

Report

Hi Saadi,

If you have a Test system available, could you please try creating a journal in general journals and check if you see the same behavior?

Was this reply helpful? Yes No
Suggested answer

Khurshid Wali 928 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Saadi 5 on at

Like (0)

Report

Yes same behavior in test environment.

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Did you try with a different type of journal as well?

Was this reply helpful? Yes No
Saadi 5 on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Saadi 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No