Visual Integrator – getting data in and out of Mas90 and Mas200
If you need to integrate your data with other software packages or data transmissions, the Visual Integrator module is the tool to use. Easy selection of data to export or import is provided, with a variety of features and formats to accomplish different tasks. For example:
Bring vendor price changes into your Inventory item file quickly.
Export your items to excel, calculate new prices, then import new prices into inventory from excel.
Import Vendor Invoices into your AP system, rather than entering them manually.
Items scattered in multiple locations? Enter physical counts into excel, then import into the Mas90/200 Physical Count Entry file.
Validation logic is built into Visual Integrator to assure that the data being imported conforms to Sage MAS 90 and Sage MAS 200 rules.
User-Defined Fields: If you have created user-defined fields in Sage MAS 90 or Sage MAS 200, these fields will appear automatically for selection when Visual Integrator operates on the entity to which they are attached (for example, customers or vendors). You can then export or import your user-defined field data.
Import Fields Conditionally Conditional importing allows a field to be assigned based on the value of another field. For example, the sales tax code can be assigned based on the state field in the customer address.
Put Import or Export Jobs on the menu, so you or anyone can easily run them any time. Jobs can also be passworded for security.
Selection and Skip Record Criteria: Multiple selection criteria for picking certain records can be specified, using standard “nesting logic” criteria, (such as: and, or). Multiple criteria for skipping records can also be defined.
Contact us if you would like assistance in purchasing or using the Visual Integrator module.