I need to reconcile the variances from the Purchases Returned not Credited (PRNC) account. The item fulfillment amount is sometimes not the same as the bill credit. The process is ITMF first, then Bill Credit. - This should clear the balance the PRNC account
My issue is the below:
GL detail below:
Blue Highlight works perfectly. However, Pink Highlights leaves me with a credit balance of $324.94. Is there an easier way of me going through a large list to find the SRMA thats associated with each ITMFs. The ITMF is created from an SRA # so even pulling a saved search that includes that, I can vlookup into my Added column and sort it like such.
I was able to pull all the ITMFs that I need based on a Saved search below. I just need to pull the "Created From" information.
Created from shows SRMA # that I hope can be retrieved at least on a saved search. The example below shows SRMA-00008 from the first example above.
Ultimately, my end goal will create a pivot table and that will give me my net balances not "0" per each SRMAs.
Also, I do not believe there is a way to track the variances month to month between these two transaction types. If there is something that can be created, please suggest.