Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Accounting interface NAV 2016 with SAP business one

Posted on by Microsoft Employee

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

  • Suggested answer
    Yogesh Kulkarni_ Profile Picture
    Yogesh Kulkarni_ 1,762 on at
    RE: Accounting interface NAV 2016 with SAP business one

    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.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Accounting interface NAV 2016 with SAP business one

    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.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Accounting interface NAV 2016 with SAP business one

    XML port is the best way to inter connect each others

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Accounting interface NAV 2016 with SAP business one

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounting interface NAV 2016 with SAP business one

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

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Accounting interface NAV 2016 with SAP business one

    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.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Accounting interface NAV 2016 with SAP business one

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans