I need to create a new Payment method that does not use anticipated payments with Anti. set to NO. I created the method, input a test invoice and attempted to pay the invoice, I received the following. "Combination of bank relation and payment method not found." When I attempt to use tfcmg0145m000 I run into a roadblock.

Any suggestions?

Thank you in advance for your help.

Doug

This is interesting. I've never created a payment method like that, why would you want to create one without using anticipated payments?

The reason is that currently we have one bank relation linked to three payment methods (CK= check, MC= Manual Check, WT = Wire Transfer). The transaction type that we are using to reconcile our payments is CHK. The problem that I am facing is this. When we run our cleared check report it picks up all three payment methods. For the Manual check it's not a big issue since we only do one or two a year if that. The Wire transfers are the problem, we have to pull each one of them out of the report to determine what our true cleared check balance is. The second area is that when we pay by wire transfer the funds come out of our cash account imediately. We don't need to go through the reconciliation process. The final problem is this when we pay by wire it's in payment of foreign amounts. When the system clears the payment it does it for the exact amount that the payment was made for. Their is a field that you can input the actual amount paid but it overrides it when it process the record. We end up doing a J/E to adjust our cash account and FX currency gain/loss account to actual for each payment we make since the bank uses a different FX rate then what we have in the system. We don't want to change the FX rates in the system to match the banks each time we do a deal.

When you combine all of these factors it would cut down on the amount of work we have to do to handle this situation.

Now all we would need to do is process the payment and the system will Dr. Accounts payable and Cr. Cash when this is done. Then do a J/E to adjust cash and FX Gain/Loss. Rather then having to go through the entire reconciliation process.

We want to keep the anticipated payments in place for our checks since they do not clear our cash account at the bank until a later date.

The only way that I can figure it to work is to setup a new Bank relation and link a new payment method and Transaction type as well as Mtn. Data by Bank/Pmt Mtd. making sure that I set the anticipated fields to NO.

Hopefully I didn't lose you in this

Thanks for your help.

Doug

Hello Doug,

I replicated your requirement and created a Payment method with aniticipated payment(both the fields) set to "No". I then linked this payment method with a Bank that already has another payment method linked with it and made an advance payment using a foreign currency. In the session tfcmg1120m000 I changed the exchange rate also to a rate different from the master rate. I then processed the record. I got no problems.

What was the message that came up in the session tfcmg0145m000 when you tried to maintain the bank/payment method combination? You have to fill in the field "Anticipated payment ledger account" with a dummy account number and also give the series number for the transaction type tied to the bank.

You will not be able to reach the zoom session. But this is not required.

The entry ultimately passed was
Debit - Advance payment
Credit - Bank

The rate of exchange used was the rate I input in the session tfcmg1120m000.

I am on Baan IVc3

I hope this helps

Sudarshan