How do I find the GL for a Misc AP Payment?
Wow, I was going to start with “Try Payment Tracker,” but that screen is NOT what I was expecting. Like, AP Invoice Tracker (and AR also) has these nifty GL tabs to show what happened when the thing was posted. But Payment Tracker is some dashboard hack.
So, what exactly are you looking for? To track down what happened on a particular payment?
There is an AP tech ref guide on EpicWeb and this is page 1 of their explanation, for example. It will show you what is supposed to happen.
I also expected the info to by in Payment Tracker, frustrating that it is not. I need to see the GL a misc. check was coded.
Well you might need to become acquainted with the lovely TranGLC table.
So you’d make a BAQ connecting TranGLC and CheckHed on Company and then criteria on TranGLC of Key1 = HeadNum* and RelatedToFile = CheckHed
*Actually you’ll convert HeadNum (an int) to a string, so it’s really:
Key1 = convert(varchar, CheckHed.HeadNum)
Like so:
(I filtered CheckHed to the last 2 weeks just to test it out.)