Share
ReportIs 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
You’re offline. This is a read only version of the page.
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
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_Amount
from ME240457 t1
left 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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (