Offline Batches not in SO database, still in SO Offline database

HI, You must be online to sync. the offline database with your live database, the data get sync automatically as soon as you log back on to POS.

"Bradley" wrote:

Yes, ofcourse you have to go back online. Thats the only way to get your X and Z reports anyway. Anyone out there that knows the inner workings of offline mode? I want to reset the tables so that it thinks the reg is offline and the batches are not sync'd to the online database.

"Akber Alwani" wrote:

Here I am, sorry I have off on Thursday and Friday but what you requested is here: below are the tables use in offline sync.

AccountReceivable AccountReceivableHistory Batch Register Configuration CalendarEvent DailySales DropPayout Import ImportEntry InventoryTransferLog Journal Message NonTenderTransaction OldJournal [Order] OrderEntry OrderHistory Payment PurchaseOrder PurchaseOrderEntry PurchaseOrderEntryDetail RecordDeletedLog Shipping TaxEntry TaxTotals TenderEntry VisaNetAuthorization VisaNetBatch TenderTotals TimeCard TimeClock [Transaction] TransactionEntry TransactionHold TransactionHoldEntry Voucher VoucherEntry

Some more tables:

--------------------------- Item ItemTax ItemMessage ShippingService ShippingCarrier LimitEntry Customer

There are other tables also but I th> HI,

There is a setting in the RegEdit of each POS under:

HKEY_LOCAL_MACHINE == SOFTWARE == MICROSOFT == RETAIL MANAGEMENT SYSTEM =STORE OPERATIONS == POSUser where it says TerminalOffLine and it normally says False. If you turn that to True it will try to re-synch the data.

Hi all,

We had the same issue where the till's were on a domain, and when the link dropped the till went into offline, and didn't sync up the sales when the pos went back online. They are still in the offline database. We're working on the theory that its caused by user rights as the users do not have local admin rights.

Any thoughts? Cheers

"Bradley" wrote:

Couldn't see your attachment, thanks anyway. Sorted the issue by removing the POS from Domain authentication, put it onto a LAN, and then by changing the batch number in the offline transaction table to the last open batchnumber from the offline batch table. We then forced the registry to say till was in offline, started the till up, and the sales came in.

Cheers

"Ahmed Nashat" wrote:

reference whenever i face such problem.

You already did the right steps, good job!