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.

List of Excel Sage Intelligence Functions

Posted By paula2013 over 5 years ago

Hi All,

Could you direct me to a source where I can see all the Excel functions for creating financials?

Functions such as GLClosingBalance etc.

Thank you,

Paula Park

Parents

0 Sandra Smith over 5 years ago

Hi Paula,

I don't think we give any cheat sheet away of the development behind the formulas. The Layout Generator and Task Pane formulas are the same just using two different methods for 'presenting' them to Excel. The Layout Generator enables to click on a formula which places it into the column or row heading. The Task Pane enables dragging the formula to the cell then hooking up the elements of the formula using the Function Argument Window or just within the Formula Bar.

Let me know if I'm still missing what you need.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sandra Smith over 5 years ago

Hi Paula,

I don't think we give any cheat sheet away of the development behind the formulas. The Layout Generator and Task Pane formulas are the same just using two different methods for 'presenting' them to Excel. The Layout Generator enables to click on a formula which places it into the column or row heading. The Task Pane enables dragging the formula to the cell then hooking up the elements of the formula using the Function Argument Window or just within the Formula Bar.

Let me know if I'm still missing what you need.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 100

List of Excel Sage Intelligence Functions

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING