Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cus_item_no and OECUSITM_SQL 1

Status
Not open for further replies.

prog_0927

Programmer
Jan 3, 2022
42
US
Progression 7.9.310

We are using the Wisys SDK and are attempting to use the cus_item_no field on the OELIN to INSERT a unique ID. We can see it working, changing the cus_item_no via the OECUSITM maintenance app in Macola and SQL updates reflect in the Macola app as well. My question is, is that intended to be a unique customer id per customer and item_no and not intended to be changed per order? That is kind of what we came up with because if we insert a line item on the order and there is a cus_item_no associated with it in Macola it reverts to that cus_item_no already in that table. Just wanted avoid a chasing rabbits if this what we are doing is outside of the intention of that field.
 
If there is a customer item number on file, the source code of the program will automatically populate the cus_item_no will populate. The field wouldn't change per order, the key is the customer and the item_no. I think you are fighting the source code with the sdk. Can you use one of the User Defined Fields.
 
Thank you very much! We have CONCAT it in one of the user_def_fld's
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top