17

Current deferral functionality allocates amounts based on accounting periods rather than the actual number of days within the deferral period. This may result in inaccurate allocation amounts when periods contain different numbers of days (e.g., February vs. March) and does not meet legal or accounting requirements in some countries.

Adding support for day-based calculations would provide more accurate revenue and expense recognition and reduce the need for manual adjustments.

 

   Current Behavior

 

Deferral schedules are calculated based on periods defined in the Deferral Template.

Allocation amounts are distributed by period regardless of the actual number of days in each period.

Users can define the start date, but there is no dedicated end date that determines the validity period of the deferral.

 

   Requested Enhancement

 

Introduce an option in Deferral Templates to calculate deferrals based on the actual number of days within the deferral period.

Additionally, add an End Date field to the Deferral Header to explicitly define the validity period of the deferral.

 

   Functional Requirements

 

  1. Day-based deferral calculation

Add a new calculation method in Deferral Template (Table 1700):

 

By Actual Days (new behavior)

 

When "By Actual Days" is selected:

The total amount is distributed proportionally according to the number of days in each accounting period.

The system should automatically account for varying month lengths and leap years.

 

 

  1. End Date field

Add a new field to Deferral Header (Table 1701):

 

End Date

 

Defines the end of the deferral validity period.

Used together with Start Date to determine the total number of days for allocation.

Provides transparency and simplifies user maintenance of deferral schedules.

 

3. Source Documents

The enhancement should be available when creating deferrals from:

 

Sales Line (Table 37)

Purchase Line (Table 39)

 

Example

Invoice Amount: 1,200 EUR

Start Date: 2026-01-15

End Date: 2026-04-14

Calculation Method: By Actual Days

Expected result:

 

1200/ 90 = 13.33 (daily amount)

 

 

2026 01 31  (17 days) 226,67

2026 02 28  (28 days) 373,33

2026 03 31  (31 days)  413,33

2026 04 14  (14 days)  186,67

 

Deferral entries are created proportionally according to the actual number of days falling within each accounting period, rather than splitting the amount equally by month.

 

Expected Benefits

 

More accurate revenue and expense recognition.

Compliance with local accounting practices that require day-based accrual calculations.

Reduced manual adjustments.

Improved transparency through explicit Start Date and End Date management.

STATUS DETAILS
New

Comments

A

For Lithuania, this enhancement is particularly important due to local accounting and legal requirements. This functionality would be highly beneficial for many Business Central customers in Lithuania.

Category: Financial Management