Consolidations and the world we live in...

Craig_Needham
Member Posts: 23
Greetings All,
Its me again. I would like a few opinions about the following situation. An organisation is the head of a franchise. They currently have +- 30 franchisees in the country. They want to use Navision to keep track of the individual franchise companies. Although its a lot of work, Consolidations between these companies will allow this information to be grouped into one central place for reporting.
The problem is the inter company Transactions. These transactions need to be offset against each other before consolidation is done. This will prevent us from owing money to ourselves.
It looks to me like these inter company transactions need to journalised before consolidations are run. Is there a field on the FGeneral Ledger Entries that Identifies a record as inter company? Or is there some other way this distinction can be made?
Is there a quick way to generate these Journal Lines?
Are we going about this the completly wrong way?
Thank you for listening.
regards
Craig needham
Its me again. I would like a few opinions about the following situation. An organisation is the head of a franchise. They currently have +- 30 franchisees in the country. They want to use Navision to keep track of the individual franchise companies. Although its a lot of work, Consolidations between these companies will allow this information to be grouped into one central place for reporting.
The problem is the inter company Transactions. These transactions need to be offset against each other before consolidation is done. This will prevent us from owing money to ourselves.
It looks to me like these inter company transactions need to journalised before consolidations are run. Is there a field on the FGeneral Ledger Entries that Identifies a record as inter company? Or is there some other way this distinction can be made?
Is there a quick way to generate these Journal Lines?
Are we going about this the completly wrong way?
Thank you for listening.
regards
Craig needham
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions