Does anyone have a template that I can run in report writer that will show me the detailed transactions that was posted to an account. Like what you would see if you use the drilldown function?
My accpac is not currently working correctly and I cannot run the transaction listing report in the program (Our IT department will only fix it next week, we do not have rights) and I need the information urgently.
Hi Ea du PLessis I could be wrong (someone please correct me if so) but I don't think in FR you can generate transaction detail level data into the Excel report, only drill back into it using the Sage screens. FR is designed for creating reports based on account level balances and net changes for each period/quarter/year not for displaying individually posted transactions (I did a quick test and could only get the transaction detail through drill-down).
Your only option might be to make a SQL connection from Excel to tables GLJEH (journal headers) and GLJED (journal details) for your Sage 300 database to get what you need. If you don't have SQL user credentials or windows permissions to the database tables then you may not be able to do this either.
It could be that you're stuck until IT provide access. Good luck!...Tim
