I have an XmlPort to import the G/L Entries with their associated dimensions.
Some GLEntries doesn´t have dimension values like this:
<?xml version="1.0" encoding="UTF-16"?>
-<GLEntry> -<GLEntries> -<Entry_No>864993[color=#BF0000]-<Entry_Dimesion><Table_ID>0</Table_ID><Dimension_Entry_No>0</Dimension_Entry_No><Dimension_Code/><Dimesion_Value_Code/></Entry_Dimesion[/color]></Entry_No> <GL_Account_No>16350002</GL_Account_No> <Posting_Date>01/03/12</Posting_Date> <Document_Type> </Document_Type> <Document_No>P05.001987</Document_No> <Description>FRAS.674/673 SUMMERLAND</Description> <Bal_Account_No/>
In my XmlPort I have asociated the Entry Dimension element, with the LinkTable and LinkFields properties, but when I try to Import the xml file I obtain the following message:
"The data conflicts with the LinkTable and LinkFields setup of Table Entry_Dimension"
The problem is that the Entry_Dimension node value that I have used for the LinkFields is 0.
I have tried to put by code this in the OnAfterInitRecord of the Entry_Dimension this:
IF "Ledger Entry Dimension"."Table ID" = 0 THEN currXMLport.SKIP;
The error message has dissapear but, I obtain all the records in the G/L Entry table but any dimensions in the Ledger Entry Dimension table.
Thanks in advance