Automatic functions

The DbNet system has been designed to make data entry easier by performing selected functions automatically. The system will also update any changes it makes to the user's screen immediately after commiting data so that the information is always current.

On screen totals

Related fields on the screen are updated automatically as soon as any changes are committed to the screen. This will make screens easier to read as they are always current and do not require manual refreshing to be updated.

In the example above, if the price for a line item is changed, the ext sub_total and the order total will be automatically updated and soon as the price value is committed by typing the enter key. Any fields that have mathematical relationships to other fields on the current screen will be updated automatically in a similar manner. For example, if the quantity of a line item were changed, the ext subtotal, the order total and the order quantity would all be adjusted automatically on screen.

Cross posting data

A data element will often have associated data that may be useful when entering a cross table field. For example, the item table includes fields for code, description and price. When entering a Sales Order, it can help speed data entry if the description and price are automatically posted based on the item code entry.

In the example above, the price data for item code 12345 is automatically set when the user enters the code on the screen. In fact, all the user needs to do is to type in the code in the code box and the system will look up the full data in the item table and post the relevant parts. If, for some reason, the price on the Order were different from the price set in the system, the user may change the price manually on the Sales Order screen without affecting the price in the database. If the systemwere not able to find any data for the code entered, it would ask the user if they would like to make a new entry.

Transaction posting

One of the more powerful features of the DbNet system is the ability to make or alter entries in related tables as a result of changes made to a particular data element. This can be observed in the Shipment table. When an item is shipped off of a Sales Order, the quantity shipped is deducted from inventory automatically by the system. This will help maintain an accurate inventory count. The system also offers the ability to post transactions in the customer Accounts Receivable to reflect the dollar value of the shipment invoice. The transaction posting will also be reflected in the office account if there is a commission set for the order.