Sage 100

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…

I am writing out a program and I keep getting this error on my sql statement Error: Expected lexical element not found: <identifier> (State:37000, Native Code: 3F7) Here below is my sql statement. I am nesting a select statement. SELECT ItemCode…

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…

I have one inventory item that the On Hand Qty showing in Item Maintenance is different than the TotalQuantityOnHand when I query it from CI_Item. How does that happen?

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…

Is anyone out there using another vendor to run a dashboard over the sage database? We have a client that used the top google search to recommend a dashboard program called iDashboards for them to provide data to execs in a user friendly format. Needless…

I am having an issue where New/Open order pick sheets, are not printing when running large pick sheet batches. We have a small, pull pack and ship operation and can print anywhere from 50 to 250+ pick sheets a day and ship them out same day. When we do…

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…

Hi there - We manufacture hundreds of different but very similar products for distribution. Our issue is that 3 of our largest customers require we use their item codes which have a completely different nomenclature than our own. When we receive a purchase…

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…

SSRS MS SQL ODBC connection to SFAServ I am looking for instructions on how to query data from MS SQL Studio and SSRS. If needed, how to I install requried ODBC drivers and where do I acquire them? We own the Sage Fixed Assets - Reporting Product, does…

We are dropping our payroll in MAS and looking at switching to another software, so we are looking at dropping our support. Can we drop our support and what effect will it have on the rest of the system while we convert to a new software?

I need to add some things I forgot...

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…

Sage 100 Advanced 2015 Windows server 2012 r2 I followed the instructions in the Sage100ERP_Install.pdf doc but I seem to have missed something. When I enable c/s odbc for myself I get odbc errors accessing the data: ODBC Error 5: "[ProvideX][ODBC…

I haven't tried this with a brand new RMA, but I think this would also have issues working. When I go into an RMA and try to pick which lots are being returned, upon selecting the lot number, I get: Error 47 in program RAWDAI at line 1945. I know…

Is there a utility that I can use to push the quantity of an item from the cost detail into quantity of that lot / serial in the quantities tab?