cancel
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?

felipeprevente
Explorer
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!

felipeteodoro_1-1709033374412.png

 

 

View Entire Topic
Johan_H
Active Contributor

Hi,

To my understanding you would have to set the 'Account Type' column to 'GL', and set the desired control account in the 'Account Code/BP Code' column:

Johan_H_0-1709036160418.png

Regards,

Johan

felipeprevente
Explorer
0 Kudos

Hi Johan,

Thanks for your suggestion.

As long as you are posting to a Control Account, you must pass the BP code to the system. If you are informing a BP code, you have to set the account type as BP, then, in the Account Code/BP Code field is expected you inform the BP code. The way you suggested, the system will always return an error message, as you are setting the type as GL. I think it is a three-way match here: Type = BP, the BP Code and the Control Account (pass the GL). The latter is missing here I suppose and I couldn't find it available in the template. Hope it makes sense.

felipeteodoro_0-1709043029794.png

Johan_H
Active Contributor
0 Kudos

I must admit that I do not know enough about accounting to understand what it is you are trying to achieve, and how it should be done. So I will just think some thoughts out loud.

  • The journal entry that you are trying to create would look something this(?):
    Johan_H_1-1709101324132.png
    In the template there is the 'Record Type' column. Your import file would have 2 or more rows, with 'Record Type' L. The first row with the BP code and 'Account Type' BP, and other rows with Account Type GL and the desired accounts, that just happen to be control accounts.

 

felipeprevente
Explorer
0 Kudos

@Johan_H,

When using the SAP client or even DTW, we are able to choose the Control Account where the BP will be booked.

felipeteodoro_0-1709118307228.png

See in the screenshot above. Once you select the BP Code, SAP retrieves the default Control Account set up in the BP Master Data on "Accounts Receivable". On the JE second row, we are crediting the same BP, but using a different control account instead. This is widely used when transferring balances between two control accounts. Another business case is when your accounting has different control accounts to accommodate different transactions, so your Loan postings will be booked in a different account than your Receivables, even when the BP is the same. So the same Business Partner may hold different balances, for different purposes.

felipeteodoro_1-1709119422716.png

felipeteodoro_2-1709119623555.png

Basically, the issue is that Import from Excel feature doesn't seem to give the option of changing the control account to be posted, as I've demonstrated above from the GUI.

I hope it makes sense.

Felipe