8,208
Like
Share
ReportScheduling Currency Adjustment Service in Business Central Using DateFormula
In Business Central, scheduling currency adjustment services is a common requirement for businesses dealing with multiple currencies. One such scenario is scheduling the currency adjustment to occur on the 1st of every month. This blog post will guide you on how to set this up using the DateFormula data type.
When a date calculation formula is stored in a DateFormula field, it is converted to a generic, non-language dependent format. When it is retrieved from a DateFormula field, it is converted to a valid date conversion string for the currently selected language.
DateFormula Syntax
The following table shows the syntax used to create date formulas:
Syntax Description
30D 30 days
2W 2 weeks
CM+10D Current month plus 10 days
CM+1M Current month plus one month
CQ+1M+20D Current quarter plus one month plus 20 days
CW+1W Current week plus one week
D15 On the 15th of each month
In Business Central, weeks begin on Monday and end on Sunday.
Example: Scheduling Currency Adjustment for the 1st of Each Month
A client wants to schedule currency adjustments for the 1st of every month. Here’s how to achieve this using DateFormula in Business Centra?
Based on the examples, user should put D1 as the recurring date formula.
Using DateFormula in Business Central to schedule currency adjustment services ensures timely and automated updates.
*This post is locked for comments