TechMonkie
New Member
Hello everyone,
I wanted to see if I could glean some information regarding an issue I'm dealing with in QAD.
I'm using CyberQuery to generate an open order report, and one of the things we'd like to include on this report is a Build Date. I believe I've found a suitable date field to use in the SOD_DET table, however the screen (which sadly is a custom screen) we're using to enter data doesn't appear to directly reference this field. As a result, I have no way to accurately determine if the data is being populated to the record in question.
The field I'm trying to modify is SOD_DET:SOD_PER_DATE. As an alternative, I could also use SOD_DET:SOD_PROMISE_DATE, as we're using neither of these fields for anything at this point. Normally when I press Ctrl+F on one of the fields in the screen we enter data into, it gives me a table.field listing showing exactly where the data is being entered into. If I do the Ctrl+F on either of these 2 specific fields (Promise Date or Performance Date), it instead gives me 'promise_date' or 'perform_date' respectively. I don't have the source code at my disposal at the moment (I have a call to the former IT Manager to see if it's on a server somewhere), but I'm willing to bet those are variable names that are most likely not being used to update anything.
I feel like I'm grasping for straws at this point, because if my above assumption is correct, and I don't have the source code to dig through, I'm going to be screwed in terms of rewriting the screen in question to get it to properly update this information.
Any assistance or insight that can be shed on this issue would be greatly appreciated.
Thanks,
Chris
I wanted to see if I could glean some information regarding an issue I'm dealing with in QAD.
I'm using CyberQuery to generate an open order report, and one of the things we'd like to include on this report is a Build Date. I believe I've found a suitable date field to use in the SOD_DET table, however the screen (which sadly is a custom screen) we're using to enter data doesn't appear to directly reference this field. As a result, I have no way to accurately determine if the data is being populated to the record in question.
The field I'm trying to modify is SOD_DET:SOD_PER_DATE. As an alternative, I could also use SOD_DET:SOD_PROMISE_DATE, as we're using neither of these fields for anything at this point. Normally when I press Ctrl+F on one of the fields in the screen we enter data into, it gives me a table.field listing showing exactly where the data is being entered into. If I do the Ctrl+F on either of these 2 specific fields (Promise Date or Performance Date), it instead gives me 'promise_date' or 'perform_date' respectively. I don't have the source code at my disposal at the moment (I have a call to the former IT Manager to see if it's on a server somewhere), but I'm willing to bet those are variable names that are most likely not being used to update anything.
I feel like I'm grasping for straws at this point, because if my above assumption is correct, and I don't have the source code to dig through, I'm going to be screwed in terms of rewriting the screen in question to get it to properly update this information.
Any assistance or insight that can be shed on this issue would be greatly appreciated.
Thanks,
Chris
