Importing customer ledger balances from sage
kamranshehzad
Member Posts: 165
Hi I want to import customer /vendor ledger entries from sage.
I have got the data out of sage.
Do I need to Import them data into Cust. Ledger Entry table (21) & vendor ledger entries table using data migration and then post them?
Please advice.
Kind reagrds,
I have got the data out of sage.
Do I need to Import them data into Cust. Ledger Entry table (21) & vendor ledger entries table using data migration and then post them?
Please advice.
Kind reagrds,
KS
0
Answers
-
You import them to the General Journal Line table then post them.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
you never import directly into ledgers, you always import into journals and let NAV post0
-
By pushing them into an os pen journal you have to post the journal to get the transactions into the ledgers - this ensures all of the postings are correct and fields validated correctly, so you are not corrupting your starting point by forcing data in.The art of teaching is clarity and the art of learning is to listen0
-
Thanks to you all.KS0
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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 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
