How to get actual purchases on FSG report
Scenario
There is a inventory account named "Raw Material" where below transactions are booked from Inventory System.
Material Receipt (Dr)
Material Issuance (Cr)
Material Return [from floor to back into Inventory] (Dr)
My Requirement
Extract actual purchases booked into above account on FSG report.
Problem
If i use "Dr" coloumn on FSG, it will extract purchases + return
1) Please help out on this issue, i want to extract actual purchases on my FSG report
2) can i map GL catergory to a FSG line/coloum where i can find purchases.
regards