web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by 18

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:
I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: SM - Outstand Checks report is blank when we reprint posting journals

    Thank you, Cheryl!

    John

  • Cheryl Waswick Profile Picture
    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
    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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans