SAP B1 to NAV mapping

girish.joshi
girish.joshi Member Posts: 407
edited 2008-03-25 in NAV/Navision Classic Client
Does anyone have a mapping between SAP B1 and NAV?

Comments

  • ara3n
    ara3n Member Posts: 9,258
    https://mbs.microsoft.com/partnersource ... 1toNAV.htm

    You'll find the fob in there with documents.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • girish.joshi
    girish.joshi Member Posts: 407
    Thank you very much, ara3n!

    For anyone else who takes a look at this:

    From first blush, it has a data map excel spreadsheet that is extremely useful. The documents are extremely helpful as well.

    I haven't tried the "tool", but I'm a little skeptical. Looks very similar to the NAV data migration tools.

    It also exclusively for master data. There is no information (that I could see in a 5 minute scan) on how to bring over documents.

    I'll post more after I try the tool.
  • ara3n
    ara3n Member Posts: 9,258
    You are welcome. Let us know if you find it useful.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • girish.joshi
    girish.joshi Member Posts: 407
    Unfortunately, I did not find this very useful for migrating over documents, bu t that isn't what it was designed for. For migrating over the following tables, it was exceptional.

    1. Customer
    2. Customer Ship-To
    3. Vendor
    4. Items
    5. Resources
    6. Bill of Materials
    7. Contact (company)
    8. Contact (person)
    To support the migration of these tables, additional supporting data tables are also included:
    1. General Business Posting Group
    2. Reminder Terms
    3. Payment Method
    4. Country
    5. Shipping Agent
    6. Salesperson/Purchaser
    7. Payment Terms
    8. Language
    9. Customer Price Group
    10. Territory
    11. Currency
    12. Manufacturer Code
    13. Item UOM
    14. Resource UOM
    15. General Product Posting Group
    16. Additionally, Production Bills of Material are divided into two migration components:
    a. BOM Header
    b. BOM Line
  • girish.joshi
    girish.joshi Member Posts: 407
    There have been a few things that are challenging. Discounts and Commissions don't map well between the two systems.

    Also, I had a tough time mapping dates on documents. From a B1 consultant I was given this advice:


    NAV Field - SAP B1 Field
    Posting Date - DocDate

    Due Date - DocDueDate

    Document Date - TaxDate

    I didn't find a good candidate for expected receipt/shipment date.

Categories