Dynamics Community Forum Thread Details

GL Budget Control for Journals and Sales Invoices – Prevent Exceeding Monthly Limits

Hi,
Once a budget is created for a particular month, for example, January 2025 with a budget of 5000, this amount can be used for

General Journal, Purchase Journal, Sales Journal, Payment Journal, Item Journal, Fixed asset G/L Journal and sales invocie .
1. In one journal, the first line uses 1000 and the second line uses 1000.
2. In the next batch, the first line uses 1000 after this has been posted

The remaining amount for that particular GL account is 2000, The already posted amount of 1000 is also considered against the budget, which can be used for other journals.
If someone tries to use 3000, the system should show an error indicating that the amount exceeds the budget.
For any journal or sales invoice, only the remaining budget (e.g., 2000 in this example) should be allowed.

I have used the code below for all journals, and it works, except for sales invoices.

Here is the file name for the working code. : NEWFINALWORKCODEAlljournals.al

I have tried to add sales invoices to the above code, but it is not working. The code below works for sales invoices separately
Here is the file name for the working code.: salesinv.al

I have already tried the code that was shared. I need help on how to merge it so that the budget check works for all journals and sales invoices.

Thank you ,

Categories:

Dynamics 365 Business Central

Quick Links