Actinic Payments Reports...again!

[Darren B]

Thanks for that, aslong as its passed the "we are thinking about it stage" i can live with that

D

[pinkequine]

A Useful way to easily reconcile your Bank Entries

hi,

Just thought I'd share a way I have found of tying up individual bank entries to the daily transactions - it works a dream.

Steps

1. Backup your Actinic File (just in case)
2. Open up the ActinicCatalogue.dbf File
3. Open up the sheet - PaymentHistory
4. Copy the whole Page
5. Paste it into Excel
6. Create Filters
7. Freeze Panes to keep the titles at the top
8. Filter the database on column L which should be 'OCCProviderRef' to show everything except blank entries
9. Sort the data on column J which should be 'DateTimeActioned'

Takes a couple of mins to do, and hey presto you have a daily list of all transactions that have been processed and can very easily match it up to daily records.

Also - I have found a couple of entries I never committed 'oops' but - same as everyone else - I can't get into the Actinic Reporting online to check it out further ***sigh*** (ahh well at least I can do my bank recs.)


Hope this helps

Denise