# Loading AP Invoices with DMT **URL:** \ **Category:** Epicor ERP 10\ **Created:** [October 7, 2016, 11:55am UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731 "2016-10-07T11:55:08Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [February 11, 2019, 7:04pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/22 "2019-02-11T19:04:21Z")
> [@ckrusen](#): > > Even though OP said yes … I thought that you could enter AP Invoices prior to the actual receipt. I think you can manually enter them, but to bring them in automatically, it looks for and un-invoiced receipt. If it’s coming in through the UI normally, I don’t know what else to check for. Sorry, that’s the limits of my knowledge on the accounting side. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [February 11, 2019, 7:25pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/23 "2019-02-11T19:25:27Z")
I assume you’re trying to add a new invoice and not update an existing one. Do you get the error with just the “Add New” box checked in DMT? Maybe try adding APInvDtl#InvoiceNum to your data. ---
**Author:** ![DarrenNavi](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/f17d59/32.png) [@DarrenNavi](https://www.epiusers.help/u/DarrenNavi)\ **Post date:** [February 11, 2019, 9:19pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/24 "2019-02-11T21:19:41Z")
Hmm some progress. Looks like Creating the Header, using AP Invoice Receipt to bring in the details from receipt and then updating the AP Detail Record with the new invoice amount seems to work. Its quite a step process and not as ideal as I would have hoped. Now for the tax… ---
**Author:** ![JMyers56](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/ec9cab/32.png) [@JMyers56](https://www.epiusers.help/u/JMyers56)\ **Post date:** [March 26, 2019, 9:38pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/25 "2019-03-26T21:38:08Z")
I’m having similar issues loading AP Invoices via DMT. We used the AP Invoice Combined template in E9 to do it, but now the same template won’t set the GL Account we need on the invoice line. I’ve tried manipulating the template to set fields in APInvExp as well as APInvExpTGLC, which is how we originally set GLAccount, and using both data sources to no avail. Has anyone had ANY success doing this in E10.2? I’ve attached a test file we’re trying to load as well. [APInvCombinedTest.csv](https://epiusers.help/uploads/default/original/2X/5/5ecb6be8b5b97d36270572df885f4ed46dd3d5ff.csv) (2.1 KB) ---
**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\ **Post date:** [April 18, 2019, 8:53pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/26 "2019-04-18T20:53:09Z")
I have had some success with the Misc invoices in 10.2, still struggling with the inventory receipts. Here is my working Misc Invoice template. It’s the combined template.[AP Invoice Combined.xlsx](https://epiusers.help/uploads/default/original/3X/c/0/c002c439bc1303fa8af65035a02cbb3aa37a6498.xlsx) (10.5 KB) ---
**Author:** ![JMyers56](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/ec9cab/32.png) [@JMyers56](https://www.epiusers.help/u/JMyers56)\ **Post date:** [April 18, 2019, 9:01pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/27 "2019-04-18T21:01:07Z")
Mark, we got the issue resolved with the newest update to DMT(4.0.42.0). There was a bug in DMT that prevented update of the GLAccount at the same time as creating an AP Invoice, however it’s supposed to be fixed. Thanks to all on the DMT development team for their hard work and quick response, especially Gary Parfrey! ---
**Author:** ![lmeeks](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/e79b87/32.png) [@lmeeks](https://www.epiusers.help/u/lmeeks)\ **Post date:** [April 22, 2019, 8:56pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/28 "2019-04-22T20:56:59Z")
I downloaded the 4.0.42.0 and My GL account still will not create the correct account. I have attached the template I am using. Any chance I could get some feed back on the template? Thanks, Lisa Meeks [New AP Comb Inv WI with changed GL.csv](https://epiusers.help/uploads/default/original/3X/0/2/02a355ef0d8bcf9bc7ac6bc60cd43625a88d60af.csv) (1.3 KB) ---
**Author:** ![JMyers56](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/ec9cab/32.png) [@JMyers56](https://www.epiusers.help/u/JMyers56)\ **Post date:** [April 25, 2019, 4:44pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/29 "2019-04-25T16:44:47Z")
Lisa, I’ve attached our template we use to create AP Invoice batches. In our case, we don’t need to specify a GL Account as we attached a GL Account to our Vendor entries, so it’s using those as a default when creating the invoice. [APInvCombinedExample.csv](https://epiusers.help/uploads/default/original/3X/3/5/35d3a3e3cb8ffd26d6e9983a84ab74af230e5e03.csv) (449 Bytes) ---
**Author:** ![vcortes](https://www.epiusers.help/letter_avatar_proxy/v4/letter/v/57b2e6/32.png) [@vcortes](https://www.epiusers.help/u/vcortes)\ **Post date:** [May 9, 2019, 9:06pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/30 "2019-05-09T21:06:50Z")
what process are you using to upload this via the DMT? we have DMT Version 1.0.4.3 for 8.03.409. we don’t have a menu on DMT to update AP records only “Financial” --\> “Open AP Load” ---
**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\ **Post date:** [May 20, 2019, 7:42pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/31 "2019-05-20T19:42:14Z")
Darren, I managed to get the Misc lines importing just fine but am still having issues with the receipts. Would you by chance remember which fields you used for AP Invoice Receipt and AP Detail record to make this work? I get an internal server error with the combined template and on the Invoice Receipt I can run it without errors but it doesn’t look like anything is happening? ---
**Author:** ![DarrenNavi](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/f17d59/32.png) [@DarrenNavi](https://www.epiusers.help/u/DarrenNavi)\ **Post date:** [May 27, 2019, 8:03pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/32 "2019-05-27T20:03:41Z")
Hi Mark Try this one. It worked for us [Send sample ReceiptLines.xlsx](https://epiusers.help/uploads/default/original/3X/7/7/779c73209dcaf2318e94c4f3a8307684fe9a53d4.xlsx) (8.9 KB) ---
**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\ **Post date:** [May 28, 2019, 4:11pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/33 "2019-05-28T16:11:13Z")
Thanks Darren, this template is doing the same thing. While poking through the trace log I noticed that it’s not passing ‘SelectLine’ to the business object correctly so I opened a help desk ticket. I don’t know which version you’re on but I wonder if it’s broken at this time. ![image](https://epiusers.help/uploads/default/original/3X/7/0/70d4d71a3c235491fc6e1d6544039020f2886cb1.png) ---
**Author:** ![DarrenNavi](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/f17d59/32.png) [@DarrenNavi](https://www.epiusers.help/u/DarrenNavi)\ **Post date:** [June 10, 2019, 2:37am UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/34 "2019-06-10T02:37:24Z")
Hi Mark Did you try using bit format for that field (0/1) instead of the True/False ---
**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\ **Post date:** [June 10, 2019, 2:11pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/35 "2019-06-10T14:11:13Z")
Thanks Darren but it did not help, last week it was elevated to a problem PRB0213286 This section of DMT is a hot mess, misc invoice line GL mapping on version 4.0.43.0 did not work, I had to revert to 4.0.42.0. Today I tried the brand new 4.0.44.0 and the misc invoice issue is fixed but this line type R issue still remains. ---
**Author:** ![rgross](https://www.epiusers.help/letter_avatar_proxy/v4/letter/r/f19dbf/32.png) [@rgross](https://www.epiusers.help/u/rgross)\ **Post date:** [July 10, 2019, 3:57pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/36 "2019-07-10T15:57:34Z")
I’m having the same problem also. I’m able to upload and create my AP invoice with line and job details, but not able to add a material to the job. Were you able to resolve this issue? ---
**Author:** ![Patricio](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/5e9695/32.png) [@Patricio](https://www.epiusers.help/u/Patricio)\ **Post date:** [July 31, 2019, 9:41am UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/37 "2019-07-31T09:41:38Z")
Hi Roger. No, I wasn’t. If I remember correctly I reported this to Epicor and they told me that in this version that action didn’t work and that I needed to update DMT to the newest version. I did but to be honest I didn’t do the exercise again. Hope this helps! ---
**Author:** ![Mohamed\_Yusuff\_S](https://www.epiusers.help/user_avatar/www.epiusers.help/mohamed_yusuff_s/32/18096_2.png) [@Mohamed\_Yusuff\_S](https://www.epiusers.help/u/Mohamed_Yusuff_S)\ **Post date:** [September 16, 2019, 7:51am UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/38 "2019-09-16T07:51:49Z")
Hi How to Map GL Account to the Invoice Line . I tried but getting Error as Invalid Distribution Amount ---
**Author:** ![MattG](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@MattG](https://www.epiusers.help/u/MattG)\ **Post date:** [April 27, 2020, 7:58pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/39 "2020-04-27T19:58:03Z")
Mark, Did you ever find a resolution for this by chance? We are trying to import invoices from Concur using DMT that have POs and Receipts being matched up. The combined process does not work for this due to a system pop up that comes up when you manually do this in Epicor according to support on the DMT side of Epicor. We were attempting to do it individually by creating the Header first and then the Receipt record with the “AP Invoice Receipt” process in DMT as mentioned further up by DarrenNavi, but we are also getting a generic system error like you described. We don’t have any issues using the combined process to import invoices that don’t have POs/receipts associated with them, but are struggling trying to implement for the invoices that have PO and receipt references. ---
**Author:** ![markb\_wi](https://www.epiusers.help/user_avatar/www.epiusers.help/markb_wi/32/3457_2.png) [@markb\_wi](https://www.epiusers.help/u/markb_wi)\ **Post date:** [April 27, 2020, 8:05pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/40 "2020-04-27T20:05:48Z")
Sorry Matt but we have tabled that project for now. I am hoping to get back to it as some newer versions have come out since. ---
**Author:** ![MattG](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/4af34b/32.png) [@MattG](https://www.epiusers.help/u/MattG)\ **Post date:** [April 27, 2020, 8:10pm UTC](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731/41 "2020-04-27T20:10:17Z")
Okay, thank you for the reply. I’ll reply to this post if we figure anything out with it on our end. [Previous page](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731.md?page=1) [Next page](https://www.epiusers.help/t/loading-ap-invoices-with-dmt/35731.md?page=3)