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

Applies to: Dynamics SL 2011Accounts Receivable

Symptoms


When you open the Small Balance/Credit Write Off (08.450.00) screen, existing open small balances or credits do not appear in Accounts Receivable in Microsoft Dynamics SL or in Microsoft Business Solutions - Solomon.

Cause


This problem may occur because of one of the following reasons:
  • You select the wrong value in the Type box in the Small Balance/Credit Write Off (08.450.00) screen. To resolve this problem, see Resolution 1 in the "Resolution" section.
  • In the Optional Selection Criteria area, there is an incorrect value in the Company ID box, in the Customer ID box, or in both boxes. To resolve this problem, see Resolution 2 in the "Resolution" section.
  • You do not click Find Documents. To resolve this problem, see Resolution 3 in the "Resolution" section.
  • The balance is more than the value in the Write-Off Limit box. To resolve this problem, see Resolution 4 in the "Resolution" section.
  • Unreleased payment applications exist. To resolve this problem, see Resolution 5 in the "Resolution" section.

Resolution


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.