Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ChequeNo in Multiple Tables
02-08-2018, 10:05 AM, (This post was last modified: 02-08-2018, 10:10 AM by VortecCPI.)
#1
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
Reply
02-08-2018, 08:54 PM,
#2
RE: ChequeNo in Multiple Tables
This is an area that really needs sorting out as we seem to have two entities with the same name but different meanings through the code. To be honest this is at least partially my fault as I have always ignored the cheque printing functionality believing it to be obsolete. As you have pointed out in another thread this is not so and we really need to get some standardisation done. Am a bit busy right now, but if in the meantime nobody else takes up the challenge I will look at it when I get the chance.

Tim
Reply
02-08-2018, 10:02 PM,
#3
RE: ChequeNo in Multiple Tables
Thank you for your thoughts on this Tim. I was just curious...
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)