Open small balances or credits don't appear in the Small Balance/Credit Write Off (08.450.00) screen in Microsoft Dynamics SL

  • Article

This article provides a solution to an issue where existing open small balances or credits don't appear in Accounts Receivable when you open the Small Balance/Credit Write Off (08.450.00) screen.

Applies to:   Microsoft Dynamics SL 2011
Original KB number:   885303

Symptoms

When you open the Small Balance/Credit Write Off (08.450.00) screen, existing open small balances or credits don't 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's 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 don't select 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

Select 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'

    Note

    xxxxxx 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'

    Note

    xxxxxx 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.