Sage 100

Hello All. I am somewhat familiar with VI and have used it for imports and exports. However, I have something I can not figure out. Perhaps not possible. I have a need to dump the entire contents of the IM_AliasItem file to CSV. Not a big deal. However…

I apologize if this is the wrong place and/or if this has been asked before. I have searched and having found it. I'm looking to change the default delimiter for Visual Integrator from comma to semicolon as we have lots of uses for commas in descriptions…

Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…

On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…

Using Visual Integrator, how can i prevent the importing of a Sales Orrder, and make it update an old sales order instead, if the PO number of the currently importing Sales Order is the same as the PO number of an old sales order?

Can i import a Sales Order through Visual Integrator by description rather than alias or item number? How would this be done?

Let's say I have a cell that looks like this (with carriage returns): email: [email protected] destination: Ft Lauderdale on July 4 2020 ************ other stuff Is there a way within Sage 100 to extract just the value "Ft Lauderdale on July 4 2020"?

here is the line i'm testing my import on: 1,00,ROYAL,66ITM67161,1,, col 1: H.SalesOrderNo 'Next' col 2: H.ARDivisionNo col 3: H. CustoemrNo When I attempt to import, I'm getting this error: However, when I manually enter a sales order,…

I am work with VI to import AP invoices. One of the required Fields is the GL Account Key. I am looking for a way to look up the GL Account Key to be entered into the record for importing AP Invoices into Sage 100?

Hello all, Need some help. Hoping someone else has seen this before. Trying to use a VI import on a table I haven't imported into before. Asked if my Job_Name was a new VI job. Hit Yes and... POOF. Pop up error. Unable to instantiate BO_BillOfLadingMargin_bus…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…

I exported the AR_OpenInvoice file to Crystal to extract very old invoices and save to a .csv file. I built a simple VI_Import to create CMs to write off the invoices. The import job validates on test but then fails when run with HS Record Invalid or…

I have a strange problem, but it has been years since I have had to do this so maybe i missed a step or something. I imported the codes to the tax code and tax code detail and tax schedule and tax schedule detail. A line that is TX will register as non…

Is is possible to do something in a Visual Integrator export similar to SQL LEFT(CustomerPONo,22) ? I want to truncate the field to 22 characters in my export file. I'm looking at CustomerPONo in ARInvoiceHistoryHeader

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

Receiving an error while trying to import new BOM into sage. The message is, "S Only bills may be entered". In my VI job, I am assigned a H.Billtype = S. I am not reading from file for that column:

Is it possible to subtract days from the current date? I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time. I've tried things against the TransactionDate…

I'm running into issues with creating an AR Cash Receipt Import using VI in version 5.1/2014. Does anyone happen to have a sample AR Cash Receipt VI job that they would be willing to share? Any help would be greatly appreciated. Thank you.

We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…

I will need to run a series of visual integrator jobs from the command from a batch file. The jobs will import daily data into many individual companies It appears that jobs run from the command line do not write to the job logs. I am wondering if anyone…

Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…

We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

I have a national retailer who is sending over Ship Via codes that are not standard SCAC codes for .com orders ONLY. For example, "2" could be Fedex Ground. Currently, I'm bring in orders via an excel download from their portal and using a VI job to import…