Open items do not appear in the Small Balance/Credit Write Off dialog box in Microsoft Solomon Accounts Receivable (885303)

Resolutions

Resolution 1

Click Type, and then choose either Small Balance for invoice or debit memo balances or Small Credit for payment or credit memo balances.

Resolution 2

Under Optional Selection Criteria, enter the correct Company ID, or Customer ID, or both. Click Find Documents.

Resolution 3

Click Find Documents to populate the grid with open items to be written off.

Resolution 4

Verify the Write-Off Limit value, and then adjust the Write-Off Limit to a value that includes the amount that must be written off.

Resolution 5

Unreleased payment applications will prevent items from appearing. To determine whether unreleased payment applications exist, follow these steps:

1. To determine whether there are unreleased small balance transactions, use SQL Query Analyzer, and run the following query on the application database:

   select * from artran where drcr = 'U' and siteid = 'xxxxxx'

   Note xxxxxx is the reference number of the invoice or of the debit memo.
   
   
2. To determine whether there are unreleased small credit transactions, use SQL Query Analyzer, and run the following query on the application database:

   select * from artran where drcr = 'U' and refnbr = 'xxxxxx'

   Note xxxxxx is the reference number of the payment memo or of the credit memo.
   
   

If records are returned from either query, the value in the artran.batnbr field will identify the batch number of the unreleased Payment Application batch. Use Release AR Batches (08.400.00) to release the batch, or use Payment Application (08.030.00) to delete the batch.