How to use the Next operation in Visual Integrator to assign the Next Automatic Number for Entries, Invoices, Orders, Checks, etc.


Sage 100


North America


How to use the Next operation in Visual Integrator to assign the Next Automatic Number for Entries, Invoices, Orders, Checks, etc. in Sage 100

Note: This will not work to assign Batch Numbers. This will not work to assign A/P Invoice Numbers. See below.



Sage Customer Support does not provide assistance for issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.


For Business Framework modules:

  1. Open Visual Integrator, Main menu, Import Job Maintenance
  2. . Access or select the Import Job
  3. Access the Data tab
  4. Open the field, such as Invoice Number or Order Number
  5.  Set Operation to Next
  6.  Click Accept button


  • Visual Integrator will track each Header field in an import job that is set with the Operation of Replace
  •  The Next value is assigned whenever any of these Header fields (with the Replace operation) changes value in the source file
      •  Note: If all header records are the same value (no header change) then this will not properly trigger the Next value
  • Note: If an import job has no Header fields set with Replace operation, then every line will be treated as a new entry.
    • To properly assign Next value in this scenario, add a Temp Field to import job with the following properties:
        • Operation: Set to Replace
        • Col/Pos: Enter column from sourcefile that changes when a new entry is desired
        • Assign Temp On: Set to Header Record
  • Batch Number: The Next operation is reserved for fields such as Order number or Invoice number. It cannot be used to get the Next Batch Number. If the Next Batch Number is desired, simply set operation to Assign and leave the default value blank. (Unfortunately, this will create an empty Batch 00000 if selecting Test – however, that will clear when all the existing batches are updated.)
      •  Note: This method does not work with Payroll Data Entry import on Sage 100 2018 and higher. Batch number must be Replaced or Assigned.
  • A/P Invoices are invoices received from vendors, so Sage 100 does not allow the Next operation to be used for Invoice Numbers.

For Legacy Modules:

  •  The source file must contain separate Header & Detail lines for NEXT operation to work
  •  The Next number will be assigned to each Header Record
  •  Deselect the option “Header Information Included in Detail Line” on the Configuration tab
  • Define both Header Record & Detail Record in the Records tab


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.