Database impact of voiding a transaction

Starting with Acctivate 10.2, users will be able to void inventory transactions.  Report writers and consultants may need to understand the impacts of voiding a transaction from within the database tables so these voided transactions properly excluded from reports and other database queries.

Voiding a previously posted inventory receipt will make the following changes to these tables:

Table Field Change Comments
tbINVRegister PostedToINV This flag is cleared
tbINVRegister VoidedDate Timestamp is set at time of voiding transaction
tbINVRegister VoidedBy Acctivate user that voided transaction
tbINVTransaction PostedToINV This flag is cleared
tbINVTransactionDetail PostedToINV This flag is cleared

Voiding an Inventory Transaction will also flag the related Journals to be removed from QuickBooks during the next synchronization.

voidinventorytransaction

Posted in Inventory, Reports - Last modified on October 24, 2016Zach Allen
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.