S4/HANA Cloud: Enable Totals in the Accompanying Sheet Form (Netherlands)
In this blog I would like to demonstrate to you how you can make use of the calculation fields and subtotals in the output of the payment accompanying sheet.
This feature is only localized for the Netherlands, and it will not be automatically available in your system as of SAP S/4HANA Cloud 2208.1 but requires that you activate the feature The Netherlands: Allow to use totals in Accompanying Sheet (FTGL_500683).
You can use all the fields under ‘CalculationFields’ and ‘Subtotal’ in your custom template as a source in Data Binding. When you map the fields, they are filled with the relevant data in the output. You can add fields, such as the number of transactions (‘NumberDebits’) and the overall amount (‘TotalDebit’).
Add New Fields to Accompanying Sheet Form
To add new fields, we first need to download the form template to our workstation:
Open the Manage Form Templates App and search for FIN_FO_PAYM_HASH_NL_ACCSHT.
Download the form to your workstation together with a master form APOC_DEMO_FORM_MASTER_XX (XX represents country version).
Open the .xdp file of the Accompanying Sheet form in the Adobe LifeCycle Designer.
Add new fields which will be mapped using Data Binding to any of the fields from among Calculation Fields or Totals.
Save your changes.
Create New Form in the Customer Namespace
Return to Manage Form Templates app and create a new form with the same properties as the standard one FIN_FO_PAYM_HASH_NL_ACCSHT but in the customer namespace.
Upload the updated .xdp file save it.
Then go to the Manage Your Solution app to the SSCUI 102313 and add the new form.
It must be added as an Accompanying Sheet form.
Then go to Output Parameter Determination and map the new form as per your requirement (paying company code, house bank, country, currency, etc.).
Testing the Solution
In this example we have added two new fields – Number of Items and Total Amount in Local Currency. We will create a new payment run with several payments.
We will observe the number of payments and total amount (foreign and local currencies are the same here).
We will review the generated accompanying sheet and see that the data is correct.
Read more about the accompanying sheet in this blog post.
Do you have any further comments regarding this topic? Do not hesitate to share them in the comment section below. You are also welcome to ask any questions about SAP S4/HANA Finance in the Community Q&A section.