Sage 100

I suspect this is a quick "no" but is there a way to influence the text color of a value on the quantity tab of item maintenance? We added a UDF for a client that calculates a slightly different quantity available and they want it to be red if the value is negative. I've done grid colors before, but this seems different. Can anyone answer definitely if this is possible or not?  This is a UDF on IM_ItemWarehouse that is added to the Quantity tab of Item Maintenance. Thank you!

------------------------------
Kate Krueger
Consultant
MicroAccounting
214.800.5555x553
------------------------------

In version 2024 functionality was added to make standard quantity available to turn red by user if the quantity is not available.  The functionality works different in SO Order Entry vs. SO Invoice Entry.  I'm setting my clients up based on user functionality. Maybe a a script can duplicate the functionality on a UDF.  If your client is on version 2024, you could use the standard functionality and then highlight the UDF field to bring attention to it.

------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

Thank you Michelle, Clients have been loving that new piece of functionality!

------------------------------
Kate Krueger
Consultant
MicroAccounting
214.800.5555x553
------------------------------

Original Message:
Sent: 02-26-2025 01:38
From: Michele Herzog
Subject: Change Color of Number

In version 2024 functionality was added to make standard quantity available to turn red by user if the quantity is not available.  The functionality works different in SO Order Entry vs. SO Invoice Entry.  I'm setting my clients up based on user functionality. Maybe a a script can duplicate the functionality on a UDF.  If your client is on version 2024, you could use the standard functionality and then highlight the UDF field to bring attention to it.

------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

The 1st problem I had was despite adding the negative sign in the format mask in UDF Maint and then adding to LB_QUANTITIES listbox with Customizer, a negative UDF value appears as positive on the Quantity tab. So I'm not sure if you ran into this as well. Check on that.

Sage programming conditionally shows negative qtys for standard fields in red via a special variable cListViewNegativeColor$ in IM_ItemQuantityInquiry_ui.pvc. So the best way to deal with that is a program override that would include your UDF with that formatting.

Another way is to carefully DFDM edit IM_ITEM.M4L on the appropriate mas90\IM\Custom\ folder (after making a backup of it) then finding the PQUANTITY record for it that corresponds to LB_QUANTITIES. Since you and I have been involved with doing this type of thing before, you're interested in changing Field 23 Nomads_Null$ and Field 36 Nomads_Scratch$.

Let's say actual name is UDF_QTY_AVAIL and shows as "Qty Avail".
This is how you normally would see your portion of the long string:
Qty Avail~STP(STR(UDF_QTY_AVAIL:"#¬###¬###.00")¬2)

You would insert the special variable into it like this:
Qty Avail~cListViewNegativeColor$+STP(STR(UDF_QTY_AVAIL:"#¬###¬###.00")¬2)

Now a negative UDF value shows in red but for me didn't make the negative sign appear.
I had to do it this way in case you need it:
Qty Avail~cListViewNegativeColor$+STR(UDF_QTY_AVAIL:"#,###,###.00-")

Lastly, if you use Customizer again on Item Maintenance there's a fair chance it will reset this PQUANTITY LB_QUANTITIES record with the defaults for Fields 23 and 36. You will have to test that. One way to handle that is a Panel PostLoad script on DMain that would call Perform Logic to check the record is set the way we want. If it's not, the Perform would fix the record so things will look right by the time you click Quantity.

------------------------------
Alnoor Cassim
Accounting Systems, Inc. (ASI)
------------------------------

Thank you @Alnoor Cassim! I will take this back and see what I can make happen. Thank you as always for your above and beyond help!

------------------------------
Kate Krueger
Consultant
MicroAccounting
214.800.5555x553
------------------------------

Original Message:
Sent: 02-26-2025 02:52
From: Alnoor Cassim
Subject: Change Color of Number

The 1st problem I had was despite adding the negative sign in the format mask in UDF Maint and then adding to LB_QUANTITIES listbox with Customizer, a negative UDF value appears as positive on the Quantity tab. So I'm not sure if you ran into this as well. Check on that.

Sage programming conditionally shows negative qtys for standard fields in red via a special variable cListViewNegativeColor$ in IM_ItemQuantityInquiry_ui.pvc. So the best way to deal with that is a program override that would include your UDF with that formatting.

Another way is to carefully DFDM edit IM_ITEM.M4L on the appropriate mas90\IM\Custom\ folder (after making a backup of it) then finding the PQUANTITY record for it that corresponds to LB_QUANTITIES. Since you and I have been involved with doing this type of thing before, you're interested in changing Field 23 Nomads_Null$ and Field 36 Nomads_Scratch$.

Let's say actual name is UDF_QTY_AVAIL and shows as "Qty Avail".
This is how you normally would see your portion of the long string:
Qty Avail~STP(STR(UDF_QTY_AVAIL:"#¬###¬###.00")¬2)

You would insert the special variable into it like this:
Qty Avail~cListViewNegativeColor$+STP(STR(UDF_QTY_AVAIL:"#¬###¬###.00")¬2)

Now a negative UDF value shows in red but for me didn't make the negative sign appear.
I had to do it this way in case you need it:
Qty Avail~cListViewNegativeColor$+STR(UDF_QTY_AVAIL:"#,###,###.00-")

Lastly, if you use Customizer again on Item Maintenance there's a fair chance it will reset this PQUANTITY LB_QUANTITIES record with the defaults for Fields 23 and 36. You will have to test that. One way to handle that is a Panel PostLoad script on DMain that would call Perform Logic to check the record is set the way we want. If it's not, the Perform would fix the record so things will look right by the time you click Quantity.

------------------------------
Alnoor Cassim
Accounting Systems, Inc. (ASI)
------------------------------