I have an import script that exports all my files to a .xlsx however, on my import im having issues on some layouts not going to the next serial number field. For example i left off at record 4608 on table Systemlog and after i ran the import, its starting at 1000 for some reason and its throwing an error because 1000 already exists. Here is my import script. I don't understand what I'm doing wrong. Other layouts work fine.
This script is so when i upgrade the runtime app version users can extract and import their data.
Layouts having the issue are systemlog and beer history. All other layouts go to the next serial number value fine.
Appreciate any help on this.