Skip to Content
Product Information
Author's profile photo Sissi Ruthe

Exposing Analytical Actions to reports based on the Payables and Receivables Register

The objective of this blog post is to explain how to expose Analytical Actions to reports based on the Payables and Receivables Register.

With release 2108 it is possible to expose analytical actions to reports based on the payables and receivables register (business object FOPXD_TRPREG). You can now enable users to update an open item from a customer or supplier invoice by the following analytical actions:

  • Set dunning block
  • Remove dunning block
  • Set payment block
  • Remove payment block
  • Update payment terms

As an example, we will expose and enable these analytical actions in the Aging List for Receivables report.

As a first step you need to add the Receivables Payables Split Item field to the report. For this open the Aging List for Receivables report in the Receivables work center.

Configure the report and add the Receivables Payables Split Item field to the report.

Search for the field, select it and confirm the selection by clicking OK.

Navigate to the Business Analytics work center and open the Analytical Actions view.

Search for ‘Payables and Receivables Register’ to list down all available actions.

Select any line and click on Expose – Expose Action. It will launch the Maintain Action screen.

In the Maintain Action screen select UUID as the BO Node Key Element, Date/Time as the Timestamp Element and click on Save.

Click on the Create Navigation button to open the Maintain Navigation Action screen. Enter a Name and in the Source Report field enter the Aging List for Receivables report. By entering Receivables Payables Split Item in the Char Name field, it is mapped to the action. Click on Save and Close.

Go back to the Aging List for Receivables report and click on the + button to add the field to the report view.

Search for Receivables Payables Split Item select it and click OK.

You can now select any Receivables Payables Split Item, for example a customer invoice, and call the action from the report. Click on Execute Actions. This will open the Action popup.

Select any action to execute it.

Enter the action parameters, in this example to set a dunning block, and click on OK.

After a successful execution you can see the message “Action was executed successfully”.

This short explanation shall help you to understand Analytical Actions and how to expose them to reports based on the Payables and Receivables Register business object.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nathalie LAMPERIN
      Nathalie LAMPERIN

      Hello,

      I strictly followed this very clear procedure but I have the following message at the bottom of the report : "Objects could not be determined from selected cell"

      Any idea why I get this message ? how to solve this ? (I tried in 2 different tenants)

      Thanks in advance for your help

      Nathalie

      Author's profile photo Sissi Ruthe
      Sissi Ruthe
      Blog Post Author

      Hello Nathalie,

      without more details it is quite difficult to identify the issue. Therefore, can you please create an incident for it.

      Thanks and best regards,

      Sissi

      Author's profile photo Nathalie LAMPERIN
      Nathalie LAMPERIN

      Hello,

      We eventually received an answer from support. The Character name to be selected in the "Maintain Navigation Action" screen should be "Receivables Payables Split Item" and not "Trade Receivables Payables Item" which triggers an error message.

      Hope this helps

      Nathalie