MAS200 - Issue with VI Job importing every line in a FF as a record.

[boomiTed]

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!

 

[dfeller]

This sounds normal.

Dawn

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[boomiTed]

Thanks Dawn.

My follow up question would be, if the flat file is being processed correctly, is there a reason why the batches that are created are empty?

I'm inclined to believe that it might have something to do with the Invoice No not getting created correctly, but I have it set to "NEXT", which I thought would just grab to next available number.


Thanks again!

 

[BigLouie]

You should be posting on the Sage Community where you will have access to more responses which will include Sage technical support.

If possible you should post the job and some of the source file.