DMT AP Invoices Combined

ERP 10
1

Has anyone been successful using this? We do not have multi-currency but required fields include rate group code, currency rate group and selling currency rate group along with the Vendor Number, not just the vendor.vendor ID according to Epicor support

2

Here are the columns we use… we had some trouble with this on a DMT update a while back that is not working… I forgot if we rolled the DMT version back or changed the template.

Anyways… we have CurrencyCode as USD and RateGrpCode left blank.

In VendorNumVendorID we are using the vendor id, not the vendor number. Epicor has a vendor number that gets auto sequenced that I dont believe you can see from the entry screen and need to get to it from a BAQ. Doesn’t look like you need it based on our template though. I remember this one being a pain to set up.

We only use it for misc invoices lines. Line type = M

Company
GroupID
VendorNumVendorID
InvoiceNum
InvoiceDate
ApplyDate
TermsCode
ScrDocInvoiceVendorAmt
CurrencyCode
RateGrpCode
APInvDtl#InvoiceLine
APInvDtl#LineType
APInvDtl#PartNum
APInvDtl#Description
APInvDtl#VendorQty
APInvDtl#OurQty
APInvDtl#ScrVendorQty
APInvDtl#DocScrUnitCost
APInvDtl#ScrDocExtCost
APInvExpTGLC#GLAccount
APInvExp#InvExpSeq

3

I have had it working but I had to start splitting the data into their individual tables. In the combined template it kept telling me there was a missing key when I loaded it through Powershell, but if I manually loaded the file it worked fine.

4

Paul,
This is what I have for our AP Invoice Combined template, working in 10.2.700. Ignore my UD field. We just use them for Misc line types as well… (our monthly company credit card payment, split out). It’s close to what Mike had, but we included PMUID, APInvEXpTGLC#TGLCTranNum, and APInvExp#DocScrExpAmt. And skipped APInvDtl#VendorQty, APInvDtl#OurQty, and APInvDtl#DocScrUnitCost

Company
GroupID
VendorNumVendorID
InvoiceNum
InvoiceDate
ApplyDate
ScrDocInvoiceVendorAmt
CurrencyCode
RateGrpCode
TermsCode
PMUID
APInvDtl#InvoiceLine
APInvDtl#LineType
APInvDtl#Description
APInvDtl#ScrVendorQty
APInvDtl#ScrDocExtCost
APInvDtl#OrderNum_c
APInvEXpTGLC#GLAccount
APInvExp#InvExpSeq
APInvEXpTGLC#TGLCTranNum
APInvExp#DocScrExpAmt

5

Why not use AP Open Load menu Item to upload open AP Invoices.