Sage Intelligence Reporting

SIRWA Inventory Stock on Hand (Pastel Partner) & Dynamic Name Ranges

Agenda:

• 20-30 Minutes sharing

• 10-20 Minutes Q & A

• 10 Minutes Follow up on queries

SIRWA Meeting – Sage Intelligence

SIRWA Meeting – Sage Intelligence

Getting to Know You & and Pastel Partner Stock On Hand by Date

What you sharing

• What ERP do you mostly write reports for?

• What Project Management Tool do you find most useful?

• Have you find the new Financial Designer useful?

A cooperative group of like-minded companies and individuals qualified and motivated to service the Sage Intelligence market.

SIRWA Meeting – Sage Intelligence

Tell Us…

What you sharing

• Looking at how to calculate Stock on Hand by Date

• Looking at the new use of Dynamic Name Ranges in Data Validation

http://www.vertex42.com/ExcelArticles/dynamic-named-ranges.htmlIt’s the very last formula: OFFSET($A$1,0,0,SUMPRODUCT(MAX(($A:$A<>"")*(ROW($A:$A)))),1)