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.
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.
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
http://community.sagemas.com/sagemas/
Dawn
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
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.
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.
thank you again!
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
Dawn
Visit Sage's Online Community mmunity.sa gemas.com/ sagemas/?c ategory.id =SageMAS90 and200Disc
http://co
RE: Visual Integrator Import Job with Invalid Vendor Number Record.
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.