@Tut
Thanks for the explanation, however I have many spreadsheets and all show .00 or .10. or.15 etc. I guess it doesn’t really matter except that visually its not good,
In all other reports in Manager ( P&L, BS) all numbers show OK. (.10 or .15 etc)
So I would have thought that GST would be the same, even for the sake of consistency.
That’s entirely dependent on cell formatting. In most spreadsheet applications, there are dozens of choices, as well as custom possibilities.
Please note, I am not defending Manager’s behavior in this regard. I only investigated and reported what the program does. Personally, I would have expected it to follow the number formatting preference selected by the user. But, as I said, I don’t know what New Zealand’s requirements might be, so there could be a valid reason for it to behave as it does.
Edit
I suspect Lubos is doing minimal work on the current report transformations while larger changes to the Report transformations system are being implemented.
Just updated to the latest version, and guess what. This above problem has resurfaced. ( Was all OK for a while) Amounts in GST report showing as $123.4 instead of $123.40. I notice the code as in post 12 above has now reverted to the “old” code with format:‘n2’ missing.
Is there anyway I can insert this code format:‘n2’ so as it stays.
Many thanks
Grandpa
@Patch
Hi Patch
Many thanks for your reply.
But when it comes to like the above Im completley at sea. I have no idea. I know where to find Batch update etc, but not how it works. Im pretty thick. I will probably just have to wait until the code gets fixed.
Hi Grandpa in case you purchase over seas products the NZ GST return does not reflect this the amount is supposed to be in box 13 but box 13 is not there.
Just a warning
I have seen you recommend the batch update method for a few things. It’s something I’ve never looked at or experimented with. I think I need to investigate this.