Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

SQL Query for Operating Income?

Posted By RedemptionMatt over 7 years ago

Sage 100 Premium 2014 User -

We are looking at building a dashboard with Tableau and one of the things we'd like to see is operating income at a monthly/weekly/daily level. Has anyone built SQL queries with the Sage database to show Operating Income?

0 BadgerJerry over 7 years ago

Operating Income by Day? Boy, payroll days will be really tough on profitability!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BadgerJerry over 7 years ago in reply to BadgerJerry

You could summarize debits and credits from GL_DetailPosting linked to GL_Account.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

SQL Query for Operating Income?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING