Identify the Tables Updated During any Transaction

Solution:

In Sage Pro ERP 7.1 Build 3001.10, the PROTRANSACTIONPAUSE utility was added to the product. It allows the ability to identify which tables are updated throughout a particular transaction.

This utility must first be activated by setting the following environmental variables on the Microsoft Windows workstation:

Environmental Variables Required

Variable Name Variable Value
SBTDUTIL ON
PROTRANSACTIONPAUSE ON

Once these environmental variables are set on the workstation, logon to Sage Pro. When saving any transactions in any module, the program will pause before and after each table is updated. This helps to identify which tables are being accessed at any particular point of a transaction. This utility may be turned off by setting one or both of the environmental variables “OFF.”

The same transaction may update different tables depending on the system settings. For example a purchase order receipt would update the ICCOST table if using a FIFO or LIFO costing system. However, it would not update ICCOST if using a Weighted Average costing system. Other factors, such as serial numbers, also affect which tables are updated. This utility only pauses on those tables that are specifically updated by the transaction in progress.

Important
This utility is not meant for the Job Cost or any Manufacturing module. It may be use in any module that supports Multiple-Document Interface (MDI) screens.

Leave A Comment?