Business Central - Bank Deposit Error - Fixed with AL Code
With the most recent Microsoft Update, our customers noticed a Bank Deposit error with Lump Sum Deposits. They couldn’t Post Bank Deposits because of this error. We showed them how to manually do a workaround for the error, however, they weren’t happy with a manual workaround, because they were getting that error in all 14 of their Business Central companies. Then we permanently fixed the Microsoft error using Application Language (AL).
Business Central - Bank Deposit Error
The Bank Deposit No. automatically fills the wrong column on the Subform
Business Central - Bank Deposit Error
Normally, the user enters the customer payment reference number in the “Document No.” column.
Business Central - Bank Deposit Error
An error occurs when trying to Post the Bank Deposit. “All lines on the Subform must have the same “Document No.”
Business Central - Bank Deposit Error
The error can be manually corrected by swapping the entries in the “Document No. Column with those in the “External Document No.” column.
Business Central - Bank Deposit Error
Here we go – ready to Post the Bank Deposit.
Business Central - Bank Deposit Error
Because we swapped the “Document No.” entries with the “External Document No.” entries, we were able to workaround the system error.
Business Central - Bank Deposit Error
The users could continue to manually correct the error – except there are 5 users, 14 companies and 25 bank accounts. By writing Application Language Code (AL) we saved users a lot of confusion and time.
Business Central - Bank Deposit Error – NOW FIXED with AL
Now, after our code fix, let’s see how simple the Lump Sum Deposit is.
Business Central - Bank Deposit Error – NOW FIXED with AL
After installing our AL Code extension, the Bank Deposit No. gets written to the “Document No.” column not the “External Document No.” column.
Business Central - Bank Deposit Error – NOW FIXED with AL
After the code fix, the system writes to the “Document No.” column, leaving the “External Document No.” free for entry of the customer’s detail reference.
Business Central - Bank Deposit Error – NOW FIXED with AL
We are ready to Post the Bank Deposit…
Business Central - Bank Deposit Error – NOW FIXED with AL
The Bank Deposit Posts now without an error. There was no need for the manual workaround of transposing the Document No. with the External Document No.
Business Central - Bank Deposit Error – NOW FIXED with AL
The users could have continued to manually correct the errors – except there are 5 users, 14 companies and 25 bank accounts. By writing Application Language Code (AL) we saved users a lot of confusion and time.
Business Central - Bank Deposit Error – NOW FIXED with AL
Here’s the code page for the Bank Deposit Subform ListPart (Sorry; it is not trivial.)
Business Central - Bank Deposit Error – NOW FIXED with AL
Heres the codeunit to Subscribe to the “Bank Deposit Subform”
Business Central - Bank Deposit Error – NOW FIXED with AL
Application Language (AL) is the programming language behind Business Central. Developers transform BC with AL: Custom Reports; custom tables, custom codeunits; custom fields; system jobs; integrations with external systems; and entire applications can be built within Business Central using AL.
Comments