You’re offline. This is a read only version of the page.
Announcements
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
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>
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
