+ Start a Discussion
Vigneshwaran LoganathanVigneshwaran Loganathan 

hi all , help me how to solve this error

Error: Compile Error: Didn't understand relationship 'Invoice_Statement__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names. at line 4 column 1

trigger HandleProductPriceChange on Merchandisenew__c(after update)
List<Line_Item__c> openLineItems =
[select j.Unit_price__c, j.Merchandise1__r.Price__c
from Line_Item__c j
where j.Invoice_Statement__r.Status__c='Negotiating'
and j.Merchandise1__r.id IN : Trigger.new
for UPDATE];
Hi!  Check security settings to verify that you have access to the field Line_Item__c.Invoice_Statement__c and to the custom object Invoice_Statement__c.  If you are confident that the field and custom object exist (and are spelled correctly), the IDE could show an error if the user account cannot see them.