Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
October 2021
October 2021
Using MYOB AccountRight Premier.
When exporting report to excel, I am facing the following issues and want to change them.
Please advise how to achieve these?
1. White background
Exported excel shows white back ground. This looks nice but difficult to see line items witout any cell lines.
I guess many accountants feel same but how to change this? I tried cell formatting but could not change them.
2. Text rather than numbers
All cell informaiton was exported as text even only number cells.
Most annoying thing is negative numbers are exported as #### cr rather than simple negative numbers.
This makes difficult to manage to alter and edit as reports.
Any solutions?
Thanks for your help in advance!
Solved! Go to Solution.
October 2021
October 2021
Using MYOB AccountRight Premier.
When exporting report to excel, I am facing the following issue and want to change them.
Please share your idea?
Text rather than numbers
All cell informaiton was exported as text even only number cells.
Most annoying thing is negative numbers are exported as #### cr rather than simple negative numbers.
This makes difficult to manage to alter and edit as reports.
Any solutions?
Thanks for your help in advance!
October 2021
October 2021
Hi @EEAD , what version of Premier are you using? And what report are you running?
Version 19 created Excel output for the GL Summary report with negatives as "1234.56cr", but I think AccountRight lIve does this correctly.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
October 2021
October 2021
Hi @Mike_James ,
As you noted, I know the AccountRight lIve (v2021) can display it as negative numbers.
Since I have a couple of company file which cannot go online due to our licence, I just wanted to know any other way, but thank you!
I am sitll looking to change the background from white to none, so if you know any solution, your input is highly appreciated.
October 2021 - last edited October 2021
October 2021 - last edited October 2021
Hi @EEAD , you originally said that you wanted the cell borders back. This is an Excel setting under File, Options, Advanced, Display Options for this worksheet, and tick the option to show gridlines. You can edit the source template as before, and change then save it. You will get gridlines across all the transaction rows.
Note: Be careful to close your edited template before sending any MYOB report to Excel, or your report will appear in the actual template!
I use an Excel macro to help with changing numeric cells containing "cr" to negative numbers.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
October 2021
October 2021
Hi @Mike_James ,
Thank you again.
I believed this was special setting of the system but it was simple excel setting.
I really appreciated your input and help!
4
|
626
|
|||
1
|
171
|
|||
1
|
619
|
|||
1
|
397
|
|||
32
|
883
|