Problem with Product Subpanel

[thalia]

Hi,

I created a custom field in the Product Module called 'Name of Product' The field type is 'Related' and have selected the Product Catalog as the 'module.'

I would like this to be visible in the Account Module, so that when I click into the Account, I can see the list of products the client/account have purchased.

To do this in Studio, I selected the Account Module, clicked Subpanels, chose Products and then dragged my custom field (Name of Product) into the default list. Clicked Save and Deploy and then clicked into an account. I can see the Name of Product Heading, but no products are listed under this heading.

I am using Sugar version 5.2.0.

Any assistance would be much appreciated.

Thanks,

Thalia

[sugarcane]

Hi Thalia,

are you using SugarCRM Pro or Ent? If so, then any products that were purchased would appear under the Products subpanel for the account. You could always click and drag the submodule so that it is the first one under the account Detail view. This way, you do not need to customize anything, and the products are easy to view.

[thalia]

Hello,

Thank you for your response. We are using Sugar Professional. I have attached a screen shot to show you what it looks like. I tried dragging the product subpanel to the top, but it didn't make a difference. As you can see, there is not a list of products (even though I have added two products)

Cheers,

Thalia

[crmbalah]

HI
try to check your database the field values is saved or not.. if the value is saved, check your subpanel related files.

[andopes]

Hello,

Thank you for your response. We are using Sugar Professional. I have attached a screen shot to show you what it looks like. I tried dragging the product subpanel to the top, but it didn't make a difference. As you can see, there is not a list of products (even though I have added two products)

Cheers,

Thalia

Edit the file modules/DynamicFields/DynamicField.php and add this piece of code

             $fh = fopen('log.txt', 'w');
            fwrite($fh, $query);
            fclose($fh); 
  

just before the line

             $queryInsert .= " ) VALUES $values )"; 
  

Save the file, edit an existing product and set another Name of Product, save the record and open the file log.txt

Let us know the sql query saved into the file.
Try to run this query on your database manager.

Cheers

[thalia]

Thank you so much. I will test this and let you know.