top of page

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


Recent Posts
1/2
Archive
Search By Tags
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
bottom of page