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
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
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.
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
Why not use AP Open Load menu Item to upload open AP Invoices.
Hi, is there any way to put into this DMT the Tax amount and gross amount of the invoices, we are doing cutover so i need the tax to match old system, it appears to work the rate out based on customer / sales order set up. It’s advanced invoices we are putting in and i can see i can go and edit the group once they are in and then go to the tax tab and manually tick the ‘Manual Tax calculation’ box and enter the Vat amount i want, but i really need to be able to do this via the DMT
Can’t see this field ‘InvcTax.DspDocTaxAmt’ in the DMT template builder at all, or this ‘InvcTax.Manual’ which are the fields i believe i need
Kind Regards
Kelly
Sorry it’s AR Invoice Combined i’m using
Hello Andris & Paul
I have just created a template with all the columns you have both stated and I am getting the error “Index was outside the bounds of the array”. I have no idea what field it is referring do. Any ideas?
Many thanks
Sarah
Sarah,
I’m not sure. Can you try to narrow it down by just doing the DMT with the header fields, first? You might have to submit an EpiCare ticket on behalf of your client…