Open small balances or credits do not appear in the "Small Balance/Credit Write Off (08.450.00)" screen in Microsoft Dynamics SL

To resolve this problem, use one of the following resolutions.

Resolution 1

In the Type box, select one of the following options:

• Select Small Balance for invoice balances or for debit memo balances.
• Select Small Credit for payment balances or for credit memo balances.

Resolution 2

In the Optional Selection Criteria area, type the correct company ID in the Company ID box, type the correct customer ID in the Customer ID box, or type the correct values in both boxes.

Resolution 3

Click Find Documents to start the search for open documents that fit the selection criteria.

Resolution 4

Verify the value in the Write-Off Limit box, and then adjust the value in Write-Off Limit box to a value that is larger than the amount that you want to write off.

Resolution 5

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

1. To find unreleased small balance transactions, use SQL Query Analyzer or SQL Server Management Studio to run the following query on the application database.

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

   Notexxxxxx is the reference number of the invoice or of the debit memo.
   
   
2. To find unreleased small credit transactions, use SQL Query Analyzer or SQL Server Management Studio to run the following query on the application database.
   
   
   

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

   Notexxxxxx is the reference number of the payment or of the credit memo.
   
   

If records are returned from either query, the value in the batnbr field identifies the batch number of the unreleased payment application batch. Release the batch by using the Release AR Batches (08.400.00) screen, or delete the batch by using the Payment Application (08.030.00) screen.