Keystroke Point of Sale Help


Database Manager - Menus - Setup - Default - Using Default Settings When Editing Database Records

The Edit Screen Default settings work when editing Database records, but only if a record's current field values already meet the criteria or formula defined in the Edit Screen Default settings.

Examples:

1- When the current field values on a database record "match" the criteria/formulas in the Edit Screen Default setting:

The Average Cost of an item is $100.00 and the Base Price is $200.00. If the Default setting Formula is "+M50" (Average Cost plus 50% Profit Margin) and the Average Cost is changed to $150.00, then the Base Price is automatically changed to $300.00.

2- When the current field values on a database records DO NOT "match" the criteria/formulas in the Edit Screen Default setting:

The Average Cost of an item is $100.00 and the Base Price is $225.00. If the Default setting Formula is "+M50" (Average Cost plus 50% Profit Margin), and the Average Cost is changed to $150.00, then the Base Price will NOT be changed and will remain at $225.00 (because $225.00 is not the result of adding a 50% Profit Margin to $100.00).

When making significant changes to the Edit Screen Default settings, the common result is that most database records no longer "match" the new criteria/formulas. Consider using the Search & Replace function to make records "match" the new criteria/formulas. Then when editing items, the Edit Screen Default settings will be effective.

See:

Database Manager Contents

Keystroke Help Table Of Contents