Sage 100

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…

Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

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…

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

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…

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'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'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…