Excel formula @I_EOL_CUT_BAL_PDE_CLOSE not showing balance from Exact Online

Questions
,
1

I am creating a workbook using balance sheet accounts for the first time. I’m using this formula:

=@I_EOL_CUT_BAL_PDE_CLOSE(,“RUF AJWS”,2026,1,3,“0427”)

but there is no balance.

Here is the General Ledger report in Exact for this GL/cost unit combination, showing all transactions, where there is a balance:

image
image1882×810 45.1 KB

Can anyone advise on this?

2

The definition of this Excel formula is:

Function I_EOL_CUT_BAL_PDE_CLOSE
( Optional divisionCode As String = ""
, Optional costUnitCode As String = ""
, Optional reportingYear As Integer = 0
, Optional reportingPeriodFrom As Integer = 0
, Optional reportingPeriodTo As Integer = 0
, Optional glAccountCode As String = ""
, Optional glAccountType As String = ""
, Optional balanceType As String = ""
, Optional afterEntry As Boolean = True
, Optional executionHint As String = ""
)

The function call I_EOL_CUT_BAL_PDE_CLOSE(,“RUF AJWS”,2026,1,3,“0427”) leads to the following mapping:

  • divisionCode = “”
  • costUnitCode = “RUF AJWS”
  • reportingYear = 2026
  • reportingPeriodFrom = 1
  • reportingPeriodTo = 3
  • glAccountCode = “0427”
  • glAccountType = “”
  • balanceType = “”
  • afterEntry = True
  • executionHint = “”

Based upon the screenshot, it can not be concluded that there is a closing balance at the end of period 3 in 2026. The value should be: opening balance of the cost unit, plus cumulative volume from periods 1 through 3.

It is recommended to test using the period 2025-12.

3

Thank you for this information. When I use the period 2025-12 I get the opening balance. But does this mean in 2027 I will need to use both the period 2025-12 AND the period 2026-12 and add them together, or will 2026-12 include the total correct opening balance?

4

The opening balance is always cumulative going back to the start of the company.

5

How do I therefore make sure I always get a closing balance for a balance sheet account as of the period I specify?

6

It is hard to understand the question. The balance from a formula is always at end of specified period. Is it possible to give an example?

7

Yes, the original example that I have was to show the balance at the end of 2026, period 3, but it wasn’t showing the balance - only if I selected 2025 period 12, but the balance should therefore be the same at the end of 2026 period 3.

8

It is not possible to validate this statement based upon the data available.

Is it possible to provide a specific example with the full sample numbers?

9

Hello, please see below.

Here are all the transactions for GL account 0427, cost unit RUF AJWS.

image.png1902×777 44.7 KB

Here is the result in Excel using period 12, 2025

image.png1020×409 14.9 KB

Here is the result using the same formula to period 3, 2026. I would expect this to be the same as the result above.

image.png1015×421 15.2 KB

10

Hello, I didn’t get a reply on this yet, can you help?

11

Due to a large incident, questions which are no assumed to be a bug, are currently not being handled. The topic will be picked up later.