I did manage to get past the first problem, but there is still a discrepancy between the behavior in the UI and when a script changes the print and charge fields: if a script makes a change, you have to manually change the price field. If you check or uncheck the box in the UI, the price gets removed or calculated.
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------
Original Message:
Sent: 05-25-2023 16:35
From: Mary Jo Krueger
Subject: Work Ticket Edit parts tab script issue
JobOps / Operations Management fields DO hit the SO_detail table.
------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
------------------------------
Original Message:
Sent: 05-25-2023 10:07
From: Carmen Cruz
Subject: Work Ticket Edit parts tab script issue
Good morning, Phil,
While going through this issue again, I noticed that these fields that you were mentioning start with JT but in a prior email you mentioned the table that you're talking to is SO_salesorderdetail. SO table would not have fields that start with JT. Am I missing something?
Original Message:
Sent: 5/23/2023 12:53:00 PM
From: Phil McIntosh
Subject: RE: Work Ticket Edit parts tab script issue
JobOps has always broken things differently...
Shall I try the data dictionary hack?
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Original Message:
Sent: 05-23-2023 10:30
From: Carmen Cruz
Subject: Work Ticket Edit parts tab script issue
I Phil,
Yes, I was talking about the table from this field that you're trying to update. If you did try to add a UDF an update of the data dictionary and that didn't work I'm sorry but I know a lot of times when I get that weird error that's what works for me. Maybe the error Sage is throwing is not the real error at all but the only way Sage knew how to respond. Sorry bout that :(
Original Message:
Sent: 5/22/2023 8:41:00 AM
From: Phil McIntosh
Subject: RE: Work Ticket Edit parts tab script issue
@Carmen Cruz ,
By "both tables" did you mean JT_WorkTicket and SO_SalesOrderDetail?
If so, it didn't fix the issue...
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Original Message:
Sent: 05-21-2023 09:31
From: Carmen Cruz
Subject: Work Ticket Edit parts tab script issue
Hi Phil,
To resolve this issue create a custom office UDF's field on both those tables and update. Once you do that it will fix the Data Dictionary issue and should take care of that error message. Have a great day.