When joining certain tables to "Sales and Line Item Expense Details" in QuickBooks Online connections, an error occurs:
InsertData: multiple entries for column [Line Item Based Expense Detail MarkupInfo PriceLevel Ref Value]"
This can happen when joining the following tables to the "Sales and Line Item Expense Details" table:
- Purchase Order
- Vendor Credit