...
Overview
Implementation of Transaction transaction processing timeout and rollback (Transaction Rollback) began in AGRIS 10.3.1 (issue AGR-52033) with the Microsoft SQL (MSSQL) database only.
...
Transaction Rollback is enabled in the following areas in AGRIS 10.3.1 on 1 and greater on MSSQL:
- Accounts Payable Enter Disbursements
- Accounts Receivable Apply Payments
- Commodity Ticket Import
- Commodity Produce A Settlement
- Commodity Automatic Settlements
- Inventory Stock Additions (Add and Adjust)
- Inventory Invoice Entry (for each split invoice, not all split invoices as a whole)
- Inventory Automatic Invoices
Transaction Rollback is enabled in the following these additional areas in AGRIS 10.3.2 on 2 and greater on MSSQL:
- Accounts Payable Voucher Import
- Accounts Receivable Invoice Import
- Accounts Receivable Payment Import
- Commodity Actual Weights & Grades Import
- Commodity Apply From Storage
- Commodity Delivery Sheets
- Commodity Freight Expenses
- Commodity Reverse Tickets
- Commodity Void Settlements
- Inventory Reverse Invoice Entry
- Inventory Delivery Ticket
- Name/Address Import
...
Transaction Rollback Example
User The user is producing a sales settlement. The settlement contains 5 delivery sheets. The settlement will create an A/R Invoice.
After the user enters invoice information, the update process starts. The settlement updates. The first 4 delivery sheets and contracts update. The 5th delivery sheet updates. The 5th contract attempts to update but is locked by another user. The settlement user sees a record-in-use. The record-in-use times out. The transaction rolls back. The user sees an InUse error box. The process returns to the main menu. Net The net result is the settlement is a zero-amount voided settlement. The invoice is a zero-amount voided invoice. The delivery sheets and contracts are unchanged. The delivery sheets are available to be included for inclusion on a new settlement.