Hello,

We have a number of queries of our system relating to historical problems on the tfacp200 table.

Is there any defined procedure for removing these ?

For example we have two CBR's against one supplier. The two CBR's one negative and one positive have the same value and as a result cancel each other out but they both have balance figures.

Amount Balance
CBR 20 719.11- 719.11-
CBR 117 719.11 719.11

Is there any way of removing the balances ?

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Hi Neal,

Please check, if correction program "Recalculate Supplier Balances" (tfacp2245m000/tfcor0260) can solve your problem.
Make sure that you get the latest solution of this program from your local Baan Support.
First run this session in your test system and then only decide whether to run it on your Production system.
Please take backup of table tfacp200, before running this session.

Any other suggestions ?

Hello and thanks for the input.

tfacp2245m000 does throw up a problem with the balance on the first record but I'm still stuck with the two CBR records with balances.

As these records crop up various reports Finance seem to be more worried about getting the balances on the tfacp200 records to zero for the sake of tidying up each suppliers accounts. In this example is there any way this can be done legitimately through the system.

Cheers
Neal

>>tfacp2245m000 does throw up a problem with the balance on the first record but I'm still stuck with the two CBR records with balances.

Is it happening specifically for the supplier in concern ?
I am sure, you must have specified Supplier - From and To as the supplier of the two CBR records only. Still, ...

Just let us know, what error does tfacp2245 throw ?

Otherwise, there is a session "Write off Payment Differences" (tfacp2230m000). Not really sure whether it will solve the problem.

In my opinion, tfacp2245 would be the correct session.

Let's wait, for what the other people say ?

Amount Balance
CBR 20 719.11- 719.11-
CBR 117 719.11 719.11

tfacp2245 throws up an error on the first record saying that the balance on CBR 20 is zero but should be -719.11.

The overall supplier balance on the report before and after is zero though.

There is obviously an inconsistency somewhere but even by correcting it I will still have the two records with balance amounts present on the account.

Cheers
Neal

Hi

Can you not match the two entries when allocating a payment?

Hi Jayant,

I'm afraid I'm not a Finance person.

Which sessions would you use to do this ?

Regards
Neal

Hi Neal

When entering a payment to a supplier, you can either allocate it to one or more specific invoices or leave it as an on account payment. Any on account payment can subsequently be allocated to specific invoices. This is done by creating a 'Transaction Type' in BaaN Finance. Such a transaction type must have following sessions tfcmg2131s000 and tfcmg2106s000. The seeions are to be defined on the second form of the session Maintain Transaction Types

Hope this helps

Thanks a lot I'll have a go at following this through.

Cheers
Neal