Recently we had a tax raise in Bahrain and I had to update all my inventory and non-inventory items.
I was wondering if we can have something like Find and recode to enable bulk update of tax codes without taking the risks of batch operations.
Is this possible?
Why would you do either? Obsolete tax codes should not be changed, or every line item in every transaction that ever used them will change retroactively. Make obsolete ones inactive and add new ones.
Happy new year @Tut.
About the tax codes, it’s not the tax codes. I have inactivated the old ones and created new ones and that’s that.
What I’m talking about is setting up the existing inventory and non-inventory items with the new tax code. A utility like find and recode would be perfect for this job.
I misunderstood you, @Ealfardan. I thought you wanted to do a bulk update of tax codes that had been used on old transactions involving inventory and non-inventory items. If I understand you correctly now, you want to change the default tax codes assigned to those items so future transactions will use the new codes, right?
I suspect you will not find developer support for that idea, since it is the same thing you could accomplish with Batch Update. Once you have identified the old and new UUIDs for the codes that are changing, a global search/replace in the spreadsheet accomplishes the task very quickly. That does not seem like much risk. If I was doing it, I would sort the spreadsheet by the tax code UUID to group everything together before doing the replacement. Or, at that point, after changing one item, filling down the column might even be quicker.
Technically, I don’t know what is involved with implementing your suggestion, but it seems somewhat different from Find & Recode. That feature is just moving existing ledger entries from one account to another. Your feature would be changing item definitions. Might be similar; might be different. But, in my opinion, unnecessary.
Happy New Year @Ealfardan
I support Your Idea of Find and Recode.
In india GST Rates are Changing Contunusely.
This Feature helps us to save a lot of time.
Why would you need to recode already existing transactions with new rates? The Government rates that applied on the day of the transaction should be recorded and not a new post-dated rate.
i don’t want to change on transactions but want to change in inventory masters.
This automatically happens, if anything I wish this could be controlled. If for example I change VAT 10% to VAT12% in Tax code settings everything including former payments and receipts but also Inventory items change to 12% which is incorrect giving my previous post. So there is a problem that @lubos should look into when rates change that the historical entries stay otherwise we are due far more Tax then would be the case. I do not know of any Tax authority that would collect taxes in arrears of those that were paid at the rate applicable at a particular point in time.
but This is also possible that 10% should be made inactive and new tax code For 12 % is created.
and Inventory masters are with 10% Are Updated to 12% with Find and recode feature requested by @Ealfardan .
and
in future when we sold that item then 12% tax is charged on the sale.
Indeed is complicated.
That’s how Manager is designed which is why
And also why
The new taxcodes also need to be added to the localisation so it correctly reports the new and old taxcodes (but that should be done at the jurisdiction level)
I will do that, seems good advice.