I can’t seem to find the primary bill to field(actually a checkbox) in the table CustCnt - loading with data dictionary viewer. Or perhaps it is in a different table?
Try custbillto.defaultbillto which is defined as “Indicates whether this Alt Bill To is the default record or not”. I quickly searched the data dictionary and this was the only result that looked like what you were looking for.
I am interested in the contact marked as the bill to. The table you mentioned I believe looks at the customer record. I want to reference the bill to checkbox in my SSRS report.
I found it in the Customer table yah! Thanks for responding.
3 Likes