Showing results for 
Search instead for 
Did you mean: 

How to Choose the Control Account When Creating Journal Entries by Using Import from Excel feature?

0 Kudos

Hi experts,

Is it possible to select the control account we are posting when using Import from Excel? We currently use DTW in order to achieve this, but some users are struggling to handle DTW and its technical approach, so importing from Excel seems more adequate and user-friendly, let's say.

I have tried couple different Excel templates but none of them are getting the desired outcome. The result is always booking the GL set up in the Business Partner, but sometimes we have to book a different one and this process doesn't seem to offer this possibility, unless we are missing something here.

Any thoughts?

Thanks in advance!




View Entire Topic
Active Contributor


I think this is limitation of import by excel as there is only one field for BP case, so system will post to default control account of BP. However, there are two fields: Shortname and Account for JE object in DTW.

You should train your users to use DTW.

Hope this helps,

Son Tran

0 Kudos

Hi @SonTran,

We use DTW already and it works well. I just wanted to streamline this process by using "Import from Excel". It is easier for the end-users and doesn't take too much time to elaborate the templates.

Yes, it seems this is a limitation of the feature. Let's see if SAP improves it in the upcoming releases.

Thank you,