We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Journal Entry Export in Excel - 2 lines

Accepted answer
51
Views
19
Comments
edited Jan 30, 2019 4:30PM in General Ledger & Intercompany 19 comments

Summary

Journal entry export to excel is not exported properly 2 lines for every line due to regional information

Content

When we export a journal entry in excel we get for every journal entry lines 2 lines: in excel those 2 lines are merged

The users are complaining about this as when they to perform filter or pivot table it's almost impossible as you need to cleanup the file before

One line is for the account details (account combination) and the other line for regional information

Is there a way to get rid of the regional information in the export and in the web form (I can also expand the line with the arrow) and I see the regional information. I have tried to customized the web form but did not get to it?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!