Is it good to say please advise on payment date?

Yes, saying "please advise on payment date" is a polite and professional way to request information about when payment will be made. It conveys respect and consideration for the recipient's time while clearly communicating your need for an update. Just ensure that the context is appropriate and that you follow up if necessary.