Skip to main content

Notifications

Announcements

No record found.

Recurring Journal Amount calculation based on Account schedules

tpupko Profile Picture tpupko 2,048

Hi everyone!

Today I want to describe very nice functionality for Recurring General Journals in Business Central. 

Can you imagine that you can calculate the amount for journal line line based  Account Schedule figures for current month or day. 

You can set up amounts calculation based on Business Central data using Account Schedules not in Excel and system will put amount to lines automatically!

How it works:

0842.pastedimage1646862670419v4.png

For Recurring General Journal line I have fields:

- Acc.Schedule Name
- Acc. Schedule Description
- Column Layout Name
- Column Header

That means I can add how to calculate line amount.

0830.pastedimage1646862924571v5.png

Than I can use the function Calculate Recurring Journal Amounts. System gives me Report options  with dates based on my Posting date.

5367.pastedimage1646863017346v6.png

And...magic! I have my amount calculated in the journal line!

3833.pastedimage1646863145768v7.png

There is one sadness here, this functionally is available only for Russian localization.

If you like it as I do, please vote for this functionality in the Worldwide Business Central version.

Microsoft Idea (dynamics.com)

Thank you!

Comments

*This post is locked for comments