Thank you for everyone who came to the User Group meeting last week!
Here is the Chrisy’s presentation about analyzing journal entries in ACL. If there are any meeting topics that you would be interested in hearing about in the future, please feel free to contact us and share your ideas.
Using ACL for Journal Entry Analysis
Thanks for everyone who came to the User Group meeting today!
As promised, here is the link to the 2014 ACL Connections Presentations.
2014 ACL Connections Presentations
If you are interested in a a specific one, they are also here individually.
Thanks for everyone who came to the User Group meeting yesterday! We had a great turnout and it appeared everyone had fun!
Jan briefly mentioned that the next meeting has been rescheduled to June 18th. There will be an invitation sent out around that time as well.
As promised, here is Kim’s presentation about ACL v10 changes as well as the Excel export script she was demonstrating. This can be used with the ACL sample files that come with ACL. The project is “ACL Demo”.
ACL v10 Changes
Writing to multiple tabs script:
SET SAFETY OFF
DELETE Workbook_Example2.xlsx OK
EXPORT FIELDS CARDNUM CREDLIM CUSTNO EXPDT c_cMonth c_cCMOY FINCHG MINPYMTDUE NEWBAL PASTDUEAMT PMTDUEDT PREVBAL RATE STMTDT XLSX TO "Workbook_Example2" WORKSHEET Metaphor_Trans_All
EXPORT FIELDS Dept DeptDesc XLSX TO "Workbook_Example2.xlsx" WORKSHEET Metaphor_Dept
SET SAFETY ON
Hopefully everyone is taking advantage of this unseasonably cool St. Louis summer! A special thank you to Matt Adams of the Cardinals for the extra innings game winner last night. This morning’s coffee tastes a little better because of it.
As promised, here are the links to the ACL Connections 2013 presentations Jan briefly discussed at the beginning of our meeting:
ACL Connections Recap
ACL Connections 2013 – Resources
Joe has also been kind enough to provide her presentation on scripting data integrity verification:
Scripting Data Integrity Verification
Thanks again and we’ll see you at the next meeting!