I am trying to import sales history into the Microsoft RMS data base. I have populated fields in the Transaction, the TransactionEntry, and the Batch tables, yet I can not see any sales history data through the RMS applications. Am I missing some required fields? Here are the fields I have populated:
Transaction: StoreID, TransactionNumber, BatchNumber, Time, CustomerID, CashierID, Total, Sales Tax. Transaction Entry: Cost, FullPrice, StoreID, ID, TransactionNumber, ItemID, Price, Quantity, SalesRepID, Taxable. Batch: Batch Number, OpenTime, CloseTime.