Sage 100

Anyone have any experience with using an excel or csv data base spreadsheet to import employee maintenance info into Sage 100? Looking to save some time for a large client. Name, Address, SSN.. Thanks!

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 a CSV file with new employee pay rates for a couple hundred hourly employees. Is it possible/advisable to import the new rates with a visual integrator job, and have the change appear on the "Pay Rate Change Report". Thanks!

I am converting some payroll export jobs from v2017 to v2019. In v2017, fields such as PR.PER_CHK are shown in VI as type DATE. In v2019, the replacement field PR_PayrollHistoryHeader.CheckDate is of type STRING. My converted job fails to export data…

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…

Hello. We are attempting to get two years of pay history out of Sage 100 as well as other employee information. I have attempted to use an Excel Query, but I really have no idea what I am doing. Where do I go to find an expert that knows how to retrieve…

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…

Is there a fairly simple straightforward way of importing timecard information into payroll data entry without using Visual Integrator? Thanks!

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…

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…