Does anyone know how the Primary Bank field is calculated or where the setting resides?
Does not appear to reside in VendBank table, but it is available as a Boolean field in DMT.
I am trying to pull that field as a part of a BAQ. DJD
Hello DJ,
When I did this last year, Primary Bank was not required. I loaded the bank entries in a separate DMT and I believe the Primary was set then. This we E10 but I believe you can do the same.
Mark W.
Correct. It is not required. I am trying to find out which banks are set as primary though. Unable to find where that data is stored or how it is calculated. DJD
And you have more than one bank per supplier?
Yes. Over time some suppliers have added banks for certain remittances. Just trying to find the primary for each ACH payment method. DJD
Thank you Rick. Exactly what I was looking for (and staring right at I guess;) Thank you all. DJD
1 Like