1. Use Assign or Write Triggers to Audit database changes
TRIGGER PROCEDURE FOR ASSIGN OF item.on-hand
oh-audit.item-num = item.item-num
oh-audit.new-on-hand = item.on-hand
oh-audit.oh-change = item.on-hand - old-on-hand
oh-audit.changed-by = userid
oh-audit.change-date = today
oh-audit.change-time = time
oh-audit.change-prog = program-name(2).