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.
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.
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;
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156