Hi Everyone,
I have a VI Job that is attempting to creating Invoices based on Sales Order data, but it's not executing as I had expected. The Sales Order data is being queried out of MAS using the ProvideX driver, formatted, then written to disk.
The flat file that I am using as an input contains both the header and detail items, and for each item the header data repeats. Because of this I do not have the "Header Separate from Line Record" box checked. I have my Data tab configured to match the layout of my header and detail items, and when I execute the import job it reports that 42 records have been added.
The problem is that my flat file only contains 7 Sales Orders. The flat file contains 21 lines, and when I look at the log from the import job, it appears that the header data and detail information are being split apart and treated separately.
Any ideas on why this might be happening?
Many Thanks!
I have a VI Job that is attempting to creating Invoices based on Sales Order data, but it's not executing as I had expected. The Sales Order data is being queried out of MAS using the ProvideX driver, formatted, then written to disk.
The flat file that I am using as an input contains both the header and detail items, and for each item the header data repeats. Because of this I do not have the "Header Separate from Line Record" box checked. I have my Data tab configured to match the layout of my header and detail items, and when I execute the import job it reports that 42 records have been added.
The problem is that my flat file only contains 7 Sales Orders. The flat file contains 21 lines, and when I look at the log from the import job, it appears that the header data and detail information are being split apart and treated separately.
Any ideas on why this might be happening?
Many Thanks!