Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Statements missing che...
Microsoft Dynamics GP (Archived)

Statements missing check number

(0) ShareShare
ReportReport
Posted on by Jill Connelly 135

When we ran monthly customer statements on 3/1, we notice the check number is missing on almost all the check payments. I say almost all because I can find check numbers on some payment lines for a few customers but 99% are missing.  The ones that are there appear to old payments from many months ago.

This was working fine last month.  We have not modified the report and did our monthly processes as usual.  We have processed some checks this past week and if we re-run the statements, the check numbers do appear on those.

Any ideas what could be causing this?

Jill

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Statements missing check number

    Hi Jill,

    The Statement report is not based initially on the RM20101 table - it is based on a temporry table called RM Statements Header Temp. This would reference records both in the RM20101 (Open) and EM30101 (History)

    The RM20101 table may have been added to the report so that you could get the Check Number.

    The problem seems to be that some transactions are now in the RM30101 table (From a statement printing point of view, this is fine) - they still have their check numbers - but the report does not have the RM30101 table added - or if it is added,  the Chq Number field in RM30101 is not added to the report.

    Apologies for late reply - I was travelling.

    You may need to add the RM30101 table to your report. You may then need to create a calculated field that looks for the document status, and if it is Open it returns the RM20101.chqnumber, and if it is not it returns theRM30101.chqnumber.

    Or something like that!

    Best regards,

    Ian.

  • Jill Connelly Profile Picture
    Jill Connelly 135 on at
    Re: Statements missing check number

    Let me add that the check numbers I am seeing on the statement (and are in RM020101) are those that are not fully applied so guess they should still be there.  

    I am beginning to think that when we ran the Paid Transaction Removal, we somehow did not change the Cutoff Date for Checks and so it ran with a date of 3/1/11.  Would that  give us the behavior we are seeing?  

    I still don't understand however how these payment are showing up on the 'RM Statement on Blank Paper' report at all (even missing the check number) if they are not in the RM020101 table.

  • Jill Connelly Profile Picture
    Jill Connelly 135 on at
    Re: Statements missing check number

    Sorry if I sound like a newbie but I am.  We are a small business with only a few users so not a ton of GP experience in house. No, we have not run Check Links.  We have never run that before with this version (we are on GP 10).   I can try it if you think that would be helpful.  Having not run it before on this version, I have been hesitant to do it.

    We have not run any purge or cleanup. We only did the usual end of month process on 3/1 which did include Paid Transaction Removal.  We did that as usual by changing the cutoff date to 90 days ago (to 12/1/10).  Same as with every other month in the past but never had this problem.  Of the few records that do happen to show the check number, one of them is from 12/21/10 so doesn't seem to indicate that went wrong.  I am also seeing check numbers for checks we processed on 3/4/11.

    I ran the unmodified Statement and unfortunately it doesn't include check number so can't see if it is there.

    I decided to look in SQL to see the data in the tables underlying the report.  Not entirely sure what I SHOULD be seeing but here is what I see:  in RM20101 (RM Open File that the report uses) there are no records for the transactions I see that are missing their check number.  Not sure then how the transactions appear on the report?

    Out of curiosity, I looked in RM30101 (think this is History) -- I CAN see the records and they do have the proper check number.  

    Any suggestions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Statements missing check number

    Hi Jill, thats kinda strange.

    Have you tried all the usuals like Check Links and Reconciles etc?

    Did anyone do a big clean up of customer accounts during the last month?  such as applying lots of unapplied documents or re-doing apply records, or transferring documents to history, or maybe performing an automatic write off?

    Anything like that?

    If you print statements to an unmodified statement report - does the issue occur?

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans