DataBase - Cash Receipt Error

Asked By Haitham Sanber

25-Jan-10 05:16 AM

Hi,
I am using Dynamics GP 10.0 and I had a problem two days ago. we wanted to
enter a transaction in the cash receipt entry, but an error message states
that the document number has been used. i checked the smarlist if we have
ever used the documnet number, but we have didnt. I used the serial of the
payment documents from GP and it gave the same error. I checked the setup
files and all the configuration were fine.
can anyone help me with this problem

Best Regards
Haitham H. Sanber

25-Jan-10 05:25 AM

Hi,

Run checklins (MSDGP>>Maintenance>>Checklinks)  on Sales Series to remove
orphaned records.  Your incident is common when a record exist in RM Keys
Master that is not in Wok, Open and History files which is can happen when a
user hang while in any of the transaction entry windows in sales.

Hope this helps!

Cheers,

Dennis Araullo
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

25-Jan-10 05:29 AM

Haitham,

Most probably your transaction is exist but not properly posted, you might
need to try Check-Links and if that didn???t help to try finding the number in
table "RM10201".

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
mohdaoud@gmail.com
http://mohdaoud.blogspot.com/

25-Jan-10 05:29 AM

Most likely the error you are getting is saying that the Check Number you are
entering for the cash receipt has already been entered for that customer.
This is a verification performed by GP to ensure that you do not double
enter cash receipts, and is typically useful.  However, once in a while, a
customer switches banks or has multiple bank accounts they pay from with the
same check numbering, so you legitimately get a check from them with the
same number that you received previously.  Does not happen too often, as not
only does the customer have to be using the same check numbers but you also
have to receive the same exact check number from them as you did before, but
it does happen.  If this is, legitimately, a new cash receipt, then you will
need to enter a unique check number for it...maybe add a period (.) or A to
the end.

--
Victoria Yudin
Dynamics GP MVP
Want to use Crystal Reports with GP?
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

25-Jan-10 06:28 AM

Hi Dencio,

I tried the check links for the sales series, and the output in the RM key
file was that a payment transaction has a missing records, and that the key
records has been removed. I went back to the cash receipt entry window and
tried to enter a payement of a check type but it gave me the same error again
payment on the same check book ID and it worked. I even tried to enter the
same documents into another check book and it worked. I have a problem with
one check book of the check book that I have in GP.

25-Jan-10 07:01 AM

Thank you victoria for the reply. but with all respect this is not the case.
because when I try to enter the same document with the same check number the
system accepts the transaction without errors. so I think it is not a
duplicate in the check number for the customer. even when I enter the
document and choose the check book ID before entering the customer number the
system show the error "the payment document number has been used"
I dont know if you ever faced this problem before.

25-Jan-10 07:06 AM

Hi Mohammad,

I noticed that you live in Jordan. will we are a Jordanian company located
in Amman. I tried the check links that you suggested and it reported  that a
payment document number transaction records were missing, and that the keys
record has been removed.
The problem is with the check book ID I think, because if I try a cash
receipt into the check book the system accepts it. even when I try the same
document and chek numbers into another check book ID the system accepts it.

I dont know if you have any Idea.

Best Regards

25-Jan-10 01:25 PM

Haitham,

I would suggest performing more investigations on the issue by running
profiler or DEXLog trace, this will return where exactly the error is.

However, you can contact me anytime to my number below and arrange a remote
connection or even a visit, it would be great helping people in my country :)

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
mohdaoud@gmail.com
http://mohdaoud.blogspot.com/