AR Post Cash Process Hanging Up

[AKPolarBear]

Occasionally, the process when entering cash payments appears to hang and stop with no activity for 3 minutes or more. This happens during the invoice selection screen. No messages are generated and ultimately, the user will use task manager to kill the process and start that entry over. Any ideas why it does this? The user doing the input appears to be doing so correctly.
I am wondering if it is some sort of a file lock problem that does not display a warning message. We are on ver 7.6.100 and MSSQL. The problem appears to be happening daily.

 

[MacolaHelp]

I am a little confused:

Entering cash would be done in the order entry screen: trx\enter orders by clicking on the OE cash check box, bringing you to the screen where you can supply information about the MOP (method of payment). It is not done during selection of invoices. Unless you have custom code or Flex in here. If custom or Flex, ask your programmer what might be wrong.

If indeed you are using the OE cash check box in the oe screen, then I suspect file corruption. A mismatch between order header & line records can create myriad problems. Check to see if all order headers have corresponding lines. If not, delete the strays. If order lines have no headers, delete the strays. Then try again.

The cash application information is stored in OECSHFIL_SQL. And, one more question, when you refer to entering cash payments, you are talking about order entry, not applying cash in AR, right? Otherwise, we have a different scenario.

 

[kscheeler]

My thought is that you are talking about AR cash. Do you find it happening to random customers or specific ones? It could be that there alot of records for a customer in the AR open item table (AROPNFIL_SQL). If that's the case, it will take some time to search through them to figure out which ones are not fully paid yet. Those are the ones that it's showing you.

If you think it's a lock then in query analyzer look at the records in the maclocks table in the msllockdb to see if any records are locked in the table listed above.

Kevin Scheeler

 

[stravis]

Are you possibly using the OEBEST source code enhancements? These "enhancements" to Macola will do this on purpose if you are using the credit card authorization enhancement or not on purpose, because in my experience they are buggy.

 

[AKPolarBear]

This is about A/R Cash posting, not from O/E.
We are currently working on another solution. It appears we purged O/E up through 2000 but did not do A/R hence our A/R files are large and that may be the problem. Once this is done, we will see if the problem goes away.

The problem is random. I will have the user make note of the customer when it does it so I can see if there is a pattern.

We do use a Best of O/E product from a 3rd party vendor who also happens to now be our VAR (was not our original)but we do not use the CC authorization routine. We do have other enhancements but none directly for A/R that I am aware of. Mostly O/E and I/M for inventory related functions.