Search results for query: *

Will do BigLouie...Thanks!

Hi all. We currently have version 4.05 of MAS200. There is a field that is in the IMB_PriceCode table that we would like to bring into the sales order lines and therefore the invoices. The field is: Description, we are currently using this field to store a contract number for a specific...

Oh I didn't know that, that's not good.... Thanks for the help!

Hi all. We have MAS v4.05, and we have several items that have customer override pricing. In other words, in relation to a VI job: PRICE_CODE_REC = 2 CUST_METHOD = O We know how to add pricing but we don't know how to delete pricing using VI. Any help would be great!

By the way, this works when I use the source as table via an ODBC connection. I simply have 2 fields: sales order number and address 3. Will this corrupt my data in any way instead of using a CSV file?

Hi all. I want to import a value for Ship_To_Address3 in the SO_03SOHistoryHeader table in MAS via a visual integrator job. I have the sales order number and the value I want to add in Address line 3. I took away all the information from the Validation tab because it kept failing for the...

I had the command line incorrect, fixed it: ..\VI\Update_Flag.exe Now I get the following error: Error 17 in program at line 65000

I placed the .exe in the VI folder on the server and then went to Import Job Maintenance, selected the import job and then clicked the Perform button. In the Command box I typed: ..VI\Update_Flag.exe For Perform On: Job Start (to make sure it works after that I will change it to Success)...

Thanks for the reply BigLouie, does that mean that the VI job has to be run from the server?

Hi all. We have MAS 200 version 4.05. We have a VI job that imports some pricing and I want to be able to run a batch file once the VI job is successful. When the batch file is run it updates a field in a table via a SQL 2000 DTS. I've been trying to do this with the Perform button in the...

Hi Blorf, Yes I can do that, but what if the VI job fails to import, the flag will be updated to 1 but the data was not imported into MAS, and will never be updated because it skips those that have the flag = 1. I just want to update the SQL flags after the VI job completes successfully.

Thanks for the reply Dawn! But I'm new to MAS and VI for that matter, can my VBScript that will update the status flag of my SQL table update only the records that I imported in the VI job? Where would I store those records, could I store the records' primary ID in a temp variable in the VI job?

Hi all. We have a VI job that imports customer specific pricing for items (MAS v4.05), the data source is an ODBC Connection, the table is on SQL Server 2000. There is a Status flag, 0 = import to MAS, 1 = do not import to MAS. How can I update that status flag after the import is completed...