Hi ​@Wampyrae,

If I am recalling correctly then you can find Status column as OBJSTATE and ROWSTATE in ORDER_QUOTATION view and ORDER_QUOTATION_TAB respectively.

Regards

Abdul Rehman

Hi ​@Abdul ,

You’re right.

I already know OBJSTATE field with quick report, but with the default migration file mapping, this field don’t show.

I tried to manually add OBJSTATE in the file mapping … and it’s working !!
This field is hidden in data migration. ;)

Thanks for your help.

Regards

Back,

This database field is readable, but not writable.

I think this is information not stored in the database, but a dynamic field (dependent on the value of other fields).

Do you know the rules used to manage this information (Status, not State) ?

Regards

Hi ​@Abdul 

For setting the STATE Win/Lost you have to add the method Order_Quotation_api.Set_Quotation_Lost__ or Order_Quotation_api.Set_Quotation_Won__

There is also a method Order_Quotation_api.Set_Quotation_Close__ which can set the STATE to Win or Lost and also the STATUS to close to the Order Quotation at once.

If you only want to close the order_quotation then you can use the method Order_quotation_API.Close__

Only an example and not the whole solution:

/Jens