CRM Company field with default value not setting when created from Sage 100 Customer Maintenance

SUGGESTED

We have added a selection field to the Company table. The choices are Yes or No. The default value is No. When we add a new company in CRM, the default works fine.

When we add a new Customer in Sage 100 Customer Maintenance, & then check the "Relate to Sage CRM" & have it auto-assign the Company, this selection field remains null.

I also added a script to the Company Entry Screen (CompanyBoxLong) in CRM, in the Create Script box on this field: DefaultValue="No"; but it doesn't help.


Contacted Sage Support & they don't know how to make it work.  Thoughts??

Sage 100 ERP Standard v2015, PU3.  Sage CRM 7.3.a.

Parents Reply
  • 0 in reply to Andrew Liu
    "add trigger or something"? This is too vague. Where would I do this? I have added it as a default value on the field & the screen using a script. Are you talking in SQL or in CRM Customization?
    I was hoping when Sage 100 passes it off to CRM,it would just use the CRM logic that is on this field, but it doesn't seem to pick it up.
Children