News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... XML Import Employee De...

Small and medium business | Business Central, N...

Suggested answer

XML Import Employee Department

(0) Share

Report

Report

Posted on by Mohammed Marhoon

12

We created XMLPort to import Employee Departments.

However we are getting error

The field No. of table Default Dimension contains a value 'XXXXX' that can not be found in related table (Employee)

Any hint please.

All responses Img

All responses (2)

Answers Img

Answers (0)

Mohammed Marhoon 12 on at

Like (0)

Report

RE: XML Import Employee Department

Its part of the default CodeUnit 408 DimensionManagement and part of SaveDefaultDim Function

See the error stop in which line 11

1SaveDefaultDim(TableID : Integer;No : Code;FieldNumber : Integer;ShortcutDimCode : Code)

2 GetGLSetup;

3 IF ShortcutDimCode <> '' THEN BEGIN

4 IF DefaultDim.GET(TableID,No,GLSetupShortcutDimCode[FieldNumber])

5 THEN BEGIN

6 DefaultDim.VALIDATE("Dimension Value Code",ShortcutDimCode);

7 DefaultDim.MODIFY;

8 END ELSE BEGIN

9 DefaultDim.INIT;

10 DefaultDim.VALIDATE("Table ID",TableID);

11 DefaultDim.VALIDATE("No.",No); = >>>> Error Stop in this Line

12 DefaultDim.VALIDATE("Dimension Code",GLSetupShortcutDimCode[FieldNumber]);

13 DefaultDim.VALIDATE("Dimension Value Code",ShortcutDimCode);

14 DefaultDim.INSERT;

15 END;

16 END ELSE

17 IF DefaultDim.GET(TableID,No,GLSetupShortcutDimCode[FieldNumber]) THEN

18 DefaultDim.DELETE;
Suggested answer

JAngle 95 on at

Like (0)

Report

RE: XML Import Employee Department

Is the xml port looking to handle the default dimension table? Looks like the validation code of default dimension is run before the insert(); on the employee table has run

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans