SAP B1 to NAV mapping

girish.joshi

Does anyone have a mapping between SAP B1 and NAV?

ara3n

https://mbs.microsoft.com/partnersource ... 1toNAV.htm

You'll find the fob in there with documents.

girish.joshi

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

You are welcome. Let us know if you find it useful.

girish.joshi

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

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.