Imoport Budget

Business Central/NAV User Forum
1

Hi ,

I have created a budget in Excel ( same format as Export file) file BUT I am not able to run the Import into NAV4SP3 .

This is the error that I have: " You cannot import the same information. The combination G/L Account No.- Dimensions- Date must be unique".

It’s the first time that I do that job so I dont understand the message.

Any help will be appreciated.

Thanks

2

Hi,

Looks like you have a duplication line in the sheet. Check that you have not repeated the G/L account or dimension combination if using dimensions.

3

Hi Dave,

I have checked and there is no duplicaion line on the file. So why the problem?

Thanks

4

Hi,

Can you check the dates for a duplicate and also blanks in rows / column

5

Hi Dave,

Do you mean that all blanks columns inside dates should not be included when doing the import? I have few columns where we have 0 $

Thanks

6

Hi,

Yes blank rows/columns - Excel can leave row/colunm that look blank when process picks up as a enter blank code.

Usally I go to the row/column after last row/column and deleted to the end to be sure

Turn on you debugger and you should be able to see which column/row is causing the issue.

7

Hi,

I did what you say but same results, sme error. It looks like , if import has been sucessfull one time and you delete entries to retry again , it does not work. am i right? Apparently import has been deleted by someone and when I am trying now , no sucess at all.

any clue?

Thanks

8

Hi,

I did what you say but same results, sme error. It looks like , if import has been sucessfull one time and you delete entries to retry again , it does not work. am i right? Apparently import has been deleted by someone and when I am trying now , no sucess at all.

any clue?

Thanks

9

Hi,

No, you can import as often as you like (I did this today for a customer until the numbers were correct). This still points to an error on the excel sheet.

Did you turn on the debugger to find out where the error occurs?

10

Hello all, just recently I had the exact same error for someone I know on NAV 2009 Classic. What they claim to have did was use last years budget excel spreadsheet and add new columns in i.e. dimensions and import the excel spreadsheet (format has changed now remember, now they have extra column(s) into a new budget with a new name ie. last years was 2014/2015 and so the new budget has name 2015/2016. After digging around, debugging, we followed the steps of the manual.

Turns out that the best practice is to create a budget, export spreadsheet (do not use last years), update newly exported spreadsheet, and import. This worked fine in our case.

As per manual, follow the instructions… theres not many bug fixes around this area I would have thought so is a solid functional area.

It may not be the same issue for bof4all because they using NAV 4.0 SP3 but just that II’d share this with the community

Thank you