Invoice reference/ Payment reference from contract

[HenrikeGroetecke]

Hi, 

We are using App: Create Invoice for rent  when we will generate out customer invoice, we choose Selection type: Only items from FI documents. And later this will be send to customer. 

But we have 2 question:

1. What is the best practise to use for customer invoice:  Invoice reference Or Payment reference for this kind of document? So we get the right flow from invoice to payment. 

If I look in the app Manage Customer Line items, the field Payment reference is empty. Why? 

And I can see that Invoice reference is same as Journal entry, so this number restart every year right? 

2. In the form template, how we find the correct field to add for Payment reference/ Invoice reference in this data source: RE_CN_INVOICE_DE? So we can add this to the forms so the customer pay the invoice correct and we can easy handle the  incoming payment. 

/Olivia

[HenrikeGroetecke]

Hello, thank you for your question. It has been forwarded to the experts. Kind regards, Henrike

[ElenaPuica · Accepted solution]

Hello!

Recommended field for invoice-to-payment matching is Payment Reference

Invoice Reference is not relevant to this use case. Is an internal FI linkage field, blank on original invoices; only used on follow-up documents (credit memos/payments).

Payment Reference is not automatically generated for the rent invoices created via RE-FX "Create Invoice" because payment reference generation is not activated for this posting flow.

• If classic FI-AR: Payment Reference generation is controlled at the document type/output level (structured reference number generation), not the FI-CA "Payment Reference Model" mechanism referenced earlier.
• If FI-CA: the FI-CA configuration path is the right direction.

Activate Payment Reference generation for the confirmed engine and company code/country.

Verify the field is populated on the resulting FI document, check via Manage Customer Line Items or Display Line Items in General Ledger that Payment Reference is no longer blank.

Locate the field in the form template data source RE_CN_INVOICE_DE:

If output form in use  is Adobe-based: open the predelivered template in Maintain Form Templates and inspect the Data View for the Payment Reference node.

If the field is not exposed in the standard data source, extend it to custom field enablement for the form template plus a CDS extension to populate it..

[olivia_johansson · Accepted solution]

Hi Elena,

Thanks for your help!
I don´t understand the section for If we have classic FI- AR or FI-CA? And can´t find any configuration how we can activate the payment reference for this process. 

/Olivia

[ElenaPuica · Accepted solution]

Hi Olivia, Just a small addition, to make it easier to act on. Since you're checking this in Manage Customer Line Items, that confirms you're on classic FI-AR. For FI-AR, there isn't a generic on/off switch for Payment Reference generation. It needs to be actively populated, typically via an FI Substitution at document header level, so Payment Reference gets filled automatically with the RE-FX invoice number whenever this type of document posts. (Alternative: a BAdI at posting time, if you need more contract fields.) One quick prerequisite: confirm Payment Reference isn't "suppressed" in the field status of the customer reconciliation account and posting key, otherwise it can't be written regardless of method.