Stakeholders

Internal – FI clerks.

External – none.

Overview

An important Toolbar function that enables posting SAP documents with multiple line items or several documents at once (mass upload) using an Excel template.

Purpose

This feature makes external tools such as WinShuttle, ProcessRunner, and ZTRM redundant. 

Scope

Relevant document type for this process:   RM, AB, SA, ZL, KR, PL

Prerequisites

Insight ZAP V6.0 Onward

Procedure

In template instructions:

1. Mandatory fields in template:
   Company Code
   Document Header Text- No more than 25 characters
   Document Type
   Document Date
   Posting Date
   Currency
   Position
   Account Type- Only (D) Customer / (K) Vendor / (S) GL are acceptable
   G/L Account
   Amount- Use a negative sign for credit amounts.
2. Document Date and Posting Date (columns C & D):
   Use dot separators (DD.MM.YYYY). For other separators, set the column (cells) as “Text”.
3. Position- Each document must be renumbered (row of header data must be 1).
4. Avoid leaving blank rows between documents.
5. Base Amount-
   Should be filed only in case of ‘Tax code’ with a rate and only for items with “GL Tax Account”.
   For the Credit amount, both positive and negative values are accepted in the base amount field.
6. One-time Customer Mark with ‘X’ when relevant.

Special toolbar function – The /DPS/FI_UPLOAD_JOURNAL.

Risks

No known risks.

 

To download a sample data file click here

 

On Behalf of Dear Mr. Hezi Ozer