David Mitchell4 said:I hear you, but I think you’re off base here. You might want to double-check which sequence number is actually being offered next. If you’ve been messing around with manual overrides... well, look, the invoice number should always be the very next one in line, regardless of whether the previous entry was a finalized sale or just a transaction.
Look, we're clearly talking past each other here. 🙂
The situation hasn't even happened yet, but I want to iron this out now so I know what my options are. This isn't about me "messing" with the software.
Let me try explaining it differently using a real-world example.
I have one web shop where everything goes through a direct bank transfer. When someone pays, I mark it as paid, and the site automatically generates an invoice—let's say 1-1-1.
Then I have a second, totally separate business with its own web shop—a different app entirely. Here, customers can pay via bank transfer or credit card.
Now, if someone pays via bank transfer on this second shop, the system also issues an invoice labeled 1-1-1 because it has no idea that the first shop already used that number, you know?
But fine, I can go into the admin panel and tweak how those invoices look if I have to.
Here’s where the third scenario hits the fan: someone pays by credit card on that second shop, and now that invoice needs to be officially reported for tax purposes. For the reporting part, let's say we use a service like Square. That's where the headache starts. From what I understand, I can't adjust the numbering or start skipping numbers within the service. I can only set the very first starting number.
So, I set the first invoice to 2-1-1... but then the next invoice on my FIRST web shop also turns out to be 2-1-1 (unless I manually change it there to 3-1-1). Then, a taxed invoice comes along that *should* be 4-1-1, but the Square service won't let me jump to 4-1-1 because the last number it recorded was 2-1-1.
Hopefully, that makes sense now.
How do I fix this mess?
Can I just register each web shop as a separate business location or assign them to different registers or payment terminals so the numbering stays separate?