Inventory Control Tests

Inventory adjustment has unposted distributions
This test searches for inventory adjustment transactions that have subsidiary ledger distributions that have not been posted. This test will return a list of transactions and their unposted distributions.
Availability: Included in 1.0

Inventory adjustment has transaction date outside of defined fiscal periods
This test searches inventory adjustment transactions to determine which have dates outside the defined fiscal periods. This test will return a list of transactions with dates outside the range of periods.
Availability: Included in 1.0

Inventory adjustment distribution posting date outside of defined fiscal periods
This test searches inventory adjustment distributions to determine which have dates outside the defined fiscal periods. This test will return a list of distributions with dates outside the range of periods.
Availability: Included in 1.0

Inventory adjustment distribution posting date not the same as journal batch posting date
This test compares the inventory adjustment distribution posting date to the journal batch posting date. This test will return a list of distributions with inconsistent posting dates.
Availability: Included in 1.0

Inventory adjustment transaction date not the same as distribution posting date
This test compares the inventory adjustment transaction date to the distribution posting date. This test will return a list of inventory adjustment transactions with inconsistent posting dates.
Availability: Included in 1.0

Unexpected batch types in inventory adjustment control account (ADJ)
This test searches batches contained within the inventory adjustment control account. This test will return a list of non inventory adjustment journal batches.
Availability: Included in 1.0

Inventory balance has posting date outside of defined fiscal periods
This test searches the inventory balance record to determine which records have dates outside the defined fiscal periods. This test will return a list of part numbers with dates outside the range of periods.
Availability: Included in 1.0

Part location quantity is not the same as the sum of transactions
This test compares the part location summary quantity to the total of all transaction quantities. This test will return the total quantity for each of these two and any discrepency should it exist.
Availability: Included in 1.0 for SQL Server only

Part quantity is not the same as the sum of transactions
This test compares the part on hand quantity to total of all transaction quantities. This test will return the total quantity for each of these two and any discrepency should it exist.
Availability: Included in 1.0 for SQL Server only

Unexpected batch types in inventory control accounts
This test searches batches contained within the inventory control accounts. This test will return a list of non inventory related journal batches.
Availability: Included in 1.0

More V-Ferret Tests

Select another functional area to see even more tests for that area: