Incoming payments DTW

[pter_forr]

I am trying to import payments transferred to our bank account by business partners against our down payment requests.

As described in several threads in this forum I should be using 3 tables to do it:

Payments

Payments_invoices

Payments_accounts

For me this configuration is however not working. I get: "Cannot pay to account when the payment is to a business partner".

I managed to import the incoming payments with only 2 tables, without using Payments_accounts, having our bank account's G/L account number in the TransferAccount field of the Payments table.

1) Is there any problem doing so, and has anyone really managed to use dtw with all of the 3 recomended tables to import incoming payments?

2) My process is working until currency is not a foreign one. As soon as it is, I am not able to avoid the following error: "Cannot pay the document partially Application-defined or object-defined error65171"

Thanks in advance for any idea/comment.

Peter

[former_member583013]

Peter,

When importing incoming payment against certain invoices you would need to identify the Invoices in your template and also selecting the BP is important so that the Customer can get credited.

Suda

[pter_forr]

Suda,

Thanks for your answer.

No problem on that, of course the invoices and customers are referenced with the right codes.

It is working perfectly with local currency, the problem I described (in point 2) is coming out only (and always) when foreign currency is used.

Peter

[pter_forr]

1) as there was no contradiction, I assume my way is the right one.

2) I found the solution:

Exchange rates are to be entered in sbo before importing payments in foreing currencies with dtw. It seems not being able to work in any other way.