Objective and Scope

1.1. Objective of this Operation

Describe how the posting schemes will be defined and inserted in the Journal Entry Portal in SAP

How to post entries through the JE (Journal Entries) Portal.

1.2. Scope

WW

2. Definitions

See Finance Glossary:

• JE Portal - Journal Entries Portal
• CAM - Company Accounting Manager
• FAC SU - Financial Accounting Service Unit

3. Tasks description

The JE Portal tool in SAP is a tool where the user can make manual entries directly in SAP without sending a request thought the ticketing tool.

Inside the Portal, the user will find the postings schemes templates already approved to be posted.

The postings can only be performed based on the pre-approved templates. If the posting to be performed is not available in the templates there is a dedicated flow to request the creation (see 3.2).

3.1. I post a manual entry in JE Portal 

3.1.1. I post a document in SAP

I enter in transaction ZZF_POSTING_FILE and click in the button "Journal Entries Cockpit".

The following screen will appear:

With the option "Create a Journal Entry" selected, fill in the necessary fields:

Template ID :which can be chosen in the search button   If I do not know the name of the ID, I can search in Library what is the best option for my posting.

Library link:

Company Code: I insert the company code where I want to post the document.

Layout: I can save the layout I like to have and use it. otherwise, I leave it blank to view the standard layout.

Then, I press execute 

The following screen will appear. Depending on the template selected, it will appear different accounts/ number of line items/ cost centers and etc.:

Fill in with the necessary information to perform the posting. Click in "add Attachment" to upload the file to justify the entry - THIS IS MANDATORY .

Then, click in the save button , the following screen will appear:

Fill in with the posting date and document date and click in the check. It will generate your document in SAP:

3.2. I request a new posting scheme

3.2.1. I identify a new posting scheme not yet available in portal

When the user wants to post an entry not yet available in the portal, he needs to fill in the form (LINK) in order to get the approval for the new posting scheme. If FAC SU/CAM approved it, the user needs to forward the e-mail with the approval to accounting platform .

This team will create the new template in the JE Portal in SAP and it will be available in 3 days to be used.

3.2.2. I do not receive the approval for the new posting scheme

If I send an e-mail to FAC SU/CAM and do not get the approval, I can post my entry as miscellaneous posting.

At month end, all the miscellaneous posting will be analyzed to check the need of a new template or if a solution needs to implemented at the source to avoid the manual entry. 

3.4 I create a template inside Portal

3.4.1 I receive the e-mail from an user with  approval to insert in the tool

After receiving the complete information with approval, accounting platform must enter in the system the new template and also fill in the Library in google drive.

To create the template, please use the following steps:

3.4.2 I upload the template into SAP

In transaction ZZF_POSTING_FILE, Select “Create New Template”

Use the “Download Template” option if you want to extract the excel file template.

First choose the file path where you want to extract the template (local PC)

After press button 

Use the field “Filepath” to enter the directory path and the file name of the file to upload. It is also possible to use the search help to open the Explorer and select the file to upload.

The file should be in Excel format and should follow the layout of the business process table (ZFI_BUS_PROCESS):

If the posting should consider the reverse option (Accrual process through FBS1), this option should be flagged, on the header item and in dedicated field:

Run the transaction to upload the template into the business process table (ZFI_BUS_PROCESS).

To upload the information into the business process table the Excel file selected in the previous step must be closed. The following output layout will be presented:

Note: Please ensure the document type is aligned with Matrix.

Use only manual doc types.

3.4.2 I manage the tables of the templates:

Fill in “Template ID” and “Company Code” and select the option “Table_1: Business Process”

In this table it is possible to change, delete and create new templates without using the upload file:

• TemplateID should be a unique key
• One TemplateID will represent a FI Document so make sure it is accordingly (Header, Itens, document balanced,...)
• If for some reason you prefer to edit an existing template in excel format and then upload it again, you need to delete all related previously from the table)

Maintain validations in Business Validation table 

Fill in “Template ID” and “Company Code” and select the option “Table_2: Business Validations”

In this table it is possible to create customized validations that will be applicable only in this cockpit when creating a Journal Entry based on a template:

The validations can be created by “Template ID”; “Line Type”; “Item Number”; “Company Code”; “Field Name”. The available values to input should be included in the set indicated in the field “Set Name”

The sets to be used in these validations should be created using transaction GS01 and should be created for the fields to validate:

Maintain the fields that can be changed when creating a Journal Entry with a specific template in Business Fields table (ZFI_BUS_FIELDS):

In this table it is possible to define for each template which fields can be changed when processing a Journal Entry:

The fields that can be changed when creating a Journal Entry with a specific template will be defined by “Template ID”; “Line Type”; “Item Number”; “Company Code”; “Field Name”. When “Item Number is filled in with 0 it means the rule will apply to all items in the template.

Apply always the technical field name for table maintenance:

3.5 Activity Report

3.5.1 I display the entries posted

Select “Activity Reporting” and fill in the selection screen accordingly:

The documents posted within the Journal Entries Cockpit will be presented according to the following layout:

4. Approvals and Validations

Link to request form of new templates

End of document.