Visual Integrator Next Operation is not Working in Sage 100
Summary
Next operation not working when importing using Sage 100 Visual Integrator module
Resolution
- Open Import job in Import Job Maintenance
- Examine all header fields with Operation set to Replace
- Examine the values in the sourcefile for these fields
- Next is assigned when any of these values change
- If all replaced Header values are the same for each record:
- Create Header Temp field
- Set Operation to Replace
- Replace from column in sourcefile that changes value when a new Next operation should be assigned
- Note: If importing into GL_GeneralJournalHeader, verify H.SourceJounal is displayed before H.EntryNo