Update POS to OWN db first before the server.
Directly update POS to OwnDB without updating server yet
- Add column in branch table
- localnetworkip = pcname
- port = 80 - Add the Terminal table and the terminal sync table to the server manually
- Temporarilly update the version of the server's database to the version that will be used for the POS.
- Run Patcher > Install POS
- Copy the values from the posreceiptsettings/terminal and possettings tables from the server to to the pos' db
- run query: 3_update_terminal_table.sql at pos db
- Run POS as serverpos then as owndb to update the server's database
- Export posdata from outdated server. make sure to remove the 1st 2 lines of sql
- Import posdata to POS as new db, then use Insert Select query to overwrite the updated structure in the POS database
- Superadmin - ManualSync sales
- Check POS if OR# is updated
- Check saleshead, transactioncutoffs, cutoffs
- Check server vs pos if equal
- Revert the version changed from step 3 in the server's database