Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SM - Outstand Checks r...
Finance | Project Operations, Human Resources, ...
Suggested answer

SM - Outstand Checks report is blank when we reprint posting journals

(1) ShareShare
ReportReport
Posted on by Linda Brock 2,990

Hi,

When we print the reconciliation reports at the time of the bank rec, the Outstanding Report prints fine.

However, when we use the Bank Posting Journals to reprint the Outstanding Transactions Report, it prints for some Audit Trail Codes, but for others, it says zero transactions. Those same Audit Trail Codes reprint the Marked Transactions and the Reconciliation Journal just fine.

We've rebuilt the reports.dic.

This happened on GP2015 and is still happening on GP2018R2

Thanks,

Linda

Categories:
Microsoft Dynamics GP
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SM - Outstand Checks report is blank when we reprint posting journals

    Thank you, Cheryl!

    John

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: SM - Outstand Checks report is blank when we reprint posting journals

    Hi John, 

    You must update the audit trail code in the CM20502 table to match the CM20500 table.  If you need assistance, please open a support case and we can help you further. 

    Thanks

    Cheryl W

    Microsoft Support

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SM - Outstand Checks report is blank when we reprint posting journals

    Hi Cheryl:

    I'm taking over from Linda, and below is what we have found:

    Script ran (USE PSMF SELECT * FROM CM20502 WHERE AUDITTRAIL='CMADJ00000294' SELECT * FROM CM20500 WHERE CHEKBKID='WFACK').  It did not return a matching entry in CM20502.

    What are next steps?

    Thanks, Cheryl!

    John

  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: SM - Outstand Checks report is blank when we reprint posting journals

    Hi Linda, 

    Confirm if the transactions in the CM20502 outstanding table have the same RECONUM and AUDITTRAIL as the reconciliation has in the CM20500 reconciliation table.  If they match, the they should print on the report.  


    Hope that helps, 


    Thanks

    Cheryl Waswick

    Microsoft Dynamics GP Support

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans