By using this website, you agree to our Terms of Use (click here)
Hi Tim,
I just want to ask what are the tables needed to create an inquiry for unidentified receipts with corresponding payment ref nbr. I used CAAdj and CASplitExt but still it didn't work.
Thank you
Hey Peter,
Can you elaborate a little more on what you mean by "unidentified"?
Hi Tim,
Those are transactions appeared in the bank statement as credit but you didn't know who deposited it. I just want to create inquiry for the reclassify payments in Cash Management with the corresponding payment ref nbr. Please see the attached file.
Thank you
Ah, I've never used this screen before.
It looks to me like the Reclassify Payments (CA506500) screen is showing transactions from the Transaction Details tab on the Transactions (CA304000) screen. You can use the Inspect Element trick (click here for more info) on the Transactions (CA304000) screen to see that the two tables involved are CAAdj for the header fields and CASplit for the line fields.
You can join CASplit to CAAdj on CASplit.AdjTranType=CAAdj.AdjTranType and CASplit.AdjRefNbr=CAAdj.AdjRefNbr.
If you use Inspect Element on the Document Ref. field on the Transactions (CA304000) screen, you can see that it can be found in the CAAdj.ExtRefNbr.
But if you just want one field added to the grid on the Reclassify Payments (CA506500) screen, you'd probably be better off just customizing the screen because then you could still use the PROCESS and PROCESS ALL buttons which you wouldn't be able to do in a Generic Inquiry.
Hi Tim,
I've already use the inspect element. My problem is that I want to see the reclassification Ref nbr. but when I use the inspect element it tells me to use CASplitExt and the field is ChildOrigRefNbr. But when I join the two tables (CASplitExt to CAAdj on CASplitExt.AdjTranType=CAAdj.AdjTranType and CASplitExt.AdjRefNbr=CAAdj.AdjRefNbr) there's an error. Please the attached files.
Thank you
Have you tried using CASplit instead of CASplitExt?
Yup I tried also but it didn't work.
Hmmm, it must be stored in another table in the database. The trouble for me is that my test environment doesn't have any data in that area so it's hard for me to test.