FPY1 pays only 9999 postings (max.)

[Former Member]

Hi all,

I am trying to pay 30000 postings with the transaction FPY1 but the problem is, FPY1 only pays a maximum of 9999 postings on each run for the same XBLNR. It is normal or am I missing anything?

Cheers

Mar

[AmlanBanerjee · Accepted solution]

Hi Marc,

This is a standard scenario. Please refer to the SAP note 339904.

Hope it helps.

Cheers,

Amlan

[Former Member]

Hi Amlan,

thanks for your reply, the SAP note 339904 is for the transaction FP07 (reset cleared items) and my problem is with the payment run (FPY1).

I can pay 30000 postings if I run 3 times the FPY1 for the same XBLNR. I should pay the 30000 posting in one run. The question is how?

The payment posting is a clearing document which can clear a maximun of 9999 postings (see your SAP note). The question is: Is it possible that the payment run creates 3 payments documents for the 30000 postings and create only one record in the payment medium file for the bank?

Cheers and thanks in advance

Mar

[AmlanBanerjee]

Hi Mar,

Check the following SPRO Node-

IMG->Financial Accounting->Contract Accounts Receivable and Payable->Business Transactions->Payments->Incoming/Outgoing Payment Creation->Extended Grouping->Define Grouping Characteristics.

In the field name, you can give AUGBL and plug in a Custom FM which will that the payment document has cleared 9999 items or not.

Alternatively, you can also have a look at event 600 for your requirement.

In event 600, for each item which has been selected by the payments program, a further criterion may be set to narrow down the number of payable units. Only items which bear the same grouping term may be paid together.

Creation of a payment medium file can be customised easliy. Just develop a custom FM which reads the data from DPAYH and will create one record.

Then you need to assign the FM against the event modules for the Payment medium format that your are using under transaction FQP3.

Hope it helps...

Thanks,

Amlan

[Former Member]

Hi Amlan,

yes, it helps but only the field "XBLNR" is defined under "Define Grouping Characteristics". The payment has to be done grouping only by XBLNR

The user exit 0600 is programmed and I set a new value for the field paygr_0600 each 9999 postings. In that way, 9999 postings are payed in the first run of FPY1, but no more postings are paid for the same XBLNR

On the next run, 9999 postings are paid again.

The problem is, that the 30000 postings are not paid at once. I have to run several times FPY1 to pay all the postings

Cheers

Mar

[AmlanBanerjee]

Hi Mar,

I would recommend you to loop the field t_0600-paygr_0600 by OPBEL/XBLNR.

Also, add a counter which will increase every time the loop completes one circle.

When the loop completes 9999 circles, then modify t_0600.

Also, refresh the counter after it completes 9999 circles and the counter is set to Zero.

Hope it helps...

Cheers,

Amlan

[Former Member]

Correct Answer

Thanks a lot!

[Former Member]

Hi Marco,

I am facing the similar issue. Like in your examle the payment run creates 3 payments documents for the 30000 postings. This is working fine with the event 0600. But how did you manage to create only one record in the payment medium file for the bank?

Thank you,

Darshana

[Former Member]

Hi Darshana,

I had to extend que payment medium file exits and collect the entries in order to group them.

Cheers