webERP Forum
ChequeNo in Multiple Tables - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: ChequeNo in Multiple Tables (/showthread.php?tid=8085)



ChequeNo in Multiple Tables - VortecCPI - 02-08-2018 10:05 AM

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...


RE: ChequeNo in Multiple Tables - falkoner - 02-08-2018 08:54 PM

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


RE: ChequeNo in Multiple Tables - VortecCPI - 02-08-2018 10:02 PM

Thank you for your thoughts on this Tim. I was just curious...