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

Notes:

• 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