Tasks to be completed when documenting an operation (from creation to publication)

1. Enter the Title of the operation / page

2. Add the following Labels:

    • Scope of applicability: ww, country_accounting

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam,uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore, new_zealand, emea_transversal, apac_transversal

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)

3. Fill in all fields as described above

4. 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: Country Accounting

Responsibility area: N/A

Table of contents 


Scope


ERP


Frequency

 

References

S_ALR_87012291



Forms



Attachments




<< US - 7180 CM Manual entries over threshold >>



1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to provide instructions for the Manual entries over threshold report preparation.


1.2. Scope

This document provides information on how to perform the GL activities related to Manual entries over threshold report preparation during month end close (WD+2 and WD+4). ERP system WP1.


2. Definitions


3. Tasks description

Manual entries over threshold report is prepared each month and sent for review to CAMs on WD+2 and WD+4 (additional entries) for Co. 7180, The threshold for manual entries for KLE is 750k EUR.

3.1. WD+2 manual entries over threshold report preparation

3.1.1. Run report in SAP and save the extract

Reports are located in this folder.

Open SAP t-code S_ALR_87012291 (variant 7180_POT) →  execute the report. The report execution can take some time since there is a lot of data for this company.

Variant 7180_POT includes:

  1. Company code selection

  2. Period selection

  3. In Column Document type filter manual document type: AD, H1, SB, Z3

3.1.2. Data extraction and report preparation

  1. Export the data to Excel - List -> Export -> Spreadsheet and name it “MM.YYYY 07180 Manual entries”.

  2. In the Excel file name the tab “Raw data AD, H1, SB, Z3”.

  3. The threshold for manual entries for KLE is 750k EUR. Go to SAP t-code ZRATE and convert this amount to USD with the date - last day of the month.

ZRATE 

3.1.3. Data sorting

In Column 'O' Debit/credit amount filter the amounts above the threshold (both positive and negative amounts!). Upload extract to Google spreadsheet - apply Conditional formatting -> Filter by condition -> Is not between. Color them in different color.

  • Then filter by the color so you only have the items above the threshold. Copy and paste the data to the new tab and name it “Manual entries >$$$k USD”.
  • In the tab “Manual entries >$$$k USD” add column Comments.
  • In column B Document Number filter each document and add comments explaining the entry. You can use the previous month file to see regular entries that are usually above the threshold.
  • In order to see the full document, enter the document number in SAP t-code FB03.
  • When all the entries are explained, send an email to the CAM Diann Shiver and Letitia Lemay to inform them about the entries above the threshold.


3.2. WD+4 manual entries over threshold report preparation

3.2.1. Run report and prepare file

  1. Run the report in SAP the same way as described above. 
  2. In the file that you prepared on WD+2 create a new tab and check if there are new entries.
  3. For the additional entries create a separate tab (if any) named “Additional manual entries >$$$k” and explain them the same way as previously.
  4. Send an email to the CAM to inform about any additional entries above the threshold (if there aren’t any additional entries, inform that as well).
  5. Save report and email confirmation from CAM to Internal controls.

...


End of document.

 

  • No labels