RMS/NAV Integration

tinik
tinik Member Posts: 22
edited 2008-06-24 in Retail Management System
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

Comments

  • bshah
    bshah Member Posts: 3
    I am in the same boat.
    :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
  • xgrk88a
    xgrk88a Member Posts: 1
    I am also looking for a way to integrate NAV with RMS. There are so many different ways to do it. I don't even know where to begin.

    I know RMS integrates with GP. I wonder if I can just trade in NAV for GP?
  • manick
    manick Member Posts: 4
    Hello,

    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
  • RedFoxUA
    RedFoxUA Member Posts: 21
    manick wrote:
    Hello,

    Are you interested in custom solutions for RMS Integration work. If so please contact me.

    How I may receive information about this custom solution?

    P.S. May be you help receive MS RMS 2.0 for testing? ](*,)
    Regards,
    Yuriy Golyachuk, NAV Solutions Specialist & Developer
    Skype: RedFoxUA
  • pberb
    pberb Member Posts: 31
    tinik wrote:
    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

    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
  • gumboots
    gumboots Member Posts: 23
    xgrk88a wrote:
    I am also looking for a way to integrate NAV with RMS. There are so many different ways to do it. I don't even know where to begin.

    I know RMS integrates with GP. I wonder if I can just trade in NAV for GP?

    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

Categories