asked on

GP 2010 - Budget ID Export

We are having a problem with exporting a budget id from GP to Excel. When we run the smartlist for this budgetid, we get 44.090 lines (correct). when I pull the same information from the GL00201 table in SQL, I get 44,090 lines (correct). But when I export this budget id from GP into Excel, I only get 203 lines. What could the problem be?

thanks!

Victoria Yudin

How exactly are you exporting the budget into Excel? (There are different ways to do this, just want to find out what steps you are going through.)

What version of Excel?

What is the date range of the budget?

Have you tried on a different computer? As a different user? After restarting your computer?

Are you getting any errors when exporting?

pstre

ASKER

Go into GP, find the budget id, choose option to Export to Excel. We are on MS Office 2010, have tried it on several computers and logging on as different users (even me.. I am SA and it only exports 203 rows but in the SmartList and in the SQL table, we get over 44 thousand lines which is correct. GP 2010 is exporting the file as a xls file and not a xlsx file. There is no option to export as xlsx.

Date range of budet is a calendar year (1/1/13-12/31/13)

ASKER CERTIFIED SOLUTION

Victoria Yudin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pstre

ASKER

we have done all of the above. Yes, we do have Excel installed on the SQL server. When we export, the data goes to the Excel that is installed on the SQL server.

Victoria Yudin

I am guessing by your last answer that you are running the GP application on a Terminal Server? Is that how all users are accessing GP? Are you actually logging into the Terminal Server or are you using RemoteApp?

Do you have the GP application installed anywhere else besides the Terminal Server?

pstre

ASKER

No...GP application is on a Citrix server. I am just going to close this one, Victoria. Now that the budget ids are set up for 2014, there have been no problems. All of the rows are copying to Excel now. It is crazy...

Victoria Yudin

Strange. Glad to hear the 2014 budgets are working properly.