How to post FA G/L Jnl got data from csv file from dataport?

Aravindh_Navision

Hi Friends,

I have designed a dataport to transfer the data from csv file to Gen. Journal Line table. The data are transferring correctly. But when I tried to post from FA G/L Journal form, I am not able to post it.

I am getting an error that "Document No. XXX is out of balance due to additional reporting currency. please check that FA Add. - Currency Factor is correct for each line.". Also, it is shows that the Amount field and Amount LCY fields are not validated. I have done the below lines of code.

Gen. Journal Line - OnAfterImportRecord()

VALIDATE("Journal Template Name", 'ASSETS');
VALIDATE("Journal Batch Name", 'FIXED ASS');
VALIDATE("Line No.", "Line No.");
VALIDATE("Posting Date", "Posting Date");
VALIDATE("Source Code", 'FAGLJNL');
VALIDATE("Depreciation Book Code","Depreciation Book Code");
VALIDATE("Account Type","Account Type");
VALIDATE("Account No.", FANo);
VALIDATE(Amount, Amount);
VALIDATE("Amount (LCY)","Amount (LCY)");
VALIDATE("Shortcut Dimension 1 Code","Shortcut Dimension 1 Code");

Can anyone tell me, where I am going wrong?

Thanks,
Aravindh

Savatage

When you goto View-> Dataport fields are you importing diretly into the table fields or are you importing into Global variables?

If fields is the CallFieldValidate checked?

I prefer importing into variables for better control and having the ability to validate in the order I want.
ie/ImportedAmount

So you're Dataport fields would be your variable name's not the direct table field names.
then OnafterImport you can use your code..

VALIDATE(Amount, ImportedAmount); //then you can validate from the variable to the main field.