HI
Can the general ledger transction report have display of balance after every txn.
No it does not
Are you looking to add this as an idea - what would the business case for doing so be?
I don’t think it would be very useful - you could always export the report to Excel for example and add a running balance if that’s what you need
copy from ledger to xls sheet does not work proper. it did not work google sheet and also msoffice on web
In v20.7.25 both options ‘Copy to clipboard’ and ‘Export’ work well. The only improvement could be copying the dates into a separate column.
@Partha, it is not clear what you are complaining about., the design of the General Ledger Transactions report or your inability to paste exported TSV files into spreadsheets. Please limit your posts to one subject in a thread.
HI,
GL txn report when copied to clipboard and pasted to xls sheet, it does not work proper. I have latest version, still it is not getting pasted as a table
This is not helpful. How does it “not work proper?” I just tried this and its works perfectly. All I need to do to have a perfectly formatted spreadsheet is adjust one column width. Any difficulty you are having is almost certainly the result of your spreadsheet settings or pasting options.
I think he wants to have the details on the description pasted into separate columns but it isn’t clear from his comments as he is not being specific in how it is not working properly
You can easily do this in Excel using the Text to Columns feature
Hi,
Sorry, it is pasting all data in one line. if it paste in mutlipe row, i can do text to column. copy and paste works perfect in balance sheet. incidently
Can you illustrate what you mean with a screen shot?
When I export the G/L Transaction Report I get
Select what I want to export
Copy and paste in Excel
Change column width
Ready for Text to Column
1 Like
@Joe91’s example is exactly what I get, too. If you use Copy to Clipboard instead of Export, even the font sizes are preserved.
Hi,
One again sorry. i was using copy to clipboard. i tried now export. it is working fine. Any how thanks for prompt response guys.
use “Paste special…”
It will then give you several options.
The other options work better than the default
Failing that, browser extensions such as listed here provide greater flexibility again