Hi
I have to export the accounting on dynamics nav to SAP business one.
did anyone worked on the same project or some one now an existing add on?
*This post is locked for comments
Hi,
First you need to identify which data (Masters or Transactions) you will need to keep in sync between both the systems.
Later you can make use of the comments by Amol Sir or Tharanga Sir to proceed with the development.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
You can have different solutions,
1. You can use XML port to export data from NAV and then import it to SAP.
2. You can write a code to create a text or csv files and then import it to SAP.
3. You can expose web service and ask SAP developers to develop an module (may be already exists) to read the data. This will be the best solution as it will be real-time and more flexibility, also other users will not be able to amend anything as there will not be generated files.
4. You can ask SAP developers to get the data directly from NAV SQL DB. This will work fine but not much recommended.
First 2 options also can be automated.
XML port is the best way to inter connect each others
For exporting you can write xmlport or report in specified format given by SAP and then you can schedule the XMLPORT or report which will create thr file and SAP can write program to pick up the file and import
Hi thank you for your Feedback but i have to export from nav to SAP with frequency day -1 automatically
You can do following
1) Prepare the chart of Accounts,Customer,Vendor,Bank Masters from SAP and import it in NAV.
2) Prepare the closing balance entries from SAP and import it in NAV.
3) Once confirm you can post the entries and you can start your transactions.
AFAIK there is no add-on for this as you need to prepare the data from SAP and import it in Dynamics NAV.
You can use Rapidstart in NAV for preparing the templates and import the data.
For exporting you can do following
1) Prepare the chart of Accounts,Customer,Vendor,Bank Masters from SAP and import it in NAV.
2) Prepare the closing balance entries from SAP and import it in NAV.
3) Once confirm you can post the entries and you can start your transactions.
AFAIK there is no add-on for this as you need to prepare the data from SAP and import it in Dynamics NAV.
You can use Rapidstart in NAV for preparing the templates and import the data.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156