Reconciling / Matching RMAs to Auto [Invoice Master Program] generated Credit Memos
Dear OM / AR Experts,
We have a requirement to Match / Reconcile to prove conclusively that all the RMAs raised during last FY, system has generated the Credit Memos.
Customer wants to see the All RMAs listed and along side the corresponding Credit Memos.
Kindly suggest, how can we achieve this.
Any script that can join both RA_Transactions Table & OE_Order Table and fetch required data will be helpful.
Note:- We have already run the Transactions Register in AR and have listed the corresponding CMs against them. However this does not rule out the possibility of missing ones or prove that ALL RMAs have the CMs. Hence, the starting point should be OM, not AR.
We have a requirement to Match / Reconcile to prove conclusively that all the RMAs raised during last FY, system has generated the Credit Memos.
Customer wants to see the All RMAs listed and along side the corresponding Credit Memos.
Kindly suggest, how can we achieve this.
Any script that can join both RA_Transactions Table & OE_Order Table and fetch required data will be helpful.
Note:- We have already run the Transactions Register in AR and have listed the corresponding CMs against them. However this does not rule out the possibility of missing ones or prove that ALL RMAs have the CMs. Hence, the starting point should be OM, not AR.
0