Microsoft Dynamics NAV (Archived)

Accounting interface NAV 2016 with SAP business one

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi thank you for your Feedback but i have to export from nav to SAP with frequency day -1 automatically

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

XML port is the best way to inter connect each others

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

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.

Was this reply helpful? Yes No