RMS Data

Posted by WRPD on September 8, 2006, 9:06 am

Please log in for more thread options

I am a new user with RMS, and I am trying to understand the SQL datastores;
Most seems fairly straightforward, but I have set up a new company, and when
I look in the MSDE database for store information, it is not there; I am
writing some conversion programs to populate my inventory and customer base
fromour old (but still in use) MicroBiz system.
Where is this data stored

I also need to modify the receipts that are generated to a greater degree
than appear to be provided by RMS; some of the data accessed in XML receipts
(eg subtotal) does not appear in the transaction database, so again where is
this data stored or accessed from

Thanks
wrpd

Posted by Glenn Adams [MVP - Retail Mgmt on September 8, 2006, 11:15 am

Please log in for more thread options

If you are talking about the Store Name and address information that you
configure using SO Manager, File/Configuration, then the data is in the
Configuration table.

Inventory is in Item - and sometimes ItemClass & ItemClassComponent
Customers are in Customer

Retail Realm has an import utility that will help you with this.

There is also an unsupported import utility available from MS tech support.

The information displayed on receipts comes from an internal object
called QSRules. You're right - some of the data is not stored in the
database, but it can be derived from other data - subtotal can be
derived from TransactionEntry information for example.

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

WRPD wrote:

> I am a new user with RMS, and I am trying to understand the SQL datastores;

> Most seems fairly straightforward, but I have set up a new company, and when

> I look in the MSDE database for store information, it is not there; I am

> writing some conversion programs to populate my inventory and customer base

> fromour old (but still in use) MicroBiz system.

> Where is this data stored

> I also need to modify the receipts that are generated to a greater degree

> than appear to be provided by RMS; some of the data accessed in XML receipts

> (eg subtotal) does not appear in the transaction database, so again where is

> this data stored or accessed from

> Thanks

> wrpd