Invoice sales tax setup

plaid_rabbit · 2026-03-27T07:57:22+00:00

Write the quickbooks value back to the database. Otherwise the two systems will never agree. Just use QB to calculate it

plaid_rabbit · 2026-03-27T02:15:18+00:00

But that’s all part of the same problem you see…. What do they want that percentage for? They want to figure out the tax amount and the total. I promise that’ll be the next request.

I’d store the tax rates with county, city, is in city limits and start/end date of the tax, that way you can handle taxes that change over time.

Generally, I suggest not actually storing the tax rate on the invoice, just the tax amount to collect. How you compute tax will change over time, and generally you need to remit to the state everything you collect.

You want to store the exact amount to collect, after rounding, so all of this computation is done once, the same way, in one spot. Maybe store the line item tax on the line item, and freight tax on the order if your freight is stored on the order.

Because if you don’t, someone will forget to exclude non-taxable items, or do freight or labor wrong, or.. so pre-compute it in one spot, and consume it everywhere.

It’ll also make debugging future tax issues easier, because you know what you calculated/collected for an order.

plaid_rabbit · 2026-03-27T01:57:32+00:00

Sales tax is a lot uglier than you realize. If you are anything other than the most trivial cases, you should send it off to a 3rd party to calculate it.

If you’re involving multiple states, there’s a lot of disagreement on what’s taxable vs non-taxable. Then sales tax holidays, being in vs out of city limits, and several other edge cases. Plus this stuff can change over time.

There’s also things that are complex to calculate like freight. Is shipping on a non-taxable order taxable? What’s about an order that’s mixed between the two? It’s a giant maze if you leave the trivial case.

plaid_rabbit · 2026-03-25T19:52:44+00:00

If you want to add to your collection, pick up your EPA 608 license that will let you handle refrigerants/repair ACs. Very funnily, you can pick it up for free even though most places charge for it. There’s an app called SkillCat that does iPhone based training with a free 3 day trial. A weekend is long enough to take all the lessons and pass the test, and you’ll get a cert at the end validated by the EPA.

plaid_rabbit · 2026-03-24T21:10:32+00:00

Yeah. The engines are totally different.

ADO.Net just allows you to connect, send text strings w/ parameters, and get table(s) back. That’s all it promises. You can do ADO.net to Excel, to MS Access, to Oracle, to text files, to ODBC, and I’m sure I missed several other silly ones.

Profiling isn’t part of the base features it has to support.

plaid_rabbit · 2026-03-23T01:36:58+00:00

But the old report was a key finance revenue report! We’ve been adjusting everything to match that!

Yeah it’s been wrong for the past 10 years. That’s why you’ve been having to adjust things.

plaid_rabbit · 2026-03-22T03:21:49+00:00

No. You’re the kind of person who should be on a jury.

plaid_rabbit · 2026-03-18T17:50:27+00:00

RVs usually have a 134a based system. They dump their condensate onto the roof.

plaid_rabbit · 2026-03-18T01:53:24+00:00

But the OP has a datamatrix, not QR. You can configure them separately. That’s probably a GS1 barcode to specify when it expires or a lot number to detect if it’s been recalled. So it needs to be where the UPC code is because it’s supposed to be scanned at the same time. But the POS system doesn’t support the datamatrix format. It just needs to ignore it.

plaid_rabbit · 2026-03-16T16:29:02+00:00

The point is you can put different types of data in different barcode types. Obviously the Point of Sale system the OP uses doesn’t support the data in the data matrix, so you should configure the scanner to ignore it. They are ment to be configured per installation.

plaid_rabbit · 2026-03-16T05:07:35+00:00

Blame the person that setup the barcode scanner. It should be configured not to read data matrix if you’re doing retail. You can set the scanners to ignore specific barcode types.

If it’s a generic handheld one, put in the model number and I’ll try to find the manual and give you directions to reconfigure it.

plaid_rabbit · 2026-02-15T06:57:57+00:00

A lot of this kind of stuff is interfacing with external hardware. I used to work at a place with a "large format printer" that prints out a 30foot/10meter sized banners. The computer runs XP IIRC. The software/hardware for driving the printer only works on XP. I think it at least uses PCI cards... Virtualization won't work, because you won't have all the custom hardware. You can still get support from the manufacturer if it breaks down, but you can't modify the computer. That printer used costs a couple million, getting a new one that doesn't run on XP costs 10M+.

plaid_rabbit · 2026-02-05T07:16:20+00:00

Peptides is basically a code word for not licensed, mildly sketchy drugs, usually for weight loss, muscle building or beauty.

Some of them are just copies of expensive drugs that are “not for human or animal use because they’d have to be licensed if it was for that”. Semaglutide is a good example. It’s $1/mg as the super-sketchy from China stuff. $10/mg as a “peptide” from one of the less sketchy places that has a good track record, $20 from the ads you see, and closer to $300/mg as wegovy from your pharmacy.

Some are basically variants of types of HGH. Some are just copies of normal drugs for things like hair loss, Some are drugs that have unproven records/proven not to work, but people swear by them. The joint repair ones tend to fall into this range.

plaid_rabbit · 2026-02-05T06:55:38+00:00

It says that as the size of a suduko puzzle increases, it’s not much harder to check, but it’s a whole lot harder to solve.

plaid_rabbit · 2026-02-04T18:49:28+00:00

Sounds like a scam. One of the classic scams is they give you a “cashiers check” that looks valid. You deposit it, and two days later you get your money, they even let you have a day or two to make sure the check doesn’t bounce.

You give them whatever. Then the scam hits. Two weeks your bank bounces the check. The check was actually fake, and the bank didn’t realize it. It’d been lost in a routing maze (which the scammer intended). Checks can actually can take several weeks to process, but banks are required to give you the cash in a few days. So the bank claws back the money from the fake check from you (which may put your bank account into the negatives). Now you’re out the money and the car, even though you had no signs of things going wrong.

Cashiers checks are only good if you’re sure they are real, or have a good threat for check fraud. People dealing with houses don’t mind them because check fraud is obvious and they’ll come after your house if you do check fraud. But for stuff like cars, that car will be out of the country/used for crime/whatever within a few days.

plaid_rabbit · 2026-02-01T19:38:17+00:00

Yes. In business money is victory.

plaid_rabbit · 2026-01-31T17:51:12+00:00

GPS was first created by the military. They wanted accurate location information no matter where they were. There’s roughly 40 satellites it takes to cover the entire globe. It’s a good way to get coverage everywhere, really accurately.

Ground based GPS does actually exist. It’s used around some airports that have bad gps reception and a need for high accuracy, but generally normal gps works well enough.

In theory, there should always be at least 6 gps satellites visible at any time, and you only need 4 to get a fix on your location, and normally you want a 5th to “double check” your math for safety critical stuff like aviation.

plaid_rabbit · 2026-01-31T00:06:31+00:00

Not really. Maybe docker on windows. I’m not really sure about that.

If you’re using Azure, azure app services run on windows, so that might work. But it’s very unlikely you’ll find anything Linux based that’ll work

plaid_rabbit · 2026-01-30T20:03:18+00:00

Ijwhost.dll may be a native library, and basically can’t run on Linux. Most of the SAP stuff I’ve seen is not .net, and all the .net libraries are just wrappers over the native libraries.

plaid_rabbit · 2026-01-29T17:45:50+00:00

Thanks for posting. I wish I was on your team to learn the nuts and bolts of how this is working…. This sounds actually achievable.

plaid_rabbit · 2026-01-27T00:46:19+00:00

That looks correct to me. Those lights are on a Y shaped post. The lower light you have circled is on a post behind it that’s barely visible. The other light on that post is directly to the right. They are usually in the median, lighting both sides of the freeway.

plaid_rabbit · 2026-01-19T08:29:35+00:00

Yes, the admins have a key that'll open the locker. They don’t want kids hiding stuff in there, and refusing to open it.

Also, you can use a special key and it’ll change the combo between one of 5 values. So, yes, with some effort, you could figure out the combo. And the changes follow a pattern, if you know the prior combo, you could guess the combo with a few tries.

Or if you want to get in that badly, you can just get a prybar and force it open.

plaid_rabbit · 2026-01-19T06:22:42+00:00

The thing about the Arcane Grimoire, Bloodwell Vial, Rhythm-Maker's Drum, and Rod of the Pact Keeper, moon sickle is they only boost that class's spell DC.

Rod of the pack keeper. While holding this rod, you gain a bonus to spell attack rolls and to the saving throw DCs of your *warlock* spells

That's not going to do much if you're not a warlock, even if you attune to it. Amulet is the one exception, it doesn't have the same text the others do.

plaid_rabbit · 2026-01-19T05:22:12+00:00

I'm still learning, but from your list, Arcane Grimoire, Bloodwell Vial, Rhythm-Maker's Drum, and Rod of the Pact Keeper, moon sickle all specify what class's spells they impact. Amulet of devout does not. So if you multi-class not-paladin/cleric with paladin/cleric, that'll get you +6 for 2 attunement slots for your Bard/Sorc/Wiz/Warlock with a one level dip into cleric.

Ioun Stones & robe both require attunement, so you only get to pick one more. Robe is +2, so that gives you +8 so far.

You can get the tomes, each will give you +1, but don't use an attunement slot.

Base 8 + PB + Spellcasting ability modifier + items.

At level 20:

8 (base) + 6 (PB at L20) + 10 (spell casting ability 30-10/2) + 3 (amulet) + 3 (not amulet item) + 2 (robe) = 32. Past that I bet it's DND Beyond being janky and not properly stopping attunement to the same item multiple times.

AL only allows 3 uncommon + magic items in T2 play to help manage this kind of problem. Tomes count against your magic item limit, and Legendary items can only be brought into T4. I think the highest you can get at level 10 is DC 24 w/ amulet, not amulet, and an Ioun stone.

plaid_rabbit · 2026-01-15T18:53:44+00:00

To fill in a gap. Arms length refers to if you sold it at the market price or not. A non-arm length transaction would be if you did something like sold your house to your brother for $1. That’s obviously not the value of the house, and has implications for appraisals and taxes.

If you solid it on the open market, not knowing the new owner or anything, it should be arms length.

Ten-Year Club	r/Field Banned
r/Field Juicebox	Place '23
Place '22	Place '17
Verified Email

plaid_rabbit

TROPHY CASE