Import Incoming Payments with DTW

[Former Member]

Hi,

I would like to know how to import Incoming Payments with DTW.

I mean, what do i have to do first, in what order? Do I have to use the oIncomingPayments template only or some other combined with it? Do i need to import the invoices first?

Thanks..

[former_member583013 · Accepted solution]

Hello,

In the oIncomingPayments folder you will find several templates that could be used for various types of Incoming Payments.

The Payments.xlt is the header template.

Here you will define the CardCode, DocDate and a running RecordKey

RecordKey....CardCode....DocDate

1..................C1000..........20080118

2..................C1002..........20080127

3..................C1004..........20080128

If the Payment is by check then you will use Payments_Checks.xlt along with Payments.xlt Header file.

Let me know your specific type of payment and I could guide you further

Suda

[Former Member · Accepted solution]

Hi Suda, thanks for reply

When i import the invoices, are the incoming payments imported automatically?

If yes, what happens when the invoice has its payment fragmented and there are fragments already payed?

[former_member583013 · Accepted solution]

The templates I have recommended are only for Importing Incoming Payments and has nothing to do with Invoice import.

You are use the Payments_Invoices.xlt to associate a payment to an Invoice.

NOTE: For associating an Invoice with the Payment you will use the DocEntry of the Invoice and NOT DOCNUM.

If you are importing Invoices that have beed partially paid in your legacy system then you should use the templates inside oInvoices folder and Import the Invoices with the balance due amounts and not the Original Invoice amount.

Suda

[Former Member · Accepted solution]

Suda,

I have followed the guidelines you have provided in these posts and I continue to receive the following error message: Invalid Document number (RCT2.DocEntry][line:]....

Could you tell me where I can confirm the DocEntry number for a particular invoice within the system?