RE:[sap-acct] ECCS_upload data from excel file
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by MASAHIKO KOHSO on Feb 28 at 10:07 PM |  Mark as helpful |
CXCC
[Dialog box]
Dimension
Cons Chart of Acc
[Header]
Version
Fiscal Year
Period
Ledger
[Data line]
Cons Unit
FS item
Sub category
Partner CU
Trans Curr
Trans Amount
Local Curr Amount
Group Curr Amount
!! You assign fields from bottom to each role above (Dialog box, Header, Data line)!!
!! Sorry. This website removed spaces, and ruined my intended layout. !!
!! You would see the layout in the [file looks like]. Rgds, M!!
---------------Original Message---------------
From: hanglt
Sent: Thursday, February 25, 2010 11:24 PM
Subject: ECCS_upload data from excel file
> Hi experts,
>
> My customers use ECCS to consolidate financial statement. The basic information: dimension Company, version 100. There are 3 companies using SAP and 5 others do not use SAP.
>
> With Non-SAP company, I upload trial balances from excel files. Any one have knowledge and experience in upload data from excel file in ECCS, please share with me. What must I do to create from in Configuration, what Tcode used for upload data and how is the fomat of excel file must be consistency with form in the system?
>
> This is urgent issue. Please help!
>
> Thanks in advance.
__.____._ [Dialog box]
Dimension
Cons Chart of Acc
[Header]
Version
Fiscal Year
Period
Ledger
[Data line]
Cons Unit
FS item
Sub category
Partner CU
Trans Curr
Trans Amount
Local Curr Amount
Group Curr Amount
!! You assign fields from bottom to each role above (Dialog box, Header, Data line)!!
!! Sorry. This website removed spaces, and ruined my intended layout. !!
!! You would see the layout in the [file looks like]. Rgds, M!!
---------------Original Message---------------
From: hanglt
Sent: Thursday, February 25, 2010 11:24 PM
Subject: ECCS_upload data from excel file
> Hi experts,
>
> My customers use ECCS to consolidate financial statement. The basic information: dimension Company, version 100. There are 3 companies using SAP and 5 others do not use SAP.
>
> With Non-SAP company, I upload trial balances from excel files. Any one have knowledge and experience in upload data from excel file in ECCS, please share with me. What must I do to create from in Configuration, what Tcode used for upload data and how is the fomat of excel file must be consistency with form in the system?
>
> This is urgent issue. Please help!
>
> Thanks in advance.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
MASAHIKO KOHSOSAP Accounting Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
