Importing Budgets into consolidation company
raphael_as
Member Posts: 8
Can anyone tell me if budgets are imported during consolidation? If so is there anything specific that needs to be done or should it just happen automatically.
I am consolidating 5/6 companies into a consolidated company - each company has different currencies and budgets are currently entered on the company level - it would be a bit of a pain to have to re-enter them all at the consolidation level (esp. ensuring that currency conversions were carried out correctly etc).
Any help appreciated. Thanks.
I am consolidating 5/6 companies into a consolidated company - each company has different currencies and budgets are currently entered on the company level - it would be a bit of a pain to have to re-enter them all at the consolidation level (esp. ensuring that currency conversions were carried out correctly etc).
Any help appreciated. Thanks.
What the hell makes someone think that an ABAP developer can magically program C/Side?
0
Comments
-
the consolidation export and import or read (depending if is from the same database or different) only the gl entry table so the solution is create a procedure that do the same for budget entry. the report is 91 so you could copy it changing tablem 17 with table G/L Budget Entry the problem is that all the budget name should be the same and when you import you should change entry no ( primary key of G/L Budget Entry) to avoid problem of two record with same entry no.0
-
The development required to add the facility to consolidate budget ledger entries, was it significant and has your solution been reliable?0
-
in such cases i export to excel, consolidate in excel, then import in the consolidated companyRomeo
MCT - Dynamics
ERP implementor/consultant0
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
- 322 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