Browse By Tags

  • Sage 100: Dropping in Employee Maintenance Data using a CSV or Excel file

    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!

  • General Journal Posting - duplicating

    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…

  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

  • Excel Query for Payroll Information and History

    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…

  • new budget numbers

    Hello, We need to replace old budget numbers with new ones under employee earning distribution - GL segment2. For example, 200 employees are currently using budget number 123456, we want to change it to 67890. What is the best way to do it other than…

  • How to enter search criteria for Blank Fields

    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?

*Community Hub is the new name for Sage City