Sage 100

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

Hi. Okay..... A prepayment was applied to the wromg customer in Sage and has been reconciled since December 2021. I was told to issue a debit memo for the amount that was misapplied. My big question is.... is it possible to apply prepayments to…

Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…

Greetings: I am attempting to export some data with TAB delimited fields. I have my job File Type setup for Delimiter and I have the Use ASCII Delim. box checked and for my delimiter I have attempted to use the ASCII code for horizontal tabs of 9 but…

After talking with Sage I know I am doing best practice with this. In my vi export for invoice history I am combining the taxable amount and the non-taxable amount. I have both fields pointed to the same col/pos "7" in my case but I don't know the syntax…

We recently upgraded from Sage 100 4.4 Advanced (providex) to Sage 100 Premium (SQL). With this move, I lost the ability to export any legacy tables that are not housed on the SQL Framework. I am needing to export the data from SY_Console on a fairly…

I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file. As an example, the import file that has been provided includes an account…