I am trying to implement the Journal Voucher upload using an exchange scheme. I can get it to work fine if I use 3 separate files for the Batch Header, Document Header, and Document Lines. However, I would prefer having all these in one file. When I try to use one file, it imports nothing even though my conditions are correct. Any advice from the baanboard??? :confused:

Data can be in one file, each record should be identified by a record identifier to know what type of record it is. Each record has 2 fields, the identifier and the data. In the exchange scripts you can map parts of the data to the table fields.

I do have an identifier as the first field with the table fields following. Here is an example of my file:

B|1000000010|19990531|262|1999|5|5|1999|5|JML||CORRECT T&E EXPENSE CODING
H|1000000010|199900501|0|19990531|USD|1|USA|1999|5
L|1000000010|199900501|014|262|621020|355|03106||||||119.04|C||||CORRECT JOHN SMITH|1999|5|||5|1999

Where "B" is the batch header (tfgld213), "H" is the Document header (tfgld214) and "L" are the lines (tfgld215).

So, you got this from the JV Import example, right? I've gotten that working in the past...Can you post your conditions? And if possible the screen shots of where/how the conditions are attaching to the scheme.

attached is a document with the conditions and a screenshot of the Maintain Table Relations(import) session (tuxch0121m000).

did you got it to work finally?
We are close of implementing this as well, so i'm curious of any tricks you can give me.

I ended up coding my own import.

we did get it to work with 1 file. no problem at all.