Yeah this one tripped me up too when I first looked at it. If you're seeing duplicate line items on your QuickBooks invoices after a sync, it's almost certainly the special characters in your SKU names — specifically &, /, and # are the big offenders.
What's happening
The FieldPulse → QuickBooks sync uses the SKU as the matching key. When QuickBooks receives a SKU with certain characters, it sanitizes them differently than FieldPulse expects on the return trip. So on the next sync, FieldPulse sees "no match" and creates a new line item. Rinse, repeat, you now have three copies of the same part on one invoice.
Symptoms
- Same part appears 2–3 times on a single invoice in QuickBooks
- Quantities look correct but line items multiplied
- Issue only happens on bi-directional sync (one-way sync is fine)
- Parts with simple alphanumeric SKUs never duplicate
Affected versions
QuickBooks Online connector 2.4.0 – 2.4.2. Fix is in 2.4.3 which dropped yesterday, so heads up if you're pinned to an older version.
Immediate fix
- In FieldPulse, go to Inventory → Parts
- Find the offending SKUs (run a report filtered by SKU containing
&,/, or#) - Replace with URL-safe equivalents:
AMP,-, or omit - Delete the duplicate line items in QuickBooks (don't void — actually delete before the invoice is sent)
- Re-run the sync from FieldPulse: Settings → Integrations → QuickBooks → Sync Now
Edge case worth noting
If you've already sent the duplicated invoice to a customer, you can't delete line items anymore. You'll need to create a credit memo in QuickBooks for the duplicate amounts, which is annoying but keeps your books clean. The underlying sync issue won't create new duplicates once the SKUs are cleaned up.
Long-term
The 2.4.3 connector now hashes SKUs before comparison instead of doing literal string matching, so this whole class of issues goes away. If you're on 2.4.3 or later and still seeing this, that's a different bug — hit me up with your connector version and I'll dig in.
Related: QuickBooks sync is creating duplicate invoices — how do I prevent this? covers the broader duplicate-invoice problem (not just line items) if that's what you're actually seeing.
