The NEXT operation isn't working when importing with Visual Integrator
Description

 

 

Cause

Visual Integrator needs a header field using the Replace operation to check when header values change.
If no header field uses Replace, Visual Integrator can create a new header record for each source line.

Resolution

Review the header fields

  1. Open the import job in Import Job Maintenance.
  2. Review all header fields with Operation set to Replace.
  3. Review the corresponding values in the source file.
  4. Confirm that these values change when Visual Integrator needs to assign NEXT.

Add a temporary header field

If all replaced header values remain the same for every record, add a temporary header field.
  1. Create a Header Temp field.
  2. Set Operation to Replace.
  3. Select a source column whose value changes when Visual Integrator needs to assign NEXT.

TIP:

When importing into GL_GeneralJournalHeader, verify H.SourceJounal appears before H.EntryNo.

 

 

Need more help?

Chat now

Steps to duplicate
Related Solutions

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