I want to Purchase date against posted sales invoice item. Let me explain in brief.
1> First I am open "Posted Sales Invoice" Table & take one Invoice.
2> now open this invoice and from line you have to select one item & navigate to "ILE".
3> now the task is to find purchase date of particular item for this item.
Problem is that when I press applied entry then it goes me to same table & i don't know how to do in SQL.
Is there anyone here to help me to solve this issue.