I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to…
Hello Sage 100 Community,
I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout:
Account No.
Debit
Credit
Posting Comment
Journal Comment
6570-00
500.00
0.00
Test comment…
I am receiving an error message when clicking on any template in the task scheduler. Here is what happened.
How it happened:
Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script).
It has been…
I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message:
"VI JOB_NAME Unable to open [wdx][odb]<dsn_name>"
I don't get this message…
How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error.
For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…
Have the following source file (CSV)
2 questions:
1 - I want to import the Invoice No and append "-CM". Is this possible?
2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…
I have a CSV file with new employee pay rates for a couple hundred hourly employees. Is it possible/advisable to import the new rates with a visual integrator job, and have the change appear on the "Pay Rate Change Report".
Thanks!
I am working on importing into Work Ticket Header in Sage 100 version 2020 Premium working with Production Management. I am trying to create the same action that occurs in the user interface of Work Ticket Entry in Production Management. In the UI of…
Need to import a Timeslips 2007 database into newly installed Timeslips 2020. Do not need much of the old data, but do need last several years of data. Is there a way to export the 2007 data and edit it before importing it to 2020?
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…
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…
The original statement we have is as follows - Temp001$=“458”
I want to include "459". How should the formula look?
Temp001$=“458, 459"
or
Temp001$=“458” or Temp001$=“459”
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 import journal entries (JE) into the General Ledger module, some of which affect cash accounts. However, they do not depict on the Cash Account Register in the Cash Management module. I have to manually re-enter the JEs via the "Enter Bank Transaction…
I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016.
The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…
Hi All,
I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…
Is it possible to use the SDK to import employee pay into Sage? I'm thinking it would need to be able to create paychecks but if anyone knows of a better way for employee pay please let me know. I know you can import employees but I want to take all their…
Hi,
I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…
I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.
We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read.
What causes this to happen?
From looking at the summary…
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…
I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…
We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them.
I've built a VI job that seems…
Est-ce qu'il est possible d'exporter les informations de l'onglet Débit pré-autorisé de SAGE 50 vers EFT 2015?
La connexion avec la compagnie se fait correctement pour les clients; fournisseurs et employés. SAUF que l'information du compte bancaire…
