Sage 100

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…

I have a client that has recently been purchased by a larger entity. The new company would like to change the fiscal year and purge all historical detail from before the acquisition. Their preference is to start a totally new company that only has detail…

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…

I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel…

Hello everyone, We have been using Sage 100 and it's earlier incarnations for over 20 years. Our data sets are quite large, especially sales and invoice history and inventory. What is the best practice, or what do you all do to maintain your data sets…

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…

We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…