I worked it out and now my Inventory Purchase Screen is working better than ever! Yay!
Anyway, I was doing some more testing having to do with Account Statements and the Account Balances.
Some of the Balances looked a little funky after conversion, so I pulled up some Tickets like this one:
The issue is rather obvious… the Discount applied via Order Tag is far too high, which makes the Ticket Total NEGATIVE. A converted value might be 0.50 USD for 10 HNL.
So… now I need to find a way to update those Tag Values, which are in JSON. Thankfully, I am using SQL 2016 which has some support for JSON fields so I hope it won’t be too much of a problem.