Transcription
Axys Tips and TricksAdvent Users GroupAtlanta, May 2006Diane HerreraClient Server Specialists, Inc.dherrera@cssi.org
About CSSI Founded in 1995 Focused on Financial Services Industry since1997– Portfolio Management Systems Advent, etcCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
About CSSICSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
What we do Workflow analysis and recommendations Interfaces, Interface cleanup Automation– Scripting– Scheduling Conversions Getting data into/out of AxysCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
About CSSI Custom reporting See free reports on www.cssi.org Report packages Training See free white papers on www.cssi.org Training classes Data entry/recon Maternity leave Other UtilitiesCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Account Translation Utility Allows you to split a single custodianaccount into several different cli files Helps with unsupervised assets Helps separate equity and fixed income Tax lot vs average cost Asset Class Security Type Specific securityCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Client Builder helps manage clients and groups Define labels as requiredDefine labels as dropdowns with allowed choicesCheck for empty groupsEasily see what groups a cli/grp is inEasily see what cli/grp a group containsFull Audit Trail– Who changed a value, when– What it was before they changed it, what it is afterCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Dropdown example Define fieldsasdropdowns DefineallowablevaluesCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Required Labels Definecertain fieldsas requiredCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Add Notes Room forspecialinformationnot stored incustomlabelsCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Tracking a Portfolio’s Location The Contained Intab lists all groupsthat contain thiscli file Can add/remove acli from group(s)from this tabCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Client Builder Explorer View The Portfolio tabshows all groupscontaining thiscli Shows notesassociated withthe cli Can maintainfrom this viewCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Client Builder Explorer View The Groups tab liststhe members of theselected group Also lists whichgroups contain thisgroup Can maintain fromthis viewCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
QuickBooks Utility Management Fee Utility –– Feeds management fees into Quickbooks» creates receivables– Creates a file for Upload to custodian– Reconciliation utilitiesCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
The Free StuffCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Today’s presentation Customizing the Reconciliation Report Take notes Presentation will be available for download– Location– Instructions– Special password Reminder to Diane: clear custom labels before startingCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
About the Reconciliation ReportCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Useful Custom Labels Market Value Tolerance, #recprecQuantity Tolerance, #qprecTolerance for specific security type, #fhusqprTolerance can be value or percentageCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Example Quantity Tolerance, #qprec 1000CSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Label rectrnCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Middle radio button – @unrecon grp– Unrecon.trnCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Unrecon.trn and Unrecon.grpCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Unrecon.trn and Unrecon.grpCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Customized Reconciliation Report If reconciled, will write to regular trade blotter– recncld y– %reconto If not reconciled, will write to regular trade blotter– recncld n Will display account number, acctnum Will display last reconciled date, %reconto Reminder to Diane: post custom labels before startingCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Time For Some Programming Warning Proceed at your own risk Unless you’ve had some training, stick to theexact changes outlined/documented Easier to download the free report fromwww.cssi.org Advent will not support your modificationsCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Make a copy Determine .repfile name Use WindowsExplorer tonavigate to your\rep folder Make a copy sipos30.repCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Open in Text Editor PFE– ProgrammersFile Editor Do not useWord Careful withNotepadCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Display Account NumberBeforeCSSIClient Server Specialists, Inc.www.cssi.orgAfterTel: (610) 992-9287Fax: (610) 992-9289
TestSo Far So GoodCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Now add last reconciled dateTwochangesCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
TestWhew!One moreto go CSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Trade Blotter #1AfterBeforeCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Trade Blotter #2AfterBeforeCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Trade Blotter #3CSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
TestTa Da!CSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
If you want to learn more AUG NewsletterFree White papers on www.cssi.orgUsing DataportConnection WebsiteCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
If we have time CSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Composite Group ListingCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Composite ValidationCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Creating Groups of Composites File Æ NewÆ Grp Navigate tocpg folder Filter *.cpgCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Add All Important toAdd All Otherwise,won’t work Then clickOK to SaveCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Open the grp Remove theones youdon’t wantCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Edit Æ Replace Replacepath namewith & ReplaceAllCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
All Done Save andCloseCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
To Get This PresentationCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Use Conference Code dogwoodCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Download PresentationCSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Q&ACSSIClient Server Specialists, Inc.www.cssi.orgTel: (610) 992-9287Fax: (610) 992-9289
Axys Tips and Tricks. CSSI Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289 About CSSI . - Feeds management fees into Quickbooks » creates receivables - Creates a file for Upload to custodian - Reconciliation utilities. CSSI Client Server Specialists, Inc. www.cssi.org