Skip to Content

Incoming payments DTW

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 14, 2008 at 01:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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