×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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!

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

(OP)
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!

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

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close