Can F-28 not to lump sum the full payments?

[Former Member]

Dear Experts,

I'm in the midst of customizing the layout for Official Receipt.

Our customer requires that the breakdown of the incoming payment by invoices to be printed on the official receipt.

I found out that the any full-payment made thru F-28 will be lump sum together as one single payment, instead of breakdown by invoices.

Is there anyway, we could configure that F-28 not to lump sum those full payments into one single payment?

regards,

Abraham

[former_member207607 · Accepted solution]

Dear Abraham,

I don't know if I well understood Your request.

You pay for example two invoice of 1.000 eur each.

You pay them and You would like to have:

001 40       0000113100 Dte Bank (domestic)         2.000,00
002 15       0000001968 customer                         1.000,00-
003 15       0000001968 customer                         1.000,00-

and not:

001 40       0000113100 Dte Bank (domestic)          2.000,00
002 15       0000001968 Customer                          2.000,00-

correct?

If Yes, please check the SAP note 69767 where You can customize transaction OBIA and OBIB or You should have different content into the structure KONTAB_1ST.

If Your request is another one, please give me more details.

Mauri

[Former Member · Accepted solution]

Hi Mauri,

You're right in the case of first example.

However, I couldn't find any guide in the sap note 69767 for customizing transaction OBIA and OBIB. 

Could you list down the steps?

regards,

Abraham

[former_member207607 · Accepted solution]

Dear Abraham,

it is very simple.

By OBIB You define the clearing rule, for example:

AcTyp   Clearing rule

D          BI

(D valid for customer)

by OBIA You define the fields for the clearing rule, for example:

Clearing rule           Description of the Clearing rule

BI                          XREF1,2,3

--> Clearing rule fields

2 XREF1

3 XREF2

4 XREF3

Mauri

[Former Member · Accepted solution]

Hi Mauri,

I did every steps of yours, except for BI is not accepted except for CH, so I just used CH.  But still the same, the system lumped them (all those invoices with full payments) together into one single payment.

Is there anything else that I missed out?

regards,

Abraham

[former_member207607 · Accepted solution]

Dear Abraham,

I tested into my test System and first You have to insert the Clearing rule by OBIA and You can insert a free two digits: CH, BI, OO, PP It is up to You.

Then You have to insert the Clearing rule fields example XREF1.

BUT it is clear that if You need the System to split the payment in two, the field XREF1 of the two invoices MUST have a different VALUE!!!

Then link the CH to D in case of customer, to K in case of vendor by OBIB.

Please do a new test and let me know.

Mauri

[Former Member · Accepted solution]

Hi Mauri,

I did try again with even BI but still the same. 

May I know what's the XREF1, 2 and 3 for.. and what's the tcode of defining them?

by the way, we are using SAP ECC6 EHP3.

regards,

Abraham

[former_member207607 · Accepted solution]

Dear Abraham,

the field XREF1,2,3 are free fields text that You can define as You need or by a substitution or manually during the posting. Example You post the first invoice with into XREF1, TEST , and into XREF2 TEST2 and into XREF3 TEST3; then You post a second invoice with XREF1, TEST4, XREF2 TEST5, XREF3 TEST 6. If You customize OBIA and OBIB as per my previous reply, the System during the posting will check the XREF1,2,3 content of both the invoices and if It find that the fields are filled with a different value (as in this case), It will split the payment in two customer line items. If the content is the same, the System will produce only one customer line item.

I hope now the System behaviour is more clear.

Mauri

[Former Member · Accepted solution]

Hi Mauri,

Are you saying that each XREF, say XREF1 is tied to a field of the invoice document (say the invoice amount) so that the system could detect whether the amount of 2 or more invoices being paid are same or not, then, it will post 2 or more lines if different, or if it's same, then, 1 single line only will be posted?

If so, where can I assign this XREF to the field of the invoice document?

regards,

Abraham

[former_member207607 · Accepted solution]

Dear Abraham,

XREF1 is a field of the BSEG table and can contain a free text. If You post two invoice with two different XREF1 field content, that is used into the Clearing rules (OBIA, OBIB), then when You will pay the two invoices, the System will split in two the customer line items.

Mauri

[Former Member · Accepted solution]

Hi Mauri,

I've checked in the BSEG table, and it showed the XREF1, XREF2 and XREF3 are empty for the payment document I made.

Is it because we use F-28 to make incoming payment, hence, these fields are not populated.

regards,

Abraham

[former_member207607 · Accepted solution]

Dear Abraham,

the BSEG-XREF1,2,3 to be filled are the invoices' ones not the payment ones. If these fields contain different values that the payment will be splitted in more customer line items.

Mauri

[Former Member · Accepted solution]

Hi Mauri,

I managed to solve it by choosing different field i.e. the assignment field, ZUONR as the clearing rule field, which consists the invoice number.  Therefore, once the system detected value changes in this field, it posted to a separate line.

Thank you so much, Mauri

Regards,

Abraham

[former_member207607 · Accepted solution]

No problem, Abraham. I'm happy that You find the solution.

Have a nice day.

Mauri