when i print a report the open balance is net while the amount is gross. How do I fix it so both figures are gross

  • 1
  • Question
  • Updated 11 months ago
  • Answered
Photo of Suzanne Khouri

Suzanne Khouri

  • 362 Points 250 badge 2x thumb

Posted 11 months ago

  • 1
Photo of John G

John G, Information Support Analyst

  • 25,360 Points 20k badge 2x thumb
Hello Suzanne,

Thanks for asking.

I've looked at a couple of reports and noticed that the Open Balance field is coded to show either Net or Gross on that report regardless of your Reporting and Tax preferences.  Unless the column in the report is coded to respond to preferences then you will not be able to change its display.  Your only 


regards,
John.
Photo of Suzanne Khouri

Suzanne Khouri

  • 362 Points 250 badge 2x thumb
Hi John. Thankyou for replying but I didn't receive your full reply.  I can only see up to the third line an then it cuts off. Can you please send it again.
Photo of John G

John G, Information Support Analyst

  • 25,360 Points 20k badge 2x thumb
Sorry Suzanne, here it is again....

I've looked at a couple of reports and noticed that the Open Balance field is coded to show either Net or Gross on that report regardless of your Reporting and Tax preferences.  Unless the column in the report is coded to respond to preferences then you will not be able to change its display.  Your only workaround is to find a report that displays the Open Balance as Gross and customise it to show what you are after (most reports display Open Balance as Net).

regards,
John
Photo of Suzanne Khouri

Suzanne Khouri

  • 362 Points 250 badge 2x thumb
Thankyou so much for your response John.  I have spent countless hours on the phone to technical support who haven't been able to explain this.  Do you have much experience dealing with accounts in the building industry? I'm asking for future professional advice.
Photo of Brendon Gardiner

Brendon Gardiner, Accredited Partner

  • 494 Points 250 badge 2x thumb
Hi Suzanne, I am an Accredited Partner and Accountant and have extensive experience in the building industry.   What report are you looking at?     Please contact me on 07 3040 0488 if I can be of assistance
Photo of John G

John G, Information Support Analyst

  • 25,360 Points 20k badge 2x thumb
Hi Suzanne,

Glad to help.

I hope we are pretty good in helping users get over their technical problems with the programme, but the interesting bits of accounting and industry-specific issues are not really in our domain.  We have a Partner Programme of bookkeepers and accountants who do bring the two together.  I've put a notice on their board that you have an interest in the building industry so at some time in the future you may get a post here from a partner willing to extend their services to you.  You can always look for a Partner on their search page.


regards,
John.