web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Import data from Excel into RMS PO/transfers

(0) ShareShare
ReportReport
Posted on by 195

Please - is there a utility that allows PO's and transfers to be populated from data in an Excel spreadsheet?

Thanks.

Micky

*This post is locked for comments

I have the same question (0)
  • Kinnard Profile Picture
    80 on at

    Micky, there is not, I am a reseller partner and I view this as a significant impediment to the POS operation.  I have studied what I can find regarding the POS2009 upgrade and, so far, I have been unable to determine if it will be included in the release.  There are third parties that offer solutions, but they have a complete package using some sophisticated    data collection devices, but not a simple importer for a CSV file.  The only import is available in the Physical Inventory module, included with the program.

    Kinnard L. Kohler

    Retail Management Systems of Arkansas

    P. O. Box 3332

    Little Rock, AR 72203-3332

    [Voice] 501-412-5686

    [Fax] 501-325-1315

    pos@kohler.net

     

  • mikelondon Profile Picture
    195 on at

    Dear Kinnard,

    Thanks for your reply.  We really struggle with the manual entry of this data.  Are there any third-party solutions that you would recommend?  Would much appreciate your advice.

    Michael

  • Dave Durrenberger Profile Picture
    1,622 on at

    Michael,

    This is a relatively simple Add On and one we would add into our existing RMS Forecast and Ordering Tools:

    http://www.syssolutionsllc.com/page/Addons/ForecastOrdering

    If you would like to discuss it further contact us at: http://www.syssolutionsllc.com/

     

  • Community Member Profile Picture
    on at

    Try using HQ worksheets (style 330 and 340), and right click on the contents, then import (you will get errors, try to make the excel file like the worksheet style).

     

     

     

    thank you

    Mohammed El Qadi

    http://www.fact.fm/viewforum.php?f=30

     

     

     

  • mikelondon Profile Picture
    195 on at

    Dear Mohammed,

    Very smart!  Will give this a go.

    Thanks.

    Michael

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans