Apply Multiple Entries to Each Other in AL

-

Introduction

While trying to implement a functionality of automatically applying any open invoices for a Customer with the open Payments for the said customer; I observed that there was no quick and easy method to post the application directly.

This can be very useful in environments where Payment Entries are created via Integrations without specifying the invoice it needs to be applied to.

I read around online but couldn’t find any blogs with the latest method of doing so in Business Central.

As such, I spent a good portion of my day debugging the process of applying entries, from start to end as written by Microsoft and to save your time I’m going to jot down my findings here.

Pre-requisites

  • Business Central OnPrem/Cloud

Configuration



Here as an example I’m using a processing report to iterate over all the open Payments in the system and the indented dataitem will iterate over all the open Invoices of the same Customer.

The method of iteration and validations may vary however the general logic will remain the same.



This is what happens in the background when we click the “Apply Entries” action on a Customer Ledger Entry (I’m using Payment entry in this instance) in the background. 

Payments."Applying Entry" := true; 
Payments."Applies-to ID" := UserId; 
Payments."Amount to Apply" := Payments."Remaining Amount"; 
Codeunit.Run(Codeunit::"Cust. Entry-Edit", Payments); 
Commit();

Here, after this we set the selected Customer Ledger Entry on the Apply Customer Entries Worksheet and display all the open entries which can be applied against it.



This is what happens, when we select an entry and click on the “Set Applies-To-ID” action.

CU_CustSetApplyID.SetApplId(Invoices, Payments, UserId); 
Commit();

It calls the SetApplId procedure of the Cust. Entry-SetAppl.ID" Codeunit [ID - 101], which mainly updates the following fields, in the Applying Entry:“Applies to ID”
“Amount to Apply”



Then, after we click on the “Post Application” action, standard Business Central allows us to change some parameters regarding the posting by using the “Post Application” page.

PostApplication.SetParameters(ApplyUnapplyParameters); 
if ACTION::OK = PostApplication.RunModal() then begin  PostApplication.GetParameters(NewApplyUnapplyParameters); 
if NewApplyUnapplyParameters."Posting Date" < ApplicationDate then 
Error(ApplicationDateErr, Rec.FieldCaption("Posting Date"), Rec.TableCaption()); 
end 
else 
Error(ApplicationProcessCanceledErr);



Since, we are going this programatically, we’ll set the values we need directly.

ApplicationDate := CustEntryApplyPostedEntries.GetApplicationDate(Invoices); Rec_ApplyUnapplyParameters.CopyFromCustLedgEntry(Invoices); Rec_ApplyUnapplyParameters."Posting Date" := ApplicationDate; Rec_GLSetup.GetRecordOnce(); if Rec_GLSetup."Journal Templ. Name Mandatory" then begin Rec_GLSetup.TestField("Apply Jnl. Template Name"); Rec_GLSetup.TestField("Apply Jnl. Batch Name"); Rec_ApplyUnapplyParameters."Journal Template Name" := Rec_GLSetup."Apply Jnl. Template Name"; Rec_ApplyUnapplyParameters."Journal Batch Name" := Rec_GLSetup."Apply Jnl. Batch Name"; end; CustEntryApplyPostedEntries.Apply(Invoices, Rec_ApplyUnapplyParameters);



You can find the entire source code here.

Conclusion

Thus we saw how we can write our custom code to apply customer ledger entries against each other.

I hope this helps save your time!

Happy Coding!

Comments

Post a Comment

Popular posts from this blog

Using Notifications in Business Central via AL

-
Image
Introduction Notifications in Business Central are alerts that appears in the Notification bar based on User actions. Notifications stack up from top to bottom, lasting until the user dismisses them, including those from sub-pages.  Validation errors are prioritized and shown before other notifications. We can use this to alert the user regarding something without taking all the user's notification towards it, in the way messages or errors do. They also have the option to allow Users to make a corrective action by embedding the action button directly into the notification. Let's see how it works. Source Code Pre-requisites Business Central OnPrem/Cloud. References Notification - Business Central Docs Configuration Here, for an example, I've created one simple page which takes two inputs. 1. The message that is to be shown in the notification. 2. The message to be shown after the User clicks on the action embedded in the notification.     And I have two actions which I'l...
Read more

Actionable Error Messages in Business Central

-
Image
Introduction Error handling is an important concept in every technical field.  It helps programs deal with unexpected problems and mistakes smoothly.  It makes sure software works reliably and doesn't crash unexpectedly.  Error handling also helps developers find and fix issues quickly, making the software better for users. Plus, it gives users clear messages when something goes wrong, making their experience smoother. It shows that the team has considered the scenario and has measures in place for it indicating a well designed solution. Microsoft has an amazing document which lists the things to keep in mind for writing resilient code. In Business Central, we have try functions to handle errors and error function to show those errors to the Users.  In this blog, we'll learn how we can enhance the error messages so that the Users can resolve the errors themselves or at the very least we can point them towards where the error is. Pre-requisites Business Central OnPrem...
Read more

Configure Gmail SMTP service in Business Central without "Allow Less Secure" setting

-
Image
 Introduction Business Central has great email features like sending email, editing it with Rich Text, adding attachments, etc, but to send emails, you'll need to connect it with services like Outlook or Gmail. There is no outlook side configuration that is to be done if you are using Microsoft Outlook however if you are using Google's Gmail then there's a litte change that has happened on the configuration end. Starting May, 2022, Google has removed the "Allow Less Secure Apps" settings from the Google Accounts, which was essential is using Gmail to send emails from Business Central. However, to replace that we have "App Passwords" which we can use instead. Also, just something to keep in mind, Google is going to remove this from the "Google Workspace" accounts as well by Sept, 2024 so it would be wise for you to migrate your configurations to use app passwords. Reference 1.  How to Setup Email in Business Central 2.  Google Support - Less sec...
Read more