Making Business Central Receivables easier with AL code
Our Business Central client bills their customers on the unposted Sales Invoice #. This is because there is often a count discrepancy on the product shipped versus the product received.
Open Sales Invoices can be edited so the two parties can agree. Then our client posts the invoice, thus changing the number series to a PS-INVXXXXXX invoice.
The payment check will have the “S-INV…” numbers on the check stub as Applied.
This only becomes a problem when our client has to reconcile the account with their customer.
Making Business Central Receivables easier with AL Code
The customer is billed on the Sales Invoice not the Posted Sales Invoice.
Therefore, on the check or remittance only the Sales Invoices are listed.
That is not a problem when receiving a payment, because applying a posted sales invoice to a payment also shows the corresponding Pre-Assigned Invoice number.
Making Business Central Receivables easier with AL Code
When reconciling customer accounts, it is frequently necessary to verify which invoices were applied against any particular Payment.
The quickest place to do this is the “Unapply Customer Entries” List Page.
There you see the Posted Series Number in the Initial Document No column. The “Pre-Assigned Number” column is not available. That is the number which needs to be reconciled, because the end customer never receives a Posted Invoice. They pay from the S-INV series.
Making Business Central Receivables easier with AL Code
The Pre-Assigned Number field is not found on the Personalization Page so it cannot be added to the Unapply Customer Entries List Page, thereby cross-referencing the Posted Invoice Number with the original Sales Invoice number that the end customer refers to.
Making Business Central Receivables easier with AL Code
We can find the Pre-Assigned number matching the Posted Sales Invoice Number (PS-INV….) by searching Find Entries and drilling into the Customer Ledger Entry.
Making Business Central Receivables easier with AL Code
Searching one Applied Invoice at a time can lead us to the Pre-Assigned Invoice Numbers.
However, this is not efficient if the bookkeeper is faced with a high volume of payments daily – all with multiple sales invoices referenced.
Making Business Central Receivables easier with AL Code
So our task was to add the Pre-Assigned Number (original Sales Invoice number) as a column in the Customer Applied Invoices Page.
We accomplished this task of inserting the Pre-Assigned Number column into the Customer Applied Entries Page
It didn’t take long to solve this problem with AL Code.
Making Business Central Receivables easier with AL Code
AL (Application Language) for Business Central can help
We solved the problem quickly by writing a small AL Extension.
Customizability and Flexibility: AL programming within Microsoft Dynamics 365 Business Central enables tailored solutions to fit specific business workflows and processes.
Seamless Integration with Business Central: AL ensures custom extensions fully integrate with Business Central's core functionalities.
Cloud-Ready and Future-Proof: AL is designed for Cloud environments, aligning with Microsoft's future plans for Business Central.
Efficient Development and Deployment: AL allows for quick development, testing, and deployment with minimal disruption.
Strong Community and Support: AL benefits from robust community support and comprehensive Microsoft resources.
Making Business Central Receivables easier with AL Code
And here's the code...
