query to fetch standard cost and actual cost of a purchase item
We have a requirement to create BIP report that will fetch accounting entries from all subledgers. Additionally when the entry is purchasing(i.e. PO and PO receipts) we need to po number, receipt number, po item, standard/actual cost(based on the costing profile for that particular item).
Code Snippet (add any code snippets that support your topic, if applicable):
I am unable to fetch the costing information. Please find the attached draft version of the query.