Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Importing Invoice Payments Using the AP Integration Task

When a .xml file is successfully imported, the filename extension will be appended with

.imported_YYYYMMDDHHMMSSmmm, where YYYY is the year, MM is the two-digit month, DD is the two-digit day, HH is the two-digit hour, MM is the minutes, SS is the seconds, and mmm is the milliseconds. For example, a file imported on November 15, 2007, at 8:58:23 p.m. might be called payment.xml.imported_20071115205823788.

If any errors were encountered, the extension will be changed to

.ERROR_IMPORTING_YYYYMMDDHHMMSSmmm. The task will not process any other invoices in the file with the error. Ensure that the import directory is checked regularly for files with errors.

Sample XML Import File

file_Invoice_Import

Correlation between XML Tags and the eCounsel Database

XML

eCounsel

Node Set

Tag

Table

Field

Type

Invoice

Invoice_ID

Invoice

Invoice_ID

int

VendorNumber

Invoice

EntityNumber

varchar(40)

InternalInvoiceNumber

Invoice

OurInvoiceNumber

varchar(20)

PaymentDate

Invoice

PaymentDate

datetime

PaymentAmount

Invoice

PaymentAmount

numeric(17,2)

PaymentMethod

Invoice

PaymentMethod_CD

varchar(40)

CheckNumber

Invoice

CheckNumber

varchar(20)

  • Was this article helpful?