You’re offline. This is a read only version of the page.
I recently upgraded from SL 7.0 to SL 2011. We have two check boxes on the Project Maintenance (PA.PRJ.00) Screen which were working fine in the previous version, but now only one is working.
The gmi checkbox is working fine, the TIMESHEETcb checkbox appeared as a grey box with a check in it regardless of the value in the database. If you click on the checkbox and save, it will write the correct value to the database, but it will not show what the database value is.
These two checkboxes are identical except for the value in the database they write to. Any ideas as to why one would work and the other wouldn't?
*This post is locked for comments
Ah ha, the value is always 'N' regardless of what is actually in the database. Perhaps I can move the custom fields to the available unused statuses status_08, status_09, or status_10. I'll just have to be careful when I update the database and make sure that all my custom code is updated.
Thank you very much for your help. I'll post here later if I am successful.
in the immortal words of Arte Johnson (a reference probably lost on at least 75% of the audience of this post due to age) "Very Interesting"!
In an attempt to figure out why you are seeing the behavior you are seeing, I thought "maybe" there was a problem with the "offset" calculation for the status_15 field which in your screen shot shows it as 1290 bytes, I figured I take a look at the field name property of the same field in an instance of SL 2011 at my office. This lead to the "interesting" part.
I could not find any fields on the Project Maintenance screen that are currently attached to PJPROJ.status_15. So, I tried inserting a control via customization manager.... strange thing here was that status_15 and status_16 are not available to be inserted. What's really strange here is that the only time fields from a standard table in a screen are not available to be inserted via customization manager is if those fields are already attached to controls on the screen... but like I said, I couldn't find any control attached to that field.... "Very interesting!"
So.... I figured I'd check the Schema documentation in the help files to see if Project Controller uses the status_15 field for something special and maybe that's why it's behaving funny with respect to customization manager....
The help documentation said:
Status_15 - Create invoice drafts from shipper: Y/N
status_16- Shipper invoice method: O = Order Management, B = Flexible Billings, S = no invoice
So at least as of the time that documentation was written these fields are intended to be used for specific functions when certain features are enabled in Project.
So, there is a possibility that there is logic within the Project Maintenance screen that is populating the bPJProj.status_15 "Variable" with something different than what is actually in the same field in the database which would explain the behavior you are seeing.
How exactly did you get these check boxes to appear in the screen? Did you add them through customization manager or did you turn on a feature in one of the project setup screens that made the fields visible?
If you added them through customization manager then here is what I would recommend as a way to help diagnose exactly what is happening:
1) remove the check box control by deleting it in customization manager
2) save the customization
3) close and reopen the screen
4) Add a text box control to the screen via customization manager attached to the PJProj.status_15 field and make sure the mask for the control is set to a capital 'M'
4.5) You might need to add a "Call dispfields()" call in customization manager VBA code... maybe in the click event of a button you could add or something to make sure that you know you can force the control to show the current value of the attached variable on-demand
5) navigate to the same set of projects you checked before and see what shows up in the text box...
Alternatively you could also add a little VBA code to the check event on the project ID field that looks something like this:
'***********************************
Dim strStatus_15 as string
call getbuffervalue("bpjproj.status_15", strStatus_15)
Call messbox("The value of status_15 is: " & sparm(strStatus_15), 0, "Debug Code")
'***********************************
then navigate through some projects so you can see exactly what the given variable is being populated with.
Again, hope this helps.
Regards,
Tom Malia
T&T Data Solutions L.L.C.
I ran the following query:
Select Distinct PJProj.status_15, PJProj.status_16 From PJProj
And then ran this query for each case and selected a project from the resulting list:
Select Distinct PJProj.Project, PJProj.status_15, PJProj.status_16 From PJProj
WHERE status_15 = 'N' AND status_16 = '0'
Order by PJProj.Project
I pulled up each project in Dynamics Project Maintenance screen and took a screen shot of what the check boxes looked like for all the different values in the database.
I admit I need to clean up the database as there are a number of incorrect values, however, regardless of the value, the GMI Timesheet checkbox does not change.
Are you ALWAYS hettting a grey check mark for ALL projects or just for certain ones?
SL Check boxes are NOT binary value controls, they are "tri-state" controls. By which I mean, they can have "3"!! not "2" different states The can:
1) have the value defined in the "true Text" property of the control, which in this case is "1"
2) have the value defined in the "false Text" property of the control, which in this case is "0"
3) have ANY OTHER Value besides the "true text" or "False text" value
State 1 will give you a black check mark
State 2 will give you an empty box
State 3 will give you a grey check mark
I would suggest that you run a SQL select against the PJProj table and see what values are actually in those fields. Something like the following will help you with this:
Select
Distinct
PJProj.Project
,PJProj.status_15
,PJProj.status_16
From
PJProj
Order by
PJProj.Project
Also note that PJProj.status_15 and PJProj.status_16 are both Character fields and that a blank string is NOT the same as "0"
Hope this helps.
Tom Malia
T&T Data Solutions L.L.C.
Ok, so it will not be easy then.
1. What does this Checkbox right to the table?
2. What is your exact SL version from the help > about screen? 10 digit number
Luka,
Try changing the Top or left property of the check box to see if two boxes are stacked. Maybe a new field is covering the old field.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
