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)

RMS XML?

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Ryan Sakry Profile Picture
    3,425 on at

    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

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