XML Port for G/L General Journal-Payroll Journal Batch Name

Normajm

I've set up a simple XML port with four fields from the General Journal line. It filters only on the lines with the journal batch name "Payroll". It exports fine - journal batch name, type, G/L number and amount and, but I'm unable to import the same file I've exported.

The error is: The field Journal Batch Name of table Gen. Journal Line contains a value (Payroll) that cannot be found in the related table (Gen. Journal Batch). I ran the table and there is a "Payroll" entry there and it is on the lines of the journal I'm exporting from. What am I missing to get the import side to work?

Thank you...

mohana_cse06

Are you exporting Template Name also?
Is Template name field before batch name while importing?
May be it is trying to validate and template name is not set properly etc.

Normajm

Thank you - I needed to add Template Name and Line no.
Export and import work fine now.

Next step - tweak the code behind to autopopulate Template Name, Journal Batch and Line no.

I'll be back