Sage 100

Customer would like to add CONFIRM TO field to the SO Inquiry tab within Item Inquiry.  The field is not available in the custom office screen.  I tried to add the field to the detail table, but it wont allow me to.  Any workarounds???

------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------

I don't see a simple way.  Maybe a Script?

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

It could be the same issue I encountered here

Adding Multi Bin Primary Location to Inventory Maintenance Panel - v2022 | Sage 100

------------------------------
Jeff Schwenk
Owner
Bottomline Software, Inc.
Waynesboro VA
(540) 221-4444

Improving bottom lines for over 25 years!
------------------------------

Original Message:
Sent: 02-07-2025 08:14
From: Brett Zimmerman
Subject: New column in SO Tab in Item Inquiry

I don't see a simple way.  Maybe a Script?

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

That data is from SO Detail and SO header is already linked to the object (for Customer PO to be displayed in the grid), so I don't think there is a simple work-around.

SO Detail UDF for the Confirm To, plus a script to copy the value from the SO Header (header pre-write, with a loop), should work.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

This is doable with a script on the post-read of CI_Item and the post-load of the Orders tab but it is also requires a separate script file that contains ProvideX to retrieve the value you want from the target table.  The script on the events is needed to modify the IOList of the listbox control for sales orders to add the new column and have it use the XEQ function to call the ProvideX script.

------------------------------
David Speck II
Blytheco LLC
------------------------------