Skip to Content
author's profile photo Former Member
Former Member

IC reconciliation process with file import

Hello gurus,

I am using ERP 6.0 with new GL active.

I want to implement the new IC reconciliation process and I don't have any problem with customizing (I have followed OSS note #863630 documentation...) except for the file import option (probably method RCOMP_UPLOAD ?).

Have any of you already implemented this process with the file import option? If yes could you help me finding documentation, give me some clues about the customizing/developement logic of this option?

Thank you in advance for your help,

Best regards,

Pascal MORIZUR

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 23, 2008 at 02:04 PM

    Hello Pascal,

    What would you like to know?

    Here is the minimum setup that is required in order to upload data for a company:

    1. In Companies to be Reconciled select Data Source File Upload.

    2. Specify DDIC Structure for Upload. You can use the delivered structure FBICRC_S_UPLOAD. For more information please refer to the F1 help for this field.

    3. Run Data Selection for that company. You will be able to select the file from your computer.

    Notes

    1. Make sure to apply the corrections according to note 1154899.

    2. If you would like to upload files without having to select them in a dialog, use the Logical File Name in activity Companies to be Reconciled. Check Upload from Presentation Server if applicable.

    3. Any lines with * as the first character will be skipped during upload. You can use this to set up a header line in the upload file.

    4. You should use the same Sequential Number (SEQNR) in Companies to be Reconciled for all companies with the same data source. That way you can run data selection for a specific data source.

    Some Advice Regarding Microsoft Excel

    If you want to use Microsoft Excel to edit or create the upload files you should keep the following hints in mind:

    1. The easiest way to deal with leading zeros is to set the cell format for the corresponding columns to Custom: Select the column, press Ctrl+1, choose Category Custom, type in n times zero depending on the length of the field (6 times for company and partner, 10 times for document number and accounts numbers). That way you do need to type in '000001.

    2. Make sure to save the file as text tab delimited. Tabs are the delimiters expected by the standard functionality.

    If the standard upload functionality should for some reason not cover your requirements you can check Select Data Using BADI and implement your own logic. The method which will be called up is IF_EX_FB_ICRC_nnn->SUPPLY_OTHER_DATA. You can use CL_IM_FB_ICRC_001->RCOMP_UPLOAD as a template for your own logic. Please note that the standard upload functionality was added later on. In most cases you will not need to implement the BADI method. The logic for the standard upload functionality is implemented in CL_FBICRC_SERVICES->UPLOAD_DATA.

    Hope this helps,

    Ralph

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.