|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
When data is imported into database tables, it is possible to overlook or disrupt the auto-numbering sequence for a particular table. The Serial Columns utility was designed to identify and correct problems caused by this scenario. Because this screen will be of little value to most users, access to this screen is limited to admin users only. To identify and correct sequence problems, select the "Serial Columns" option. The following screen will appear:
When identifying and correcting sequence problems, you are presented with the following options:
Select to include only tables which have sequencing problems in the display. No problems will exist as long as the "Next Key" value is equal to or greater than the "Largest Key Used" value. A problem exists if the "Largest Key Used" value is greater than the "Next Key" value.
Display lists the complete set of database tables and corresponding sequences. If the "Only Show Problems" option is selected, then only those tables which have sequence problems will be included in the display.
The following buttons are unique to this screen:
Select to fix all the sequence problems in all the tables.
Highlight a table and then select this option to fix only the highlighted sequence problem.