Payment transfer in collective bill account

[Former Member]

What is the most efficient process of transferring payments from one collective bill account to another collective bill account?

We cannot use FP40 because it gives this error message:

Contract account xxxxxxxxxxxx is a collective bill account

Message no. >5727

Diagnosis

Contract account xxxxxxxxxxxx is a collective invoice account. Transfer posting is not permitted for collective invoice accounts.

Procedure

Specify a valid contract account.

Edited by: BlueMountain on Oct 22, 2009 5:44 PM

[Former Member]

You just cannot and that is what the message is saying. A payment on a collective account could have been for any of the children and might have cleared all or some of its children's receivables. So cannot simply transfer posting payment from one collective to another. Simply reverse the payment and post a payment on the other.

[william_eastman]

Bluemountain:

As part of the reversal process, select the clarification option and then use the clarification transaction (FPCPL) or the FP05 clarify option. This will enable you to change the account number to which the payment should post.

regards,

bill.

[Former Member]

Here is the tricky part.

The original payment is $20000 broken down as:

1) $4000 cleared receivables and the remaining went to Payment on Account.

2) $16000 automatically went to payment on account.

After that, reset clearing was performed on the $4000. As expected, I can see 2 payment on accounts (1 is $16000 and 1 is $4000) in tcode FPL9. The $16000 still has a doc type of PL (Payment Lot) but the $4000 has a doc type of CR (Clearing reset).

When I tried to reverse the $4000 (doc type CR), I get the error message "Cannot be reversed due t clearing reset".

When I tried to reverse the $16000 (doc type PL), I cannot do it because of the reversal clearing document (referring to the same document for $4000).

Because of these, I cannot reverse the $20000 payment.

Any workarounds?

Thanks and kind regards.

[former_member811801]

Hi,

Any Transfer Posting which does not happens thru FP40 like Collective Contract Account or transfer posting between two GL account can be done through manual posting.

In required scenario payment on account needs to be transferred from one Collective account to another.

Create a Main & Sub transaction by assigning target GL account in Tcode ek01 & ek02.

While creating sub tran activate the payment transction field so that after transfer of payment it appears in payment list in new Contract account.

In FPE1,

Click on select open item & enter the Contract account no or document number to be transferred .

Click on BUsiness Partner Line item

Enter the company code, Coll CA , targeted main & sub tran (created above) & amount

With this payment transaction will be transffered from old Coll Ca to new Coll CA as payment transaction & even GL account (if different ) will get transferred.

Regds

Sachin

[william_eastman]

BlueMountain:

It is unfortunate that the user executed reset clearing in this case - that appears to be a training issue. Can you reverse the CR document? Or can you reset clear the items to clarification? There have been many changes to the allowance of these transactions throughout the versions, so i cannot say what you will be able to do.

As for manual posting, that should only be a last resort - you lose history; billprint is unable to interpret the items correctly, FPL9 shows them differently, etc.

regards,

bill.