Announcements
No record found.
*This post is locked for comments
We had the same problem. In our case we had a duplicate check number. We mistyped a check number that was already in history. We deleted that record and it worked.
I tried duplicating the problem to send out as a bug and could not get it to accept the duplciate check number. But somehow it got through that one time.
Can you tell me the name of the record in which you found the duplicate check number, please?
Pat,
Our batch was not very large so we went through every check number in it and did a search for it in the "Purchasing->Inquiry->Transaction by document" command. We use the check number for the document number. I assume that's standard practice so hopefully you do also.
If your batch is large you can probably write a SQL statement with PM30200 (paid transaction history file) and PM20000 (PM Transaction open file). Something like "select DOCNUMBR from PM20000 where DOCNUMBR in (select DOCNUMBR from PM30200". I have not tested this command but it's how I would start.....
Fred,
I really appreciate your attempts to help, but I feel like we are talking about 2 different things. I am talking about the Cash Receipts screen (Transactions>>Sales>>Cash Receipts). On that screen, when the "Check" button is selected, there is no field for Document number; I enter only the Customer, the Amount, and the Check/Card Number.
I tried the SQL script you suggested, but there were no record output. I have no idea what to do next.
Pat
What document number are you trying to enter on the cash reciepts screen? What are you trying to accomplish by entering a document number?
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
