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.
Haven't found this posted before, although it may have been and my searching skills are diminished. I also understand that this might be something that I can pull into Access or Excel, or even write a Crystal Report, to accomplish. But for the moment…
Hello all,
SAGE 100 Could Advanced 2020 (V6.20.1.0)
I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…
Hi Everyone,
I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices.
There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice…
I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…
Greetings: I am attempting to export some data with TAB delimited fields. I have my job File Type setup for Delimiter and I have the Use ASCII Delim. box checked and for my delimiter I have attempted to use the ASCII code for horizontal tabs of 9 but…
Hello-
I have created some VI export jobs for exporting text files to export Vendors but I notice it only returns vendors for the company the job is being ran under? Is there a way to run one job and get all vendors for all companies? The best thing…
I am using Visual Integrator to export SalesOrderDetail.M4T out of sage in a csv format. The challenge i am facing is SalesORderDetail table has a column called as "CommentText" which contains a carriage returns in the data.
I want to either get rid…
Hi,
I am trying to export transactions out of sage 100 through a VI with a filter on date updated set it to today. I used different functions such as {DAY}, {DATE}, {TODAY} and DATE$. Unfortunately all my methods failed in using the system date as the…
How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type.
Tried checking / unchecking ASCII
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…
I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file.
As an example, the import file that has been provided includes an account…
Tried to create export with VI for GL Transaction detail and it pulls 0 records. Need it to pull for a whole month. and currently using the GL_TransactionJournalHeader. Want it to pull SourceJournal, EntryNo, PostingDate, JournalComment, and JournalTotal…
