Sage 100

i have created a VI Job that I am trying to use to reverse a large amount of checks. Each check has one invoice. I do not want to recall original invoices but create a distribution amount to a GL acct. When the job is ran it automatically recalls the…

I have a VI job that is using odbc to connect to my database. is it possible to execute this VI job using sData?

I need to know if there is a script or perform logic that can help my situation. - I have a VI Import Job importing Invoices from Sales Orders - The source file does NOT contain the Misc or Charge items from the SO Can this be done without the…

I used visual integrator on a test company to try to renumber an AP vendor. I used AP Vendor Master table, downloaded a copy, changed one vendor to test, and uploaded. This worked to create another vendor with the new number, however, the original vendor…

When we import by Visual Integrator to update certain records it adding on another line instead of updating. Needed to update price_columns on AR_PriceLevelByCustomerPriceCode, where expected it will update the 'pricelevel' by looking the combination…

Hello, First, I have tried and used the "Restrict Accounting date to current and one future Period," and this is not what I am looking for. I am looking for a way to restrict the dates that a user may enter for invoices and other data entry to the…

The only option I have on the VI import to BR_Transaction EntryNo field is Incr Assign. It tells me Next is invalid for this column name. I'm attaching a pic of my VI import. I'm in Sage 100c 2018 Premium. What's happening is our imports are copying over…

I have a Task Scheduler job set up to run daily to run Visual Integrator jobs to export files. This works just fine. However, the Task Scheduler defaults to print the log to Microsoft Print to PDF. Every day when this task runs, a window pops up to save…

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?

This idea for the Paperless Office/Visual Integrator module was posted over a year ago and could use some votes. You don’t really realize you need this, until you really need it. Currently, the Paperless Office log files cannot be accessed through…