Sage 100

We are in the process of trying to merge 2 separate product catalogs. I suggested starting off fresh and either staring with all new inventory items or just starting the "company" over. Deleting items that have a history creates a problem. We are planning…

We just upgraded to Sage 100. Can anyone clarify if we can upload new employees, via excel spreadsheet, into the system? If so, how? Thanks Lisa

I would like to pull data which shows me all of the production entries made daily. Where can I find the data tables?

I can pull in the L. Tax Amount criteria, but when I try to import, it gives me an error: "This field cannot be set because the level 3 credit card criteria have not been met.". When I enter orders manually, I can lick on the "Tax Detail" link and enter…

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…

I am trying to do a job import where I am assigning Primary Vendors, but am getting an error on most of my files that says "missing vendor # in AP Vendor Masterfile" I am just starting to learn the program and am still very unfamiliar with the way some…

We are moving from Paya (the Sage credit card processor) to another vendor. Our new processor has asked us to request a .CSV file from Paya of our credit card "vault". Paya (who stores the "vault" information) does not seem to want give us this data.…

I am new to Sage 100. I've previously used Sage 50. Using Sage 50, I was able to import our credit card charges into one AP entry. When using the Visual Integrator in Sage 100, which table would I use? There are many for AP and I'm not sure which one…

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 know how to import journal entries, but now want to import journal entries for Payroll, which require use of our multi-company feature. How can I import a journal entry that contains more than one company?

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 trying to modify my BOM's using the Visual Integrator, however I am having a hard time mapping the fields correctly so the upload does not error out. Is there some sort of guide that would show me what the fields in the BOM are labeled as in VI?…

Trying to export file to csv but this error occurs. Knowledge base just says to check a box that says no printer? I don't find any box that says no printer. This is in Sage 100 2013 version. thank you

Is there a way in Visual Integrator, when importing from excel, to do conditional formatting on a particular field on the excel file, not a MAS table? For example, I am importing sales orders and I want particular items on that sales order to be priced…

We are in the process of a business transaction which will result in us having a new company name. Accounting needs a clean starting balance sheet for this "new" company, meaning none of our sales will show, at least in respect to the GL, under the new…

First, I'm an IT guy, but have little Sage 100 knowledge. We have created a new company in Sage. I need to move some inventory records from the old company to the new company. I have two CSV files. The first contains inventory records of items that…

Hello, Does anybody know how to upload journal entries from Excel into Sage 100?

I'm using Sage 100 Advanced ERP 2014 (Version 5.10.6.0) and have successfully created a VI Import for AP. I am able to upload the detailed invoices without problems. The limitation (limitation = my current understanding) being that I can import only…

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…