• Pull posted AR invoices to a table when 5 companies are setup.

    I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company? Any recomended procedure to pull this data to the table? Thanks for all responses!
  • Need to pull invoices from AR tables.

    Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies. Thanks
  • Query to pull data that represents the Inventory Trial Balance from the Inventory Module

    Hello, What would be the correct query to use (what tables, etc) to pull the exact same data as you get from the Trial Balance from the Inventory module while showing every item with its value? I want to do this at month end. Basically I want a big…
  • Tables used for A/R module in Sage Advanced ERP 2015

    Hi, I've tried to search for data dictionary of all tables in Sage Advanced ERP 2015, but not successful. Please help! Thank you so much Edward
  • Copying to a New Company

    My company was acquired by a new company. I copied all the modules over and would like to retain history in them with the exception of General Ledger. Is it possible to delete entries/history in a date range?
  • SOTAMAS90 changes

    Something is changing the Database Directory for my SOTAMAS90 ODBC DSN from "\\MAS-Server\Sage\Sage100AdvancedERP2015\MAS90" to "C:\Sage\Sage100AdvancedERP2015\MAS90" I can't figure out what is doing it but it is really starting to annoy me. Any ideas…
  • Database fields

    Are sensitive fields in Sage 100 encrypted?
  • Crystal Reports Cross-Tab Data Population

    I am creating a cross-tab report in crystal reports based on AR_InvoiceHistoryHeader and Detail. I am trying to summarize the number of shipped units per month for a particular year. I have this working fine, except that if there is no data for a given…
  • Payroll last name field length?

    Just hired employee with a last name greater than 15 characters. We are on version 4.5 and it appears the field length is set to 15 characters. Has anyone had this issue? If so, could you share your resolution.