Set Customer Bill To location priamry flag

Hi,

There are 1910 Customer accounts in our system.  They each only has one Bill To location where the primary flag is not checked. This caused issue when the business users enter receipt manually, the location field cannot be populated. They have to go to Customer screen to check the primary flag on Bill to location and save, then the location field on receipt screen will be filled up.

Can you recommend a simple easy way to programmatically update the primary flag for the Bill To locations? We identified them in hz_cust_site_uses_all table.

Thanks,

Cathy