Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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