XML AP Import File

[TRBG (Gaylene Davis)]

We are trying to take an XML file from Concur and import automatically into Epicor 10.2.200.8. We can’t seem to get the import file to include GL Account numbers. We can only make it work by using part codes. Has anybody found any way to include the GL Account Numbers in the XML file for generic import?

[Aaron_Moreng]

Are you talking about the generic GL import functionality? A while ago I did some investigation into how to make it work, maybe this will help

GL Import exception

Hey Ben, I actually don’t remember…it’s been a while and I’m not sure what route Finance ended up taking. But, I’d be happy to share my documentation on it and example files with you. GL Import Functionality.pdf (530.5 KB) ExampleCSVWithData.csv (307 Bytes) GLImportStructure.xlsx (14.3 KB) Obviously your book probably has different segment mappings then mine but I am looking through my old stuff and it looks like I had eventually got it to work.

[TRBG (Gaylene Davis)]

Yes… we are talking about generic GL import functionality. Did you attach something to your previous post? I didn’t see it.

Thanks,

Gaylene Davis

[Aaron_Moreng]

If you click on the link, post #6 has some downloadable links to documentation and some example files (with my specific GL config, yours might be different)