Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Domain: 1. Enter the Domain identified in OPD matrix (for Country specific operations, Domain = Country Accounting) |
Responsibility area: 2. Enter the responsibility area described in OPD matrix ("N/A" for Country Accounting Operations) |
This procedure explain how to perform the rebate conciliation for company 4290.
4290
Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary
See Finance Glossary:
WHAT and HOW - Main content of the operation
The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.
Select the level of heading in the "Paragraph" option.
The Month 2021 ECNA Rebate Accrual 2351000000 FS10N you will rename with the reconciliation month and the three first tabs, then go to transaction FS10N with G/L account 2351000000 company code 4290 and current year.
Double click on the balance, choose the layout /REBATE 4290 and extract as it is showing below go to List → Export → then Spreadsheet.

Copy and past on tab "Month Raw FS10N 235100000" saved.
Next tab "Month 2021 Rsvd FS10N" you will copy and paste the same information from the account 235100000, however, the columns in pink have a formula you will copy and past according to each title and not paste in the column where have the formulas.

The column highlighted in yellow needs to explain the posting key 40, do a filter by post key 40 (column R) and according to doc. type description tab "Solvay Legatcy Doc Type Listing" has a list of description of each document type.
Down below, we will separate the contract customer code and customer name following the instructions below:

After that the pivot table in the first tab can be refreshed and we can start the second report.
In the file "4290 235100000 Rebate Reconciliation_Month 2021 report change the date for the current month create a new tab, the begging balance you will copy the end balance from the previous month, the payment, accrual and recls/Adjust is the information on the pivot table report "Month 2021 ECNA Rebate Accrual 2351000000 FS10N"see the screenshot below:

You will complete each section according to pivot table by business area, customer and contract after you done all the section (BA 7250, 7470, 7360 and 7280) there is a check where the variance have to be zeroed.

Screenshot the FS10N per business area and paste in the file.

...