Thank you for the info.

I have found the help files, and now I have a question.
in GL90Cexportbatchesdetailsonly.pdf, it listed the tables of fields.

Most of the fields are straightforward, but I could not find an explanation for RECORD TYPE.

Can you tell me what is the record type?

Field Name Default
Type
Length Notes
Record Type String 6 “D” or “E”

Cheers,

Michael

Thanks Steve.

That is very helpful.
We are using OE right now, and I think we are sticking with it. At least for now.

Cheers,

Hi Michael,

The 'Record Type' field is common to both of the batch type imports - not only 'Detail only' but also 'Header Detail'. In the case of Header/Detail, the Record type differentiates a row in the import file being either a header or a detail line, as each has different information.

In the case of the detail only import, every row will have the same information and thus the recognized values are either all D or all E (no difference between the two - these are the values due to legacy reasons).

Because the values for the detail only import of batches will all be the same, you don't have to import the record type field. Instead, you can remove it from the list of fields to import and add it on the list of field to default - on the Field Defaults tab. This is why the PDF you have does not require the record type to be in the import file, but it has to be part of the template.

Thank you very much!