Consolidation Company and Beginning Balances for BS Accounts
KELLI
Member Posts: 21
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.
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.
0
Comments
-
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 help0 -
The client is using v4.0. / Same currency / business units witin the same database
The message above is the message we are getting.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 250 Dynamics CRM
- 102 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions