Sage 100 Error: “This Order Is Currently Being Invoiced” or “Entry already exists in batch xxxxx”

Description

Sage 100  Error: “This Order Is Currently Being Invoiced” or “Entry already exists in batch xxxxx” after selecting a Sales Order number in SO Invoice Data Entry or Shipping Data Entry.

Note: For the second error message, xxxxx represents a batch number and it means Batch Entry is enabled in Sales Order Options.

Cause

• The sales order being referenced already has an existing invoice entry or shipping entry.
• The batch number may be incorrect or missing.
• The invoice or shipping entry was deleted or is missing (perhaps due to a power outage), but the sales order still has a record of it, so no new invoice or shipping entry can be created for the order

Disclaimer

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions.

Resolution

If the sales order being reference already has an existing invoice entry or shipping entry:

• Do not attempt to create another invoice or shipping entry for the same order. Access the existing invoice or shipping entry to work on it instead.

If this error occurs because the BatchNo$ field is empty or incorrect for the relevant SO Invoice Header record.

1. Open Library Master, Utilities menu, Data File Display and Maintenance
2. For File Name, select the SO_InvoiceHeader.m4t file from the “..\MAS90\MAS_XXX\SOXXX” folder (where XXX is the company code)
3. Find and access the specific invoice record.
4. Select Edit
5. Edit the BatchNo$ to the correct batch number.
6. Go back into Invoice Data Entry or Shipping Data Entry again to work on the invoice.

If this error occurs because the sales order still references an invoice that has truly been deleted and does not show up in Sales Order Entry (or for the batch, if Batch Entry is enabled):

1. Open Library Master, Utilities menu, Data File Display and Maintenance
2. For File Name, select the SO_SalesOrderHeader.m4t file from the “..\MAS90\MAS_XXX\SOXXX” folder (where XXX is the company code).
3. Find and access the specific invoice record.
4. Select Edit
5. Erase the CurrentInvoiceNo$ to be blank (null, no value).
6. Go back into Invoice Data Entry or Shipping Data Entry again to work on the invoice and reference the sales order.

Note: For more information on how to use the Data File Display and Maintenance utility, see the Related Resources section below.