Ship To one customer but Bill To another one?

The business requirement is to Ship to Customer X but when we create the invoice, Bill To should be to a different customer i.e. Y.

I created two different Customers and then entered the Party relationship as well as customer account relationship but it does not work.

Is this possible? Any pointers here? Currently I am trying to test it by creating an AR invoice manually but I may need to do it through AutoInvoice in future as well.

Please let me know if this can be done and how?

Thanks.