cus_item_no and OECUSITM_SQL 1

[prog_0927]

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.

 

[NEmacGuy]

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.

 

[prog_0927]

Thank you very much! We have CONCAT it in one of the user_def_fld's