Inventory Quantity Logging
- John Bellos (Unlicensed)
Inventory Quantity can be affected by several factors, including some that have no correlation with the DVMAX Software (mishandling merchandise, entering in wrong qty into the program, etc). To help assist whether DVMAX is not updating the Quantity in the program correctly, we've created a function that logs each time a quantity record is attempted to be written to. This can be enabled and monitored by DVMAX Support.
Step 1: Turn the Setting On
Go to Section -> Hold SHIFT -> Click System Constants
Click the Functions tab, then Click the Data Editor button.
Locate the [kv_main] table and highlight it.
Click the Search button.
Search for: TheKey contains invnt
Click Query.
A record should appear, labeled internal.invnt.logQOH
In the Boolean field, ensure the setting is Enabled/Checked.
Each time an inventory quantity record is touched, it will be recorded in the database which can be referenced later to determine if the program is reducing the Quantity on Hand correctly.
Step 2: Checking Log Entries
Go to Section -> Hold SHIFT -> Click System Constants
Click the Functions tab, then Click the Data Editor button.
Locate the [Inventory_QuantityLog] table and highlight it.
You can either click 'All' or 'Search' to narrow down your log to a specific inventory item code.
From here, you can try to pair up Methods that ran at a specific Time, to invoices or purchases that have occurred since the last time a quantity on hand was verified. This should help identify whether DVMAX is updating the quantity on hand when requested.