I think this s a simple question. But the answer is eluding me.
How do I find the GL_ACCOUNT_NO related to a payment (or transaction) using SSRS?
There are some old posts in the forum that refer to T_PMAP. But the use of that table is depricated.
Any ideas will be much appreciated.
Darren
Hi Darren,
As of v12, the pmap_no in T_TRANSACTION corresponds to the id in T_PERF_PRICE_TYPE. You’ll find the the GL information you are looking for there. Please note that while T_PMAP held values corresponding to the gl_account_no field in T_GL_ACCOUNT, T_PERF_PRICE_TYPE holds values corresponding to the id field in T_GL_ACCOUNT.
Bryan Evans
Application Support Specialist
Tessitura Network
+1 888-643-5778 x 427
bevans@tessituranetwork.com