• How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…
  • Visual Integrator Missing Fields

    I've got a Visual Integrator export job that I'd like to to be able to Select by the DateUpdated field in the CI_Item table. According to the CI_Item column list in File Layouts and Program Information, it should be field 85, but the list of selectable…
  • Visual Integrator Errors importing CI_Item version 4.4

    I'm trying to import CI_Item information into a new Company. The import file was created by exporting it from an existing company. I receive errors on every record for all fields that reference another table. Product Line, Price Code, Primary Vendor…
  • How to enter search criteria for Blank Fields

    Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?