Hi,
I have created a custom entity field named Partner Sales in Customer Record.
And defined the below search in search of Validation and Defaulting tab of custom entity field. This custom field appears in custom created subtab of customer record.
Search Used (based on customer),
I am trying to get partner sales of A in this custom entity field.
Example,
Customer record of A,
ID -> 1234
Name -> A
Partner record of A,
ID -> 6789
PartnerID -> FieldID entityid -> A-HP
Customer Record of X, (A Partner)
ID -> 5678
Partner -> FieldID partner -> A-HP
Customer Record of Y, (A Partner)
ID -> 4567
Partner -> FieldID partner -> A-HP
In sales record of X and Y, I can see
Partner -> FieldID partner -> A-H
Here A is our customer, X and Y are also our customers but they are partners of A. If X purchase goods of $50 and Y purchase goods of $30 , I want to have $80 in partner sales of A. From search above, I can get partner sales of A , but i cant have it in custom entity field i created . I got an error, ERROR: Field value cannot be derived from search with Group summary type . So, how can I modify search in order to get partner sales of A in that custom entity field in customer record of A. Any help will be highly appreciated.
Regards,