0
0 Comments

Hi Eric,

Hope you are well.

I have created a query that performs an inner join between Customer and Sales Header.

The idea is to retrieve the last time a customer placed an order via API.

I have selected No. and Name of the customer:

And the Order date for the Sales Header with aggregation

When I try to publish, I always get the following error:

Even selecting 2 fields on Customer and 1 field on Sales Header.

Can you advise on what else is required?

Best Regards,

Diego Lother

hougaard Answered question May 14, 2025