Sage 100

Does anyone know if there is a table/view equivalent to the SY0_CompanyParameters table in Sage 100 4.50 Premium? My reports from 4.50 Standard as that table no longer exists and I can't figure out how to use the SY_Company, if I even can. Any suggestions would be appreciated.

Attach your old report you're trying to convert.

Here's an example.

FWIW - If you are launching the reports from within MAS and the only data elements you are after are the company code and name; create a blank formula named CompanyNameCode and it will auto populate when the report is launched. Other fields that work this way are ModuleDate and PrintedByUser. I am sure there are more but those are the ones I use most often.

Mike - I'm working in Premium, not Advanced.

Greg - that is exactly what I needed. I never thought a blank field like that would work for custom reports, but it works perfectly to display the name AND the 3-digit code for the current company.

Ahh..got it