#COE#SW01 Process Receivables view reference number

[9980000921]

On the Process Receivables app, we can see the list of open invoices by journal entry number. However, one of our company's use the reference field for the invoice number. This can be seen on the Customer Line Items App but I have checked all 50 available columns in Process Receivables > Invoice Items and none of them contain this data. This makes it difficult to know which invoice the customer is referring to.

We could use the Customer Line Items app but this doesn't show us the open value. So if an invoice is part paid we can only see the original document value.

Is it possible to add the reference column into Process Receivables and/or to see the open value in the Customer Line Items app?

Kind Regards

Nathan

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[former_member514531 · Accepted solution]

Hi Nathan,

if you want to display additional fields on the invoice view of Process Receivables, please perform the following steps:

1. Create a new field for business context FDM_INVOICE via app "Custom Fields and Logic" - The type of the field should correspond with the related data type that you want to display(Don't forget to publish the fields)

2. Implement the derivation for the additional field via BAdI UDM_COLL_ITEM_HDB - This BAdI supplies all keys of the invoices displayed on Process Receivables. You can select the necessary additional data from released CDS views and push them into the newly created fields via step "1."

3. Add the field via the layout button in app Process Receivables

Best Regards
Carsten

[9980000921 · Accepted solution]

Hi Carsten,

Thanks for the info.

However, I'm not seeing FDM_INVOICE as an option in the business context dropdown list.

Also, how can I access BAdI UDM_COLL_ITEM_HDB?

Thanks

Nathan

[Christina_WS]

Hi Nathan,

Did you already take a look at the documentation of the Custom Fields App and Custom Logic App?

Especially the information under Custom Logic should be helpful as it provides some code samples.

Best wishes
Christina

[9980000921]

Our 3rd party SAP support company is looking into this for us

[Christina_WS]

Hi Nathan,

please select the Business Context: Collections Invoice.

Here you can find the related documentation on the Help Portal:

https://help.sap.com/viewer/918bca53037f408f91a2295d04ac16bc/latest/en-US/661e71e3e087437aa2b7b4f955...

Best Regards,
Christina

[9980000921]

Hi Christina,

Thanks for your help. I have been able to create the custom field and I can see it in the Process Receivables Invoice Items screen. However, I am stuck at what needs to be entered in draft logic.

How do I get the data from column DocumentReferenceID (XBLNR_V1) in I_BillingDocument to my custom field YY1_Reference?

Kind Regards

Nathan