wish there was a way to delete...
Original Message:
Sent: 12-06-2023 11:04
From: Kevin Moyes
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
You always need a numeric mask. What I was saying is that how you set the mask matters more for SQL.
If you only expect integers up to 999, setting the mask for Premium to ### changes the field data type in SQL. Providex will still accept larger numeric values, where SQL will reject 1000 in that field.
I haven't tested well enough to complain to Sage about it, but whether you put the "-" (for negatives) on the left or right of the mask does change the field type in SQL too (decimal precision).
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------
Original Message:
Sent: 12-05-2023 20:22
From: Phil McIntosh
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
that's what I am doing, but it seems the mask isn't optional
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Original Message:
Sent: 12-05-2023 20:18
From: Doug Higgs
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
Create a new UDF and see if that solves it?
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
Original Message:
Sent: 12-05-2023 20:16
From: Phil McIntosh
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
Tried starting over, and it won't let me remove the mask. Checkbox is greyed out, and if I clear the format it comes back...
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Original Message:
Sent: 12-04-2023 20:29
From: Kevin Moyes
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
Try to remove the data flow (tab 3), save / update... then make the Mask change, and add back the data flow.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 12-04-2023 19:48
From: Phil McIntosh
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
@Kevin Moyes How would one remove the mask after the fact? it is grayed out now...
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Original Message:
Sent: 12-04-2023 18:55
From: Kevin Moyes
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
2022 Standard works.
(For Premium, don't use a restrictive numeric mask, since that affects the size of the numeric field in SQL... Even though Sage doesn't complain, it can cause serious problems).
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 12-04-2023 18:43
From: Phil McIntosh
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
yes
------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Original Message:
Sent: 12-04-2023 16:59
From: Lee Graham
Subject: SO_InvoiceDetail UDF from SalesOrderDetail
DataType listed as numeric on all the UDF Attribute screens?
------------------------------
Lee Graham
Friendly Systems, Inc.