Search results for query: *

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...

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!

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...

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 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...