Billing customers

[Igor_XH]

Hi All

I need to issue invoices to customers who placed orders in the current month. And I need to add each invoice to invoice table.

Ok. I know how to create invoice for a customer. And I know how to create a slice with customers who placed orders in the month

But how to iterate over all customers and invoice for each?

[WillowMobileSys]

You want to use the IN() function.   In english ... Get the list of Customers where the Customer ID is in the list of Customer who have invoices for the month.

An example expression might be:

SELECT(Customers[Customer ID], IN([Customer ID],  Slice Customer Orders[Customer Ref]))

Article for IN() Function

https://help.appsheet.com/en/articles/2357277-in

I hope this helps!