from what i recall @Beau it depends on the transaction type you're on - e.g. payments/deposits use a different join than sales orders - not sure exactly which type uses which

Thanks…I’m filtering the Transaction search on Sales Orders and Invoices. I am doing a series of joins comparing customer price levels to the sales orders price levels and I get 9027 results when filtering on

Customer (Main Line)

pricelevel vs 9025 results filtering on

Customer/Job

pricelevel