Small and medium business | Business Central, N...

Apply to Oldest

(1) Share

Report

Posted on by Casper

Hi everyone,

We are new to business central, been using it for a few months now. A key point in the various sets of books we manage is that our particular clients use Journal entries and NOT invoicing. Each client is batched a monthly levy run and that is that.

All customers are set to Apply to Oldest, but this seems to be hit and miss. If it misses it affects the aging and in turn any automated processes that sends out payment reminders etc.

The problem we are experiencing is the Balance Due issue when we try to grab the Aging via power automate.

In the example below, you will notice that Entry number 158112 has been applied, instead of the entry before it 157136. This causes the Aging to show that a small amount is outstanding i.e 30days+.

Our payment terms have been set to calculate the Due date as CD (I believe that that would bake the due date the same as the posting date)

We also have an external automated bank reconciliation process that is centralized since we have 70 companies that work exactly the same. (The normal thinking of doing things in 1 company does not apply here, since they need to be replicated over many more companies)

I need to figure out how to fix the /Apply to/ so that it does not skip over older posting dates. Or I need to find a way to grab the Balance at the end of each period (not Balance Due, since the Balance Due relies on the Open items to be applied correctly). With each period I mean that I want to obtain and use the Running balance on the last day of each period (for 6 periods [months]) with an API or power automate to use externally on a regular basis.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Casper 10 on at

Like (0)

Report

Apply to Oldest

Hi Jun, thank you for the response. If you say cut of date field, do you mean due date?

Due to the nature of our business, we only make journal entries, not invoicing (long story). As such any credits must simply be applied to oldest. Manual application is a slower process when it comes to our bank reconciliations (we have a custom-built recon process)

@Kaspars, I checked, On Hold is blank.

I think something worth mentioning is that often billing ahead, so on say 20 February 2024 we would make the charges with posting and due date 1 March 2024. The statements are then sent to the clients, and they often make payment before 1 March 2024, see example below. (again here are payments made but the March items are not applied)
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

Apply to Oldest

if you used apply to the oldest, you need to keep the cut off date field open so BC pulls in all due invoices. If you put in a cut off date, there will be older invoices prior to the cut off date ignored by BC. actually, I believe manually apply is a better option since user has more control on what to apply.

hope it helps.
Jun Wang
KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

Apply to Oldest

Check if the Column "On Hold" is empty for this entry 157136 (maybe someone accidentally added a symbol there, and if it is not empty, it is skipped in payments/applications.