Disallow Empty Primary Key for Master Tables
Available in license(s): Finance
The Disallow Empty Primary Key feature of Productivity Package ensures that creating records with an empty primary key in a master table is disallowed. The feature also ensures that renaming existing record to a record with an empty primary key is blocked accordingly.
This prevents many fouls and mistakes that may occur if records with an empty primary key would exist. It is not uncommon that if for example an Item with an empty primary key would exist, users would forget to fill a sales line with the type Item with an actual No. This leads to all kinds of issues, for example the flowfield "Completely Shipped" on a Sales Order would never be shown as True.
Master Tables¶
This feature disallows empty primary key records for the following master tables:
- Bank Account
- Customer
- Item
- Job
- Resource
- Vendor
Block Creation of Empty Primary Key Master Records¶
When you try to create a master table record with an empty primary key, the application will prevent you from doing so. For example, if you (accidentally) attempt to create a G/L Account where the "No." field was left empty, then this will be blocked by an error that is raised to prevent further issues.
Block Renames to Empty Primary Key Master Records¶
When you try to rename a master table record to an empty primary key, the application will prevent you from doing so.
For example, if you (accidentally) attempt to change the "No." field for a Resource to empty, then this will be blocked by an error that is raised. This prevents that references to the Resource are renamed to an empty value, which is something that you should avoid, because otherwise you cannot make a proper distinction between an actual empty value in referencing fields or a reference to the blank resource.
