scotto72
Member
I've checked the archives and come up with not a lot of information, and am looking for some recommendations.
We have some very "interesting" situations in our financial tables (F0011/F0411/F0413/F0414/F0902/F0911) and I am working on developing some SQL (MS-SQL 7.0) level scripts to do independant integrities as opposed to the standard JDE level integrities. Has anyone ever done this before and have some recommendations? Not being a SQL guru (yet, but after this project I will be!) some of the table joins and process flows are a bit "circuitous" to put it mildly in terms of how tables get updated as the transactions flow through the vouchering process all the way through the check run/post. Any help is greatly appreciated.
TIA! (Thanks in advance!)
- Scotto
B7332 sp10.1 SQL7.0 NT 4.0 sp5
We have some very "interesting" situations in our financial tables (F0011/F0411/F0413/F0414/F0902/F0911) and I am working on developing some SQL (MS-SQL 7.0) level scripts to do independant integrities as opposed to the standard JDE level integrities. Has anyone ever done this before and have some recommendations? Not being a SQL guru (yet, but after this project I will be!) some of the table joins and process flows are a bit "circuitous" to put it mildly in terms of how tables get updated as the transactions flow through the vouchering process all the way through the check run/post. Any help is greatly appreciated.
TIA! (Thanks in advance!)
- Scotto
B7332 sp10.1 SQL7.0 NT 4.0 sp5