Sage 100

Sage intelligence has stopped refreshing when I change the Period or Year. I have formulas linked to a Year and Period so that changing either cell with the Year or Period changes the data to that time frame. It worked fine in a previous report version…

Hello I have a 2018 Premium install of Sage 100 and I cannot get certain accounts to populate with balances in Sage Intelligence. The balance says zero but there is a balance in there for the period and year selected. It's selective. Some accounts do…

I want to delete a report - get an error 'The function GetDataValue can only service SQL calls that result in a single return value' how can I fix this? We are on Sage 2020, not on a SQL server backend

I am creating a GL Detail report (GL_DETAILPOSTING) and need to have the fiscal year and fiscal period columns added to the report. What table do I use to join?

why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order? Excel Output Connector Module Sample Run Original Excel FIle Import

The SO_SalesOrderDetail has just about every field I need except the customer number. What other table can I use to link them and report this field in Sage Intelligence 100? I am using Microsoft Query.

I have a client that is basically holding company, several companies, each with their own Sage server. They are wanting to do consolidated reporting in Sage Intelligence, for all companies. Can this be done? If so, how?