1. Home
  2. Point-Of-Sale Software
  3. RMS Data

RMS Data

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

Reply to
WRPD
Loading thread data ...

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 C> I am a new user with RMS, and I am trying to understand the SQL datastores;

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.