Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
RMS/NAV Integration
tinik
Member Posts: 22
Hi to anyone..
Has anyone actually integrated RMS to NAV 4.0? I need H.O. P&P and S&R dumped to NAV. Please share your thoughts and ideas. Thanks.
Best regards,
Tinik
Has anyone actually integrated RMS to NAV 4.0? I need H.O. P&P and S&R dumped to NAV. Please share your thoughts and ideas. Thanks.
Best regards,
Tinik
0
Comments
:idea:
Here are my thoughts.
Create purchase order in nav.
A trigger or stored procedure to pass the po to rms
Receive goods in rms bearing in mind version 1.3 does not have goods receipt consignment no field (am using bespoke app).
use dataports to import goods receipts back in nav.
use dataports to import stock movement between locations back in nav
use dataports to import sales and payments for the sales to create sales order back in nav
As purchasing is done in Nav any new items created need to passed back to rms therefore before a purchase order is passed to rms new items need to be created in rms again dataports or stored procs to the same
[-o<
I need to get this done asap therefore any thoughts, tips, or areas to be aware of would be appreciated
Regards
Bharat
I know RMS integrates with GP. I wonder if I can just trade in NAV for GP?
Are you interested in custom solutions for RMS Integration work. If so please contact me.
Regards,
Manick
ERP Solutions Specialist
zslinc, USA
manick.m@hotmail.com
How I may receive information about this custom solution?
P.S. May be you help receive MS RMS 2.0 for testing? ](*,)
Yuriy Golyachuk, NAV Solutions Specialist & Developer
Skype: RedFoxUA
Yes, we are the creators of MASI Retail Portal(TM).
See http://www.masi.com/markets/MASIRetailPortal.html for more information...
_________________
Paul Berberich
MicroAccounting Systems, Inc.
Bellevue, WA, USA
Our company uses both NAV 4.0 and RMS 2.0 at the 5 retail store locations in Australia. I have done integration myself between the two systems at various levels.
Before we decided to roll our own, we have briefly looked at the NAV-RMS integration solutions offered by two different MBS partners. Their integration approaches are so different and are usually the result of their implementation experience with customers. For this reason, their underlying assumptions and design decisions differ substantially as their customers' requirements are different. For example, one MBS partner assumes users would/should create items in RMS, which I never thought is a good idea, especially if the user company is a vertical retailer (e.g., GAP), because Navision has a much richer Manufacturing and Order Processing features (large retailers as big as GAP would not use RMS). The other MSB partner chose to do it without RMS HQ and sync directly with individual RMS SO databases. I am sure you will see a few more in the U.S.
If you are seriously considering an NAV-RMS integration solution, do ask to see a demo of their solution and get your MBS partner to explain their underlying assumptions and ask who their customers are (whether they are a multi-store retailer stocking items from multiple vendors or a true vertical retailer who is also involved in design and production and has their own brand).
When it comes to G/L integration, you should ask how sales transactions are transferred back to NAV and how they are posted. For example, do they provide you with options to record each transaction as an individual invoice (which only makes sense if the sale is trackable with customer name and forms the foundation for loyalty programs) or journal line entry for non-trackable cash sales.
It's like buying the same croissant from different bakeries; you need to walk into the kitchen and chat with the baker about his recipes.
Scott