PO Receipt GL account

(AL) #1

Is it possible to query what GL account a PO receipt hit? I know i could use the WIPRecon report but i wanted to create a query for my Purchase Price Variance analysis. So, i want to see what GL accts any ADJ-CST or ADJ-PUR transactions hit from PO receipt or AP invoice entry. Is this only possible through the WIP Reconciliation report? Is there any table out there that holds this information?


(Mike Watkinson) #2

Are you doing this for transactions that are already posted? The below will be most of what you need. It will take a little bit of time and research to understand how to get back to the source tables for the extra columns you need for your analysis without breaking your BAQ.