I will have to test later what this is actually doing. It is possible if one of the variable is blank rather than zero the expression evaluation order changes.
Printing the actual variables would confirm it.
If so this could be avoided by using an if statement or possibly brackets.
correct but I dont know how to write an if statement in HTML?
I am a dummy thats what I meant .And yes I have that site booked marked to. Just not sure how to use it
{% if C12 == " " %}
{% assign C14 = C12 | minus: C13 | Format: 0.00 %}
{% elsif C12 == " " %}
{% assign C14 = C12 | minus: C13 | times: -1| Format: 0.00 %}
{% endif %}
Does that look right?? so I am saying if C12 (GST on purchases) = Blank then...... if not then out the times:-1 inFor Boolean conditions see
Truthy and falsy – Liquid template language
From which an empty or nil variable test false
When C12 in not a number, we can leave it out of the arithmetic (assuming that is why you are getting results you don’t agree with)
{% if C12 %}
{% assign C14 = C12 | minus: C13 | times: -1| Format: 0.00 %}
{% else}
{% assign C14 = C13 | Format: 0.00 %}
{% endif %}
But it is probably easier just to copy the original C12 assignment to the C14 assignment ie
{% assign C14 = taxOnPurchases[GST_15] | plus: gstOnImports %}
As I think this is what you are doing
| Report | Original | Edited |
|---|---|---|
| C5 | GST_15 TotalSales +GST_0 sales + GST_exempt TotalSales | Same |
| C6 | GST_0 TotalSales + GST_Exempt TotalSales | Same |
| C7 | GST_15 TotalSales (or C5 - C6) | Same |
| C8 | GST_15 TaxOnSales | Same |
| C10 | GST_15 TaxOnSales (or C8) | Same |
| C11 | GST_15 TotalPurchases + (GST_15_on_imports Nett_GSTinclusive ie Purchase - sales) | Same |
| C12 | GST_15 TaxOnPurchases + (GST_15_on_imports Nett_GST ie PurchaseGST - SalesGST) | GST_15 TaxOnPurchases |
| C13 | - | GST_15_on_imports Nett_GST ie PurchaseGST - SalesGST |
| C14 | C12 | GST_15 TaxOnPurchases + (GST_15_on_imports Nett_GST ie PurchaseGST - SalesGST) |
First off I really really appreciate your help.
I am editing the report in notepad+++ so I can save it back as a jason file to use for all my clients.
this is what I have
“{% assign C11 = totalPurchases[GST_15] | plus: totalImports %}”,
“{% assign C12 = taxOnPurchases[GST_15] | default: 0.00Format: 0.00 %}”,
“{% assign C13 = GSTOnImports| default: 0.00Format: 0.00 %}”,
“{% if C12 %}”,
" {% assign C14 = C12 | minus: C13 | times: -1| Format: 0.00 %}",
“{% else}”,
“{% assign C14 = taxOnPurchases[GST_15] | plus: gstOnImports %}”,
“{% endif %}”,
],
It down loads into manager fine but when I run the report it does this
I don’t believe you need to do this.
You can export the report transformation when you have it working (or prior as a backup), then they can import it.
I had a similar problem when editing the .json file with a text editor so avoid that now, and use the editor built into Manager instead.
I suspect the.json file looks like a text file but actually contains unprintable characters to delimit document structure. So using a text editor probably deletes the unprintable characters causes a parsing error when later trying to use it in Manager.
So you can I am sure that was not there when they first bought it out good will give it a try in manager
thank you will come back and let you know how I get on
I can not export the file I can not find where to export it
It was near the localisation import button. Will check later. Hopefully this feature has not been removed
But I now have it working thank you so much. Incase anyone else in NZ wants to know I edit it in manager I put
{% assign C11 = totalPurchases[GST_15] | plus: totalImports %}
{% assign C12 = taxOnPurchases[GST_15] | default: 0.00Format: 0.00 %}
{% assign C13 = GSTOnImports| default: 0.00Format: 0.00 %}
{% if C12 %}
{% assign C14 = taxOnPurchases[GST_15] | plus: gstOnImports %}
{% else%}
{% assign C14 = C13 Format: 0.00 %}
{% endif %}
No that just exports the list of localisations not the report its self
Now I some how have to change C11 because they way we put purchases bought overseas in to manager is from the over seas suppliers invoice we enter it as a purchases at 0% GST and then when the customs freight documentation comes in we enter that as a separate payment and the GST is on that and thats when we put the GST amount in @ 15% on imports. I now realise that it adds the purchases price on based off of the GST amount. I dont know why but purchase price not always the same as what the price paid from the supplier(ask customs who knows how the govt work lol) so I need to swap C11 total imports for something else. Thought I might try and make a special tax rate for the supplier and capture that so
when I enter an over seas supplier I use special rate and C11 picks it up.
If that makes sense
Ok to do that I need the field key and when you go batch up date and copy to excel it does not give you the custom Tax rates field key
Open Manger
Open a Manger window in your browser (so it shows the page address bar). How to do this varies with operating system. In windows right click on a link and choose open in a new window)
Go to the tax code page in Manger in you business
Edit the page address to add “.json” It needs to go at the right hand side but before the parameters (which results in it being towards the left hand side of the full string). Will post a picture later today.
That should show all the tax code UUID. You should see the ones already in your localisation as well as any new ones you have created
Add the new tax code to your localisation.
Actually I’m hoping to post a full guide later today
I have the desktop version so can not open in browser
And it wont work like that because when I go add the custom Tax type of GST Free in tax types the code number will be different. Unless I can some how tell it to fine the name and use its code number.
It can be done with any versions of Manger on any platform. To understand how to do it have a look at Localisation: GST/VAT worksheet programming guide - #7 by Patch (and earlier it that guide). That enables you to create tax codes to divide transaction up and then report them how ever you like.
The more important question is, what does your tax department actually require. There is a risk in doing calculations a new way, you may find the old way of calculation was actually inconsistent with your legal obligations. As I’m not a New Zealand accountant, I can’t help you with that.
Its all good Patch, I went back and double checked and total purchases does not include overseas purchases . I admit I got a little Carried away and went against what I have been trying to tell lubos 
But thanks to you I have learned a lot.
Do you know how when we load the localisation from the website it automatically puts the tax codes in are we able to do that? so it automatically loads GST free Tax code in.
anyway its all working just as it should now and I have tested with all scenarios and works and have imported the localisations into 3 different business and apart from having to set up the tax code each time it worked with each one. Not sure if you are a moderator if not you should be
I still dont understand why they still have a wrong localisation report up for New Zealand. Some poor person is going to rely on it and it is going to be wrong
