How to Write-off, Adjust, or Drop A/P Recon Records

AP Recon Register has a lot of transactions showing small variances (ie. Variances of $5 or $10).  

How to clear A/P Recon records from A/P

Go to Accounts Payable > A/P Recon > Drop/Adjust A/P Recon

1.      Choose Mode of Drop or Adjust variance
     - Drop will permanently remove the detail records from A/P Recon.
     - Adjust will set the variance to zero and keeps the details for future research.

2.      Click Search

Drop Mode Option

1.      Select the Set/Unset Drop Flag to set the Drop flag to Yes for all transactions that are highlighted.

2.      Use the Mass Update icon to select transactions based on certain criteria options.

-          Can select all transactions to Drop that have an In Balance date before MM/DD/YY or select transactions that are within a specific dollar or percent variance.

3.      Select the correct offset GL account and then select Drop.

-          The transactions are permanently removed from Agility and will not show in AP Recon or on the AP Recon Register.

Adjust Mode Option

1.      Select the Set/Unset Adj Flag to set the Drop flag to Yes for all transactions that are highlighted

2.      Use the Mass Update icon to select transactions based on certain criteria options.

-          Can select all transactions to Adjust Variance to Zero that are within a specific dollar or percent variance.

3.      Select the correct offset GL account and then select Adjust Variance.

-          The transactions will still show on the AP Recon Register but the variance will be zero.

How to find dropped records

If an A/P Recon Record has been dropped, you can still find it. Run a query on the purge_history table to find the records. You can search by tran_id, invoice_number or drop_date.