Flexible Billings invoice batch numbers and AR batch numbers can overlap

This article provides a solution to an issue where Flexible Billings invoice batch numbers and Accounts Receivable batch numbers can overlap.

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

Resolution

To fix this issue, follow these steps:

  1. Find the last or highest batch number used from both the Flexible Billings and Accounts Receivable modules. To do this, run the following queries in Microsoft SQL Server Management Studio.

    select MAX(batnbr) from Batch where Module='BI'
    select MAX(batnbr) from Batch where Module='AR'
    
  2. Set the batch numbers in Accounts Receivable and Flexible Billings far apart so that they don't overlap.

    1. Open Billings Setup (BI.SET.00) and on the General Information tab, update the Last Invoice Register Batch#.
    2. Open AR Setup (08.950.00) and on the Other Options tab, update the Last Batch Number.