Smartlist - preparing an aged historical trial balances for payables

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am trying to prepare a smartlist report listing all open invoices as of a specific date in excel. I can run the "canned" report (historical aged trial balance) but it does not convert to Excel in a readily usable format. The report does not need to be aged. My auditors requested such a report so that they can do testing during the audit. I have GP 2013.

Thanks

Categories:

Other

All responses (2)

Answers (0)

ShawnMD 1,456 User Group Leader on at

Like (0)

Report

RE: Smartlist - preparing an aged historical trial balances for payables

The HATB SSRS report should work great for this - Do you have them deployed?
Suggested answer

Lyn Barr on at

Like (0)

Report

RE: Smartlist - preparing an aged historical trial balances for payables

Perhaps the most efficient option is to actually modify your "canned" report so that it is in a more Excel-friendly format. This can be easier to accomplish than trying to create a SmartList, for this particular need.

Make sure you back up your reports dictionary (REPORTS.dic) first!

If you are not familiar with using Report Writer to modify reports, you may want to contact your GP consultant for assistance.