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

Consolidation Error "The consolidation can include a maximum of 500 days"

(0) Share

Report

Posted on by Congruent Infotech

Hi All,

Below error occurred when we try to consolidate from 01-01-2018 to 30-09-2021,

The consolidation can include a maximum of 500 days.

Internal session id:
2692002d-3c8a-4389-9593-3a0c6799f44a

Application Insights session id:
21b3d92e-67c7-4e37-9e9e-e2eea1427fea

Client activity id:
302f293f-8a96-4b55-99e2-31b917be1403

Timestamp:
2021-11-16T16:52:03.9336254Z

AL call stack:
Consolidate(CodeUnit 432).ReportError line 10 - Base Application by Microsoft
Consolidate(CodeUnit 432).OnRun(Trigger) line 7 - Base Application by Microsoft
"Import Consolidation from DB"(Report 90)."DoTheConsolidation - OnAfterGetRecord"(Trigger) line 7 - Base Application by Microsoft

Help on this error will be highly appreciated.

Thanks!

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

Maybe you should try to consolidate smaller timespans at the time so you stay below the max.500 days limitation?

Was this reply helpful? Yes No
Congruent Infotech on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response. but we are curious that consolidation company only consolidates data for dates not exceeding 500 days. Does consolidation has days restrictions??

Was this reply helpful? Yes No
Suggested answer

Dirk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

From a book keeping perspective, why do you want to consolidate more than a fiscal year?

Was this reply helpful? Yes No
Suggested answer

Gulshan Shubham 2,210 on at

Like (0)

Report
Copy link

Link copied!

Yes, Consolidation has days restriction. I don't see it as a problem until you could explain the need for it for your scenario.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

From an Accounting and Consolidation process NEVER consolidate more than the Current Fiscal Year. Please go back and either consolidate the Current Month or Months or just the Current Fiscal Year. If this is for a previous year, that is fine too as long as you do 1 year at a time. Remember you consolidate and still need to Close the Accounting Period and Income Statement for the Consolidation company.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No