cancel
Showing results for 
Search instead for 
Did you mean: 

How to import Incoming Payments via DTW

Former Member
0 Kudos
1,245

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

View Entire Topic
Former Member
0 Kudos

The correct template should be oIncomingPayments.

Thanks,

Gordon

Former Member
0 Kudos

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
0 Kudos

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

Sry,

Don

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Thanks. I will try that.

Don

Former Member
0 Kudos

Gordon,

That worked for 95% of them.

Thanks,

don

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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...