Sage 100

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…

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…

Hi Everyone When I try using the VI for Manual check imports I get an error. All the error is showing is the invoice numbers. IT seems that it is not being recognized as a new invoice., I do not see any option of putting in a NEW Invoice code from…

We are in the beginnings of trying to get positive pay setup. I have our bank specifications for the positive pay file. I am learning that this file can be setup to be produced by Sage under the Bank Reconciliation module. We do not use the bank reconciliation…

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…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

Does anyone have experience with using the SAS Concur Expense Solutions and importing the data extract via VI to the accounts payable module? or can you tell me which VI table is used for import of invoice data to A/P? Thanks!

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…

Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

We have been doing vendor imports for all of our patient refunds and I just noticed a problem. Since we want the check to be made out to "John Brown" that is the column that is imported. However, although the checks come out correctly, the Vendor Name…

Hello I am wondering if there is a quick way to set a large number of vendors as inactive based on last purchase date...or is something I need technical support for? thank you ~Betsy

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…