Notifications
Announcements
No record found.
Is there a Sql view that generates the exact same output as the Recreate check stub? I use Mekorma MICR for check print if that helps.
Thanks!!
*This post is locked for comments
I think the PM30300 might be about as close as it gets.
As Leslie said, the PM30300 is about as close as it gets. But there are some circumstances where that table does not provide a complete picture, namely the case where credit memos are auto-applied during a check build. In that case, the PM30300 table will show the invoice paid by the credit memo, not the check. I have not seen a way to relate the credit memo auto-application (that happened on the check run) with the actual check.
However, if you use Mekorma like you said, you can cross-check the ME240457 table with the PM30300 table. You would be looking for something like this:
select t1.DOCNUMBR, t1.MEFIELDNAME, t1.Field_Value, t2.VENDORID, t2.DOCDATE as Apply_From_Doc_Date, t2.GLPOSTDT as Apply_From_GL_Date, t2.VCHRNMBR as Apply_From_GP_Voucher, t2.DOCTYPE, t2.APFRDCNM as Apply_From_Doc_Number, t2.APFRMAPLYAMT as Apply_From_Apply_Amount, t2.ActualApplyToAmount, t2.APTODCNM as Apply_To_Doc_Number, t2.APTODCDT as Apply_To_Doc_Date, t2.APTVCHNM as Apply_to_GP_Voucher, t2.APPLDAMT as Apply_To_Applied_Amountfrom ME240457 t1left outer join PM30300 t2 on t1.Field_Value=t2.APTODCNM and t1.MEFIELDNAME='Document Number'where MEFIELDNAME='Document Number'
You could run with it from there, but it seems to give a pretty accurate view of the check stub and what was shown on the stub and how applied.
Hope this helps!
Chris
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
