Forum Discussion

DeannaK's avatar
DeannaK
Trusted Cover User
5 years ago
Solved

Balance sheet level 3 & 4 report not displaying all numbers.

I am trying to generate a Balance Sheet at level 3 detail.  The Totals in the far right column (the 3rd column) are not displaying properly.  They are actually only showing the digits of the cents.  So where the number "$8,761,333.68" should be, it is showing "68".  I have changed margins and changed to landscape but the numbers display the same.  I have the  same problem with level 4.  Level 1 & 2 are ok.

 

I can export the report to Excel and all the figures come across correctly, so this is my work around for the moment.

 

  • Komal_S's avatar
    Komal_S
    5 years ago

    Hi DeannaK 


    This happens as the column widths don't auto scale while displaying reports. In order to resolve it, you would have to manually adjust columns in the Insert/Modify tab each time you run the report in level 3 or 4 as shown:

     

     

    Please let me know if you have additional questions.

2 Replies

Sort By
Replies have been turned off for this discussion
  • Komal_S's avatar
    Komal_S
    MYOB Moderator
    5 years ago

    Hi DeannaK 


    This happens as the column widths don't auto scale while displaying reports. In order to resolve it, you would have to manually adjust columns in the Insert/Modify tab each time you run the report in level 3 or 4 as shown:

     

     

    Please let me know if you have additional questions.

    • DeannaK's avatar
      DeannaK
      Trusted Cover User
      5 years ago

      Thank you Komal_S ,

       

      I went in to the balance sheet report and can see where to adjust the column widths, as you described.

      Of course today all of the numbers are fitting & displaying perfectly so there is not problem!

       

      I will remember the column width adjustment for the future.