x Want to participate? Join the group to interact

  • Sage Intelligence Connector - Adding a duplicate or alias table

    Sage 2019 I created a Data Container. I added a table and would like to add an alias of the same table with a left join. When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed…

  • sql server new connection

    How do I add a new connection to a sql server in the same network as Sage 100 cloud?

  • Can you combine data from multiple companies using formulas like GLActual?

    Is there a way to combine data from multiple companies using formulas like GLActual ? Currently, I have 4 companies, and I have the individual account data being sorted on a second excel page to combine their data in Total column. I've tried using a formula…

  • Previous Month - Rolling, to be used for automated report delivery

    Currently using Sage 100 2013 and Sage Intelligence 5.0. We have a need to pull previous month transactions from AR_InvoiceHistoryHeader. Would like to filter this data based on the ShipDate. We would also like these report so be distributed automatically…

  • question about which modules I need for financial reporting

    We currently have MAS200 4.4 and are upgrading to Sage 100 2014/15. We are retiring FRx. I am setting up a test environment for Sage 100 and it's almost all set up. My question is with reporting. The new software comes with a license for Sage Intelligence…

*Community Hub is the new name for Sage City