sirrandolph
IS-IT--Management
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.