Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I have a Batch file that has been running VI jobs for years. But recently some of it hasn't been working.
The batch file calls 2 separate VI Import jobs, with a timed pause between.
The first VI job runs fine, and loads the data without issue.
The…
Hi Sage 100 Community,
I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…
I'm currently running SAGE 100 version 7.10.5.0.
I can run VI Import jobs no problem via a .bat file or through command line. However I'm looking to get some output back from running the job. Ranging from:
Successful or unsuccessful login (right…
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…
is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…
I have a vi job that is suppose to transfer inventory items from one warehouse to another along with their bin location. Scanco muti-bin is installed. The job is not able to distribute the line tiers of bin location. Has anyone had this issue with VI…
I'm not finding a way to import several Bill Numbers into this report's parameters.
Can you help me? It seems like i should be able to do this, however i'm not finding the right path yet. VI doesn't offer it and i'm having trouble finding clues to help…
New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.
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'll probably rebuild this process as a BOI but.... this is just so perplexing I'd kind of at least like tug the thread and see where it leads.
Environment: Sage 100c 2021 v7.05
I have an ETL process that brings the invoices in from our mobile invoicing…
I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…
When using VI and importing from an Excel file, does the VI import job spin off a *.csv file into ..\mas90\home\textout to use as the source data?
I'm getting this error:
We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI.
We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
Morning,
I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)?
{SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…
Is it possible to change the company code during a VI Chain to event?
We have a process of importing data into the SO tables in one company code and then updating a field in the PO Header of another company code. I'd like to use the VI Chain To field…
I am using visual integrator to produce an export file. The check amount field is dropping of the period and the zeroes when it is an even check amount.
check amount 58.56 will export 58.56
but
check amount 58.80 will export 58.8
and
check amount…
Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
I am looking to import sales orders either into sales order invoice and create an invoice batch or import into sales order shipping data entry. Of course it would be ideal if it would pull the lines in without having to give each line item its own line…
I'm working on an import job to enter cash receipts and don't have the AR_CashReceiptsDetail table in the table list. I see it when I'm in export job maintenance, just not import. What am I missing?
I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience.
I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…
I set up a VI job to set paperless office settings for all of our customers so it would email their A/R Statement to a contact code (rather than the customer email). Now I'm trying to figure out how I can remove that contact code using a similar job …
I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…
I stumbled upon another post that described hard-coding or allowing a user to manually type in a deposit number when chaining two VI-Import jobs together for a Cash Receipts import. We are not wanting to go this route as in our case the deposit number…
I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…
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…