SAP- How to upload monthly journals

mandywsh

请问大家在工作中是怎样用excel 的 journals upload 到sap 里面的？ 过程复杂么？ 要用到什么function ？ t- code ？menu path？先谢谢咯！

everyday

text format not excel format

mandywsh

everyday 发表于 2014-9-9 18:34
text format not excel format

谢谢！ 那可不可以再详细一点， 具体要upload 是在sap里是怎样抄作的呢？ 比如要用到什么t-code ？

myABAP

Upload a Journal Entry Voucher
Overview

When you have a large number of postings to be entered that were provided by an external application or by a service provider, you can save effort by uploading a journal entry voucher from a Microsoft Excel® file.

Note
       

    Journal entry vouchers that you upload cannot post to subledgers. They can only post to G/L accounts, cost centers, project tasks, or profit centers.

    You can only upload one journal entry voucher at a time. However, a journal entry voucher can contain many line items and thus post amounts to different accounts of the general ledger and cost accounting.

    You cannot enter a different exchange rate.

Example
       

If you outsource your payroll functions to an external provider, you can use this feature to import the file sent by the provider each month containing the accumulated personnel costs for each cost center.
Prerequisites

You have installed the latest Add-In for Microsoft Excel.

Depending on your solution set up, you can do this from the Self Services Overview in the Home work center, from the Download Center in the Application and User Management work center, or from the Download link that is available directly on the user interface.
Process Flow

In the General Ledger work center, Journal Entry Vouchers view, click  New  > Journal Entry Voucher from Microsoft Excel®. Then follow the procedure below.

Get the Template

    Select the template.

    Choose the template in the required language and click Download.

    Note
           

    You can choose any language that you have selected during scoping. If you have selected only one language during scoping, you will not get a selection of language versions to choose from.

    Decide what you want to do with the template. Choose one of the following options:

        If you want to use the template only once, you can open the template without saving it. Click Open.

        If you want to save the template so that you can use it again, choose a location to save the file to, enter an appropriate file name, and click Save. Then click Open.

Note
       

If you have previously downloaded and saved this template on your computer, navigate to the location where you have saved the template, and open it.

Log on to the solution from Microsoft Excel

    In the SAP Add-In ribbon in Microsoft Excel, click Logon.

    Note
           

    If the SAP Add-In ribbon is not displayed, check to make sure that the Add-In for Microsoft Excel has been installed correctly (see Prerequisites in this document).

    A dialog box opens where you can enter the logon details. The system URL is proposed automatically. The system URL is the URL of the system that you are working with.

    Enter your user ID and your password, and click Logon.

    Note
           

    After initial logon to the system, the ribbon text is changed from SAP Add-In to the name of your solution.

Enter Details in the Microsoft Excel Template

Note
       

Note the following:

    The Microsoft Excel template is presented with a number of rows where you can enter or copy your data. If you need more, add the number of rows you need before you start entering or copying your data.

    Ensure that mandatory fields (those marked with an asterisk) are filled.

    To help you fill in the details:

        Some fields have dropdown lists.

        In some fields you can search the system for data, for example, countries. Place the cursor on the field, and click Lookup in your solution's tool bar or ribbon to search the system. A search field is available in the Lookup dialog box that appears. When you start to type text in the search field, the relevant entries are filtered in the ID and Description columns, meaning that you do not have to scroll through the whole list. If the Lookup button is not active in the ribbon or toolbar, then it is not possible to perform a search.

Note
       

The Offset Posting Date field is only uploaded if the journal entry type is Manual Posting – JEV with Offset Entry.

To post the journal entry voucher, click Save Data To.

Caution
       

A new journal entry voucher is posted with each successful upload. If you post a journal entry voucher by mistake, you can reverse it in the Journal Entry Vouchers view.

han020573

都是从Excel 保存成TXT 文件，然后再上传。
不比纠结什么T-Code， code非常多，有几个标准的Code，每个公司用的都不太一样。很多都是为客户量身设计的。
原理都差不多。 FI-GL的 loading 不复杂，

mandywsh

han020573 发表于 2014-9-9 20:46
都是从Excel 保存成TXT 文件，然后再上传。
不比纠结什么T-Code， code非常多，有几个标准的Code，每个公司 ...

  好的！ 谢谢解疑 ！！

mandywsh

myABAP 发表于 2014-9-9 20:30
Upload a Journal Entry Voucher
Overview

看起来有点复杂，hehe 还是谢谢你。