Financial Reporter

[skier1284]

Hello,
how can I display the transaction history for a specific account line by line in financial reporter?

Is it possible to do this for all periods in a year as well as year to date?

Thanks,

Adam

 

[ettienne]

Yes, depending on the version.
Look at FRTRNA.

 

[dgillz]

Slightly off topic:

Is this product an ACCPAC only product, or is it available for multiple ERP packages?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[skier1284]

Thanks for the reply,

I know there is the drilldown feature with FRTRNA, but can I actually display those transactions on the report?

For example, the net balance of an account = 1000
there are tranasactions during the period of:
debit 5000
debit 7000
credit 11000
These will show up with the drilldown, but can i get them to show up in excel with FR or is it only possible to show the balance of an account?

If it is possible how can I do it?

Thanks Again,

Adam

 

[ettienne]

No it is not possible.
Why would you want that in a financial report?
Financial reports are based on summarized data (balances, net movement, etc), if you want transaction details then print a GL transaction listing report.

 

[ettienne]

dgillz,

The Financial Reporter (or FR) is a Sage Accpac ERP only reporter, it cannot be used with any other ERP system.

 

[skier1284]

Thank you again for the help,

I wanted to be able to calculate an AVG daily balance YTD for the category. the tranasactions occur each day and the dates are only listed at that level.

Thank you again though,

Adam

 

[ettienne]

Use Crystal reports and take the transactions from GLPOST.

 

[TheSQL]

Use Crystal reports and take the transactions from GLPOST.

And hope you have MSSQL or very few transactions if you're on Pervasive. ;-)

If you're on MSSQL Server, you could make a really snappy report using a SQL view - no client side grouping or filtering - by having the view aggregate transactions by transaction date.

ACCPAC's data schema doesn't tend to lend itself to reporting by day, hence the need for extensive Crystal and/or Insight trickery.