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.
Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…
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…
We imported manual check entry payments via the Visual Integrator module. Accidentally uploaded twice, and now have duplicate payments posted. They're exactly the same, down to the same check number. Can I delete the duplicate? Or will I have to void…
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…
Hi all,
I hope everybody is doing well. I apologize in advance if I post this in the wrong section.
I recently discovered the Visual Integrator module for Sage 100 and have been trying to learn how to create a job that imports an Excel spreadsheet…
Hello,
I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…
We have several people importing AP invoices and we have had a few instances that invoice was imported a second time. Does anyone know of a way to get these to flag for duplication?
Brenda
Hello
I am using VI to import invoices into invoce date entry. The import works fine-but when I hit print in order to post, it prints and then runs into an error. The error logs only lists the invoice numbers as the error. I dont know what the system…
I've got a Visual Integrator export job that I'd like to to be able to Select by the DateUpdated field in the CI_Item table. According to the CI_Item column list in File Layouts and Program Information, it should be field 85, but the list of selectable…
i have created a VI Job that I am trying to use to reverse a large amount of checks. Each check has one invoice. I do not want to recall original invoices but create a distribution amount to a GL acct.
When the job is ran it automatically recalls the…
The Visual Integrator "Job Log Report" is cutting off the information on the errors that occur. For example, a recent report looked like this:
You can see that the error description is being cut off and so I can't see which batch or invoice I need…
For context, I tried searching these forums for at least an hour to find an answer on this, but the only active discussions that popped up were 8+ years old. Either I was using the wrong search terms, or this is an uncommon issue. Apologies in advance…
I used visual integrator on a test company to try to renumber an AP vendor. I used AP Vendor Master table, downloaded a copy, changed one vendor to test, and uploaded. This worked to create another vendor with the new number, however, the original vendor…
I'm attempting to import an invoice using VI import and encountering a "HS Record Invalid or Write Failed. The Vendor Number is Required" condition. I've confirmed that the Vendor record exists but it continues to fail on the import.
This error also…
I found invoices in AP_InvoiceHeader that move to AP_InvoiceHistoryHeader table after the invoice posted, but I cannot find any documentation on where to find payments.
I created a Visual Integrator job that imports our credit card transactions as…
I'm asking this question as a correlation to this other post (titled: "Is there a way to change employee numbers in a VI job based on SSN?"). We're running into an issue where Sage no longer deletes employees marked as "Terminated" during year end processing…
We have a significant number of seasonal employees that we have each year. It used to be that Sage would delete terminated employees during the year end process, but that is no longer the case because of this . We're getting ready to import the seasonal…
I know this was possible before.
Sage 2016
We have a scheduled job that reads multiple files and import the Invoices and it works fine.
Sometimes there is an Invoice with an Invalid Account number ect., so I would like to copy the VI Log after each…