Browse By Tags

  • 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…
  • VI AR Cash Receipt Import Sample

    I'm running into issues with creating an AR Cash Receipt Import using VI in version 5.1/2014. Does anyone happen to have a sample AR Cash Receipt VI job that they would be willing to share? Any help would be greatly appreciated. Thank you.
  • What's the latest build of SQL Server that you're safely using with Sage 100 Premium?

    Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…
  • How to change file type in EXPORT JOB MAINTENANCE,

    How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type. Tried checking / unchecking ASCII
  • Key File Rebuild and Optimize removes all records.

    Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered. Is this normal? I can import…
  • Error Message During Delete Process

    Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…