ChequeNo in Multiple Tables
Not really a problem except in the sense of DB normalization...
I see we have added ChequeNo to other Trans tables when we already have that field in GLTrans table. I changed my code to write check numbers to the GL Trans table during Payments because I was unaware of this new development.
Am I correct in assuming these new ChequeNo fields are added because our payment check numbers are from one contiguous incrementing set while receipt check numbers could be just about anything, including identical numbers from different customers?
Just a little curious...
https://www.linkedin.com/in/eclipsepaulbecker
|