Update scheduler data for version 2021

In this version of LS One new tables were added for LS Pay and Stock valuation that require data replication. There are also some new fields in existing tables so when you update to version 2021 from 2020.1 you need to create new subjobs for the new tables and do a read database design.

To be able to upgrade you will need the following information

Scheduler data update

To update your scheduler data from LS One version 2020.1 to version 2021 you will first have to do a Read design. Then you will have to create subjobs for the new tables and add them to the jobs being sent.

Run Site Manager version 2021 and log in to your database.

When you do this the first time your database will be upgraded to 2021 version. Make sure to take a backup before updating the database. New tables and fields are added to your database.

  1. Go to Tools > Replication Settings > Distribution locations. Open the location from where you manage your replication and scheduling.
  2. In the right hand navigation press Read design

  3. Select Tables and fields and Update existing database design options and press OK.
  4. Now the Data Director will run through your database design and update it to include all new fields and tables.

Add both action (A-) and normal (N-) and (O-) jobs for the new data table listed above. On further information on how to do so read Subjobs.

Add the new action and normal jobs to the existing jobs. Read this topic: Jobs for more information on how to create and manage jobs.
Below is a list of all the job changes that were made to the demo replication data package:

New tables and subjobs

Create the following subjobs for the new tables:

LS Pay

  • N-LSPAYCURRENCYMAPPING - a normal job

  • N-RBOTRANSACTIONEFTEXTRAINFO - a normal job with a replication counter

Stock valuation

  • spINVENTORY_ArchiveItemCost - a procedure job that moves old cost lines from the RETAILITEMCOST table to the RETAILITEMCOSTHISTORY table.

Archive item cost - NEW JOB

Including subjob:

  • spINVENTORY_ArchiveItemCost

This job is used to move old cost lines from the RETAILITEMCOST table to the RETAILITEMCOSTHISTORY table to archive. The RETAILITEMCOST table can become very big and cause performance delays.

Preload POS

Added:

  • N-LSPAYCURRENCYMAPPING

Preload Store

Added:

  • N-LSPAYCURRENCYMAPPING

Transactions from POS:

Added:

  • N-RBOTRANSACTIONEFTEXTRAINFO

Transactions from store to HO:

Added:

  • N-RBOTRANSACTIONEFTEXTRAINFO
Inserted: March 2021
Version: LS One 2021