How can I retrieve other module's field into opportunities module?

[manfree]

Hi all,

How can I retrieve other module's field into opportunities module ??

For example,
i have a custom module "Product", it includes the "product name" and "product price" field
Then, I am going to create new opportunity,
after I have selected the product, this new opportunity record is able to retrieve the product price as well ~

I don't mind the product price can be retrieved after I clicked the "Save" button in opportunity

Any body could help ??
Thanks

Sam

[salesagility]

You cannot do this using native SugarCRM Studio functionality and will need to cut some custom code. It's not too difficult.

[andopes]

You need to do the following:

1. Create the product_price field through Studio;
2. Add this field into both detailview and editview through studio;
3. Create a logic_hook before_save where you will save into product_price custom field the value from related product.

Cheers

[manfree]

I read the document about "Custom Bean Files"

it has a function:

 function save($check_notify = FALSE) {
    global $current_user;
    $this->description .= "\nSaved on ".date("Y-m-d g:i a"). " by " .$current_user->user_name;
    parent::save($check_notify);
} 
  

the above function can update the description in the same module,


Does it mean I have to do the same thing in opportunity form?
for example,

< after the user clicked the "SAVE" button in opportunity form >

 function save($check_notify = FALSE) {
    $this->product_price = ??????;
    parent::save($check_notify);
} 
  

But ....
1. How can I retrieve other module's value ("price" in Products module) and put into opportunity module?
2. Where should I put / insert this script?
Thanks

Sam