105
Hello,
I tried to import a budget to Analytical Account, but I recived an error mesage: The import failed because the spreadsheet is in an incorrect format. I used the format expoted format from GP. I am not sure if this format is the correct. Could you help me please?
Thank you
Alejandro Jara
*This post is locked for comments
I'm trying to do an import in GP2010 and getting the same error when using the same exact format when the budget is exported. What needs to be populated in column c? in the export file, it is the Budget Tree ID.
Another thing that might help - working on GP10 My suggestion is to also unhide columns A and B. If adding new rows you need to ensure that these columns named: RowId and aaCodesequence are in sync with other existing rows.
if you are in gp 9.0, there's a kb on it... however, if you are above gp 9.0, then you will want to review the column C of the excel file you exported.
i assisted a client on the same issue.. we tried everything.. sometimes it will import ok after export, but sometimes it won't -- until we disabled all auto formatting in Excel, exported the aa budget to import it back.. with this, the issue persisted.... so we looked at all columns and saw that when the import is good, column c is populated.. when the import is failing because of the incorrect format issue, it's becasue column C is blank. check it out....
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (