Import Budget from Excel error

CobaltSS

HI all

I'm trying to import a budget that has been edited after it was exported. I'm getting an error that states the "The Dimension Value does not exist. Dimension Code = DEPARTMENT, Code = 150,000"

The Department Code should be 150000 (no comma), which it is in the spreadsheet. I tried changing the "Digit Grouping" property in Regional and Language Settings", but that did not solve the issue.

Any advice greatly appreciated,
cheers,

Belias

format the column as text, add a quotemark before the value...do anything you can to have a plain number in the column...in this way you'll be able to import it.
Other (recommended) solution: EXport a budget from nav, delete lines from excel file, copy and paste your lines (i think you created your excel file with 150,000 manually) into the previously exported (and cleared) spreadsheet.

CobaltSS

Hi Belias,

The Excel file was created from the Export, but the budget numbers were entered manually. I tried everything I could think of in the Excel file to get the numbers treated as text, but with no luck. So in Report 81, I added this line:
InsertGLBudgetDim(DimCode2 : Code[20];DimValCode2 : Code[20];VAR GLBudgetEntry2 : Record "G/L Budget Entry")
DimValCode2 := DELCHR(DimValCode2, '=', ',');

This approach solved the problem, but if anyone has a solution that I can use outside of NAV, I'd appreciate the thought.

cheers,

Belias

CobaltSS wrote:

Hi Belias,

The Excel file was created from the Export, but the budget numbers were entered manually. I tried everything I could think of in the Excel file to get the numbers treated as text, but with no luck. So in Report 81, I added this line:
InsertGLBudgetDim(DimCode2 : Code[20];DimValCode2 : Code[20];VAR GLBudgetEntry2 : Record "G/L Budget Entry")
DimValCode2 := DELCHR(DimValCode2, '=', ',');

This approach solved the problem, but if anyone has a solution that I can use outside of NAV, I'd appreciate the thought.

cheers,

try to preformat the column as text

CobaltSS

HI again,

Maybe we're talking two different things. In the Excel spreadsheet, after the Export, but before the Import the user entered a value of 150000. In the Excel spreadsheet, there is no comma. The comma only appears as a NAV error when the Budget is being imported.

I think, from what you're saying (and I could be worng; it's happened before!), you think the problem is with the Excel spreadsheet. But the spreadsheet looks fine (no commas). The column is formatted as text, and an apostrophe used too.

cheers,

Belias

ok, now i understood!anyway, it's quite strange...I don't know the exact solution...you should try to debug and test it...but i think you've already done this...