Dimension Value Code empty in some NAV companies


I've created a dimension under JDM based on the dimension that is used in some companies of my NAV DB (it's not a global dimension).
The problem is that I don't know what to do when there is a company that don't use this dimension. Now JDM tries to migrate all data and when there's a row without this dimension it informs me that there's an error: 'Violation of foreign key constraint - record (DW_Account), (Entry(No.)) not found in table (dbo).(NAV_dbo_Ledger Entry Dimension_V).

I'm sorry if my post isn't clear, but I'm not an IT guy and JDM is something new for me:)

If there's some documentation that I should post also, please let me know what should it be.


1 comment

Please sign in to leave a comment.