Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / RMS XML?
Microsoft Dynamics RMS (Archived)

RMS XML?

(0) ShareShare
ReportReport
Posted on by DEVON LEROUX 1,565

Hey guys, we are wondering what exactly the RMS XML is/looks like when you "post closed batches"

We're using HQ and have been so confused as to how to integrate with our accounting software and because of this haven't posted any closed batches for the last year as it doesn't seem very simple.

Is this just a text file that we can print out and then manually enter into our simply accounting software?? If any of you have a preview that we could see just to get a feel for it that would be greatly appreciated.

Thanks,
Devon

*This post is locked for comments

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: RMS XML?

    Devon,

    The RMS XML export is simply a XML file that will get dropped in a path you specify when you export.  This file contains information about various accounting point in a batch (COGS, Dept Sales, Taxes, etc.) in a single file.  You can use any text editor to view these files and I have included a sample below (sorry for the lack of formatting).  As far as importing this into your accounting software, that is completely up to that program as to whether it will accept such a file or not.

    <?xml version="1.0" encoding="utf-8" ?>

    <JournalTransactions

    UserID="1"

    ExportSource="HQ"

    Version="1.00"

    LanguageLocale="enu"

    DateTimeStamp="10/24/2011 11:56:41">

    <JournalTransaction

    StoreID="1"

    TransactionID="1"

    CompanyName="Tailspin Toys"

    VATEnabled="False"

    VATDetailID=""

    Date="08/12/2011">

    <TransactionEntry

    TransactionEntryID="7"

    AccountNumber="Sales"

    Memo="Sales: Total"

    CreditAmount="369.97"

    DebitAmount="0"

    CurrencyCode="USD"

    IsSalesTotal="True"

    IsSalesTax="False" />

    <TransactionEntry

    TransactionEntryID="7"

    AccountNumber="sales"

    Memo="Sales: Total"

    CreditAmount="0"

    DebitAmount="369.97"

    CurrencyCode="USD"

    IsSalesTotal="True"

    IsSalesTax="False" />

    </JournalTransaction>

    </JournalTransactions>

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans