• Can't get accounts to populate properly

    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…
  • Function GetDataValue can only service SQL calls that result in a single return value' preventing deletion of report.

    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
  • Error? Excel cannot open the file "xx" because the file format or file extension is not valid

    I need help with this error message. This particular file worked fine on Friday. Now, on Monday, it won't open. My other files seem to work just fine. I get this error: Excel cannot open the file "file name" because the file format or file extension…
  • SO_SalesHistory mismatch

    Hello, I'm running a simple cross-tab report in crystal reports out of the SO_SalesHistory table. The objective is to simply get sales by item, by month. For some reason there seems to be a mismatch between the SO_SalesHIstory table, and the history…