5
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 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.
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.
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.
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.
Did you try with a different type of journal as well?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (