Consolidation Company and Beginning Balances for BS Accounts

KELLI

My client is utilizing the consolidation company feature in Navision (v4.00). Unless I have missed something in set-up, when we execute from the Business Unit Functions / Import Database with a date range of the first day of their new fiscal year, we are not getting the desired results, the beginning balances for the BS accounts. The ultimate result being, if we add the financials up for all the business units they will match the consolidation financials (unless they make elimation entries).

The prior fiscal years are closed and entries have been made by Navision through the execution of Close Income Statement. Because the posting date is populated with a CMM/DD/YYYY, the consolidation import does not like the C infront of the date. A result is the process stops.

This request of help is time sensitive please.

jannestig

IF you look in partner source you will see several hotfixes for different versions of nav colsolidation as well as several other articles around consolidation.

We need more info to help IE what was the actual error message where it doesn't like the C date? WAS it
A G/L Entry with Posting Date on a closing date (C31.12.Year) was found while consolidating nonclosing entries (G/L Account No. Number).

What Version of nav are you using?, are you consolidationg within the same currency or are multiple currencies being used.

More info = more help

KELLI

The client is using v4.0. / Same currency / business units witin the same database

The message above is the message we are getting.