How to import Incoming Payments via DTW

[Former Member]

Hello all,

I am importing opening balances for Customers via DTW. My client wants to import all the open Invoices at their original amount, and then import the incoming payments against them to have them net out to the correct remaining balance. I already know how to import the invoices. I'm looking at using the PaymentDrafts template in DTW for the Incoming payments but I could use some guidance. Can anyone provide and example of the data required to both import the incoming payments and apply them to the appropriate AR Invoice?

Thanks,

don shields

[Former Member · Accepted solution]

The correct template should be oIncomingPayments.

Thanks,

Gordon

[Former Member · Accepted solution]

I am not trying with oIncomingPayments. In the Payment_invoices template how do I specify the A/R Invoice that the paymet is to be applied to?

Thanks,

Don

[Former Member · Accepted solution]

My last post should read: "I am NOW..."

Sry,

Don

[Former Member · Accepted solution]

It is linked to RCT2 table. If your table is not empty, try a simple uery by SELECT * FROM RCT2 to see what records are in. Basically, you need to find all DocEntry for your invoice to be paid.

[Former Member · Accepted solution]

So if I understand you correctly I find the DocEntry in RCT2, and use that DocEntry in my Payments_Incoices so that it knows to apply the check to that AR Invoice?

Thanks,

Don

[Former Member · Accepted solution]

No. DocEntry in RCT2 is Invoice Docentry. Only the paid invoice can be found there. You have to find invoice docentry by SELECT * FROM OINV

[Former Member · Accepted solution]

Thanks. I will try that.

Don

[Former Member · Accepted solution]

Gordon,

That worked for 95% of them.

Thanks,

don

[Former Member · Accepted solution]

I tried to understand but I'm confuse. What templates I have to use to import payments, only Payments and Payments_invoice,or I have to use another one?

Thanks..

[Former Member · Accepted solution]

Please see the entry titled "SAP Business One - How to Import AR Invoices, and then Import Applied Cash Receipts" at this link: http://www.clientsfirst-us.com/blog/category/sap/

That is a summary of how I eventually got the whole process to work.

Hope it is of use to you,

Don

[Former Member · Accepted solution]

Ok, my problem it that I try to import payments with DTW. I have payments and payments_invoice template. When I try to import it I receive and error "The application has request the routine to terminate it in an unusual way..."

Can you tell me what I make wrong...

[former_member187989]

hi donald,

Check this link to resolve ur doubts.

Import Incoming Payments with DTW

also check this SAP Note

Note 1162513 - How to link an Incoming Payment to an Invoice via the DTW

Jeyakanthan

Edited by: Jeyakanthan A on Apr 30, 2009 10:31 PM