×
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

Visual Integrator Import Job with Invalid Vendor Number Record.

Visual Integrator Import Job with Invalid Vendor Number Record.

Visual Integrator Import Job with Invalid Vendor Number Record.

(OP)
I am running Mas 4.20.0.17. When I try to import new Inventory records using Visual Integrator, the Vendor Number returns "Invalid Record". All other records pass. I am using CSV format for the import file. My Vendor numbers are pure numeric and are four digets like 1234. I know they must be preceded by 000 for a total of 7 digets.

The PRIM_VENDOR_NO field validation is set to Method=File, Skip=Yes, Validation String=AP.VENDOR. I have tried Skip=Yes and No.

Under the data tab, PRIM_VENDOR_NO Type=ACCT, FG=S, Operation=REPL, Column=28 and Import Mask=#######.

Any Idea or suggestion would be greatly appreciated!

When I view the test summary, the number 0001009 shows in the field as it should but still says it is Invalid.

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

Are you including or assigning a division number? The actual key for the vendor is the division number and vendor number.  

 

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

(OP)
Division is not included under the Data Tab. It is included under the validation tab and Skip is set to Yes if that matters here.

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

Actually it is. It is right above Primary Vendor. If you look at the Validation tab and pull up Primary Vendor you will notice that the validation is set to IM1(85,9) and for the division it is set to IM1(85,2) This means that you must have the division as part of the import if you have the primary vendor. It is including the Division for the vendor as part of the validation of the vendor number. Even if you do not use divisions you have to use 00 as the division or it will fail.

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

(OP)
BigLouie, With your help I now understand the problem. I have done similar imports before with hit and miss success. Never really understood the problem. Our Mas Supporters charge $150 an hour which I guess is OK but it means we sometimes go with unanswered questions. Very glad to find this Forum and if you were a drinking man, I would buy you a beer. Thanks again very much for the help!  

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

This is actually a rather small community of MAS users.  There is a much larger community on Sage's website.

http://community.sagemas.com/sagemas/

Dawn

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

"Our Mas Supporters charge $150 an hour which I guess is OK but it means we sometimes go with unanswered questions."

This is the standard rate for most resellers. While people such as Dawn and myself can help on the small and quick stuff your reseller is still your best option for support as they know your system.

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

Hi,

I'm currently working on a project that requires the use of MAS 200 (visual Integrator), the company wants to go with CSV files and import INVOICES.

I honestly don't know where to start, i'm trying in vain but nothing comes up, could anyone help PLEASE!!!

thank you,

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

by the way the version of MAS 200 that we're using is 4.30.0.8

thank you again!

RE: Visual Integrator Import Job with Invalid Vendor Number Record.

1. You should be working with your reseller
2. Second you can contact me direct at bglouie at sbcglobal dot net.  This is actually an easy import. Did one in 10 minutes for someone just the other night.

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