Hi Experts
We have following clearing GL accounts:
1. GR / IR Clearing Account
2. Freight Clearing Account
These Accounts get credited when we do goods receipt with TCode MIGO. When we do invoice verification then above two accounts get debited. Hence the balance should be zero for both the above GL accounts.
Same way with CENVAT Clearing GL Account. When I do part 2 posting in J1IEX, CENVAT Clearing Account gets credited. When I do MIRO, it gets debited. Hence for CENVAT Clearing Account also, balance should be zero.
But in my case, there is credit balances in all the three above GL accounts. Now I want to know for which GRNs, we have not received the invoices because of which balance is there in above three GL accounts.
Note: I kept sort key as '010' in GL master for all the above three clearing accounts. But PO number is getting populated in assignment field only for GR / IR Clearing Account (and not Frieght Clearing and CENVAT Clearing GL Account).
I just want to know list of GRNs for which invoices are pending. I do not want to post any clearing entry. I tried with F.13, its running only for GR/IR Clearing Account. Its not running for Freight Clearing and CENVAT Clearing Account. (Reason might be that PO number is not getting populated in Assignment field).
Please help me, how do i meet my requirement.
--
Deepak