Error: "This order is currently being invoiced" or "This entry already exists in batch xxxxx" after selecting a sales order to reference in Invoice Data Entry or Shipping Data Entry

Summary

Error: “This order is currently being invoiced” or “This entry already exists in batch xxxxx” after selecting a sales order to reference in Invoice Data Entry or Shipping Data Entry for the Sales Order module in Sage 100 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

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Section I: Verify if the order can be found in Sales Order Invoice Data Entry

  • Note: 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.
  1. Expand Modules, Sales Order, Main, Invoice Data entry
  2. Click the Magnifying Glass icon to open the Invoice List window to search for the order’s invoice
  3. If present, open the invoice to continue invoicing the order
    • Or select Delete in the bottom right-hand corner to start again
  4. If the invoice is not present, proceed to Section II

Section II: 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.

Section III: Sales Order References Deleted Invoice

  • See Article ID 83641 Error: “This order is currently being invoiced” when selecting a Sales Order in Shipping Data Entry after a system crash