You need to sign in to do that
Don't have an account?
Parth Srivastava
please help in trigger
I need help with creating a field that auto-populates the “Standard Price” from the Product object into a field called “Base Price” in the Transactions custom object.
Use Case:
When a Transaction record is created, the Item Number should be looked up in the Product object "Product Code", then the "Standard Price" should be returned in the "Base Price" field
Example:
The transaction is created with item number 2200, we should look up the Product object and find the Product with Product code 2200. Then we should return the standard price of $80.00 into the “Base Price” field.
Use Case:
When a Transaction record is created, the Item Number should be looked up in the Product object "Product Code", then the "Standard Price" should be returned in the "Base Price" field
Example:
The transaction is created with item number 2200, we should look up the Product object and find the Product with Product code 2200. Then we should return the standard price of $80.00 into the “Base Price” field.
Use below code
Let me know if you have any confusion.
Kindly mark this as solved if the reply was helpful.
Thanks,
Murali
In query you are passing " ProductCode =:transIds.ItemNumber__c".
This checks if transIds.ItemNumber__c is equal to ProductCode.
Thanks,
Murali
I did some modification in Murali's code. Please try this and let me know if it works