Smartlist problems.

[vegasfoster]

New user, using version 8.00g44.

1) How do you get the the "Account Summary" smartlist to show all accounts that have period balances regardless if there was activity during the period. I would like to be able to quickly create a complete trial balance by specified period, but it currently only shows the last period an account had activity. If I filter by period 6, it will exclude all accounts that had activity in period 5 or before.

2) When I try to create an export solution, it indicates "document not found". I assume it is refering to file I created for the export, but I am not sure why.

Any help would be great. Thanks.

 

[JAFO22000]

1)See if this works: Open up the default account summary report and click on the columns button. Click the add button in the window that appears next. Now, click where it says "available columns" (the field below the "Find Next" field) and choose the "All Columns" options from the drop down menu that appears. This will open up all columns you have available to choose from. You should find a "period balance" field to add to your report, just highlight it and click OK and it will be added to your report. Also, remember that when you change a report like this, you will need to "save" it by clicking on the "favorites" button in the toolbar.

Sorry, but I can't answer your second question as I have no experience using Export Solutions....

Hope that helps.

 

[vegasfoster]

I appreciate your response, but I guess my question wasn't very clear. I already have the period balances column selected. My problem is that it only shows accounts that had activity during the period. For example, if account 1203 had activity during periods 1, 3, and 4, then it won't show the period balance for period 2, even though there is a balance at the end of period 2. I want it to show the period balances for all 12 periods regardless if there was activity or not. In that way I could quickly generate a trial balance for any period and dump it into Excel. As is, I only get part of a trial balance because numerous accounts with balances but no activity are excluded. If that clarifies my problem, I would appreciate anyone's help, thanks.

 

[jazgeek]

it doesn't seem to be possible, however you could make a crystal report to do the same thing and force it to put zero's for non active periods.



-----------
and they wonder why they call it Great Pains!

jaz

 

[vegasfoster]

Yeah, Crystal is next on my list. Thanks.