When I run the Consolidated Reporting Line Item Summary it includes closed projects, not desirable. Also, it doesn't include some projects, I believe, because there are too many. I have to manually choose half of the projects to run "part A" and then the other half "part B" for the remaining. This is time consuming. I believe this happens because of the 9999 PENDING TRANSACTIONS LINE ITEM always being Active without the ability to close it. Is there a solution? I have spoken to someone on chat, but it could not be resolved.
What release version of Sage Fixed Assets Planning are you currently using? When we know the release version we can continue with a best approach to make this process work smoother for you.
Have you tried using the select projects from the right side of the report name box? Here you can select the projects that you want to report on and exclude the closed or no longer used projects. Are running the consolidated Line Item Summary report or the consolidated project listing?
If the consolidated Line Item Summary report is the report that you are running there may be an option to create a group based on Type. The field Type is on the line item level and you can put in Type is not P for the group criteria. Then use this group when running this report. That should exclude the pending line item.
As far as the long list of projects I will get back to you on this as it is needed to determine what can be done to work it with all the projects select that you want in one run.
I tried creating a group as follows:
but it still only gives me projects up to the letter S even though I selected all.
When I select all I receive this error message:
There was an issue is selecting a large number of projects at a time in the version you have installed. I cannot recall the exact number that was the breaking point but if you at least upgrade the application to 2018.1 the issue should be fixed.
If you have an active support contract you can contact support if you need a bit of assistance in regards to getting the installation and application package for installation upgrade.
Thank you. I will talk to our IT department.