Dear Experts,
I have a custom entity called "department" which has a lookup field on another custom entity called "BUDGET". I have all the budget records in place. I need to mention the appropriate budget for the department for which I exported all the department names for re-import and entered the correct budget names on the xml files. But when I try to import this back I am getting "Lookup reference not found" error on budget lookup field of department during the transform phase. But if I manually try to enter the budget by opening the department record, it resolves. Once thing I noticed as a difference though is that when I type in the full name of the budget record on the lookup field and press tab for a split second it says the error "You must specify a value" (as if I entered an non existing record) but it immediately resolves and the error goes away.
This is how my two custom entities looks like.
Entity (Department):
Department Name (Primary Key)
Budget (Lookup)
Entity (Budget):
Budget Name (Primary Key)
Budget Amount
Budget Consumed
Error Log during re-import
When tried to enter the department name manually (this appears for a split second, normally this comes when we partially enter a name, but here I entered the full name and it does exist.)
and then resolves:
any help appreciated.
Regards
AbD
*This post is locked for comments