General Ledger Codes printing on reports to Excel

Question

Hi there,

I used to be able to report on Balance Sheet Multi & P&L Multi to Excel including the G/L codes.    Has this been removed for some reason?   Is there a work around?

SamaraM · Answer

Hi @Debrae08

You are correct that there is the ability to add it using the advanced filters. After adding the account in the filters, you can then choose to export it to excel.

To do this:

* Open the report and click into Advanced Filters and add Account No. as an available field. 
* Click Run Report so it displays on the screen.
* Click the arrow in the top left corner and select Export then select Excel.

Hope that helps.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Debrae08 · Answer

Hi Deo

I'm not sure where you're at.  Im using Account Right & running Balance Sheet Multi Period.   I can't use the advanced filters to use the insert/Modify and add Account No,  because I want it in Excel.   the Export to Excel comes before the ability to use advanced filters.

Picture1.png

Deo1 · Answer

Try This

MYOB.1.png