Hi all, I am currently working on a query to compare Sales vs A/R Invoice. I am trying to add in both a column for Sales Order Total and A/R Invoice Total. I managed to get the Sales Order Total working but when I try to add in T3.[DocTotal] as 'A/...

Hi all, I'm new to SQL and I managed to create a Sales Order vs AR Invoice query. However, when I try to include the Items Group Code into the query, it tells me that the multi-part identifier "T6.ItmsGrpCod' could not be bound. This is the code I...