Page 1 of 2 1 2 >
Topic Options
#20973 - 02/11/10 01:58 PM Posting issue with Invoices and A/R
DenisM Offline
Adagio Groupie

Registered: 06/28/06
Posts: 16
Loc: Estevan, Saskatchewan
My customer was posting a batch in Invoices 8.1B, to A/R 9.0A. There were two invoices in the batch, both with a large number of items and a large dollar amount. After making an Invoices backup, posting was attempted. The program hung mid post, and she was forced to close it. She called me after checking the batch and customer. The batch was still listed as unposted, but in the customers A/R info both invoices were listed. We ran data integrity checks on both A/R and Invoices data, with no errors detected. I ran syscheck and there was no problem detected. They normaly keep a posting journal of everything posted. There is no journal for this posting. The batch is still sitting in Invoices. I have taken a copy of customer data if needed for analysis. The customer is using Windows XP Pro on a Novell server. I believe the novell client options are set as recommended by Softrak.
How should I proceed to resolve this issue?

Top
#20975 - 02/11/10 02:55 PM Re: Posting issue with Invoices and A/R [Re: DenisM]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11557
Loc: Vancouver, BC Canada
Hi,

If the batch isn't posted, there will be no posting journal. Also, the invoices won't be in History for future inquiries, reports won't be updated, etc..

It's probably best to restore from a prior backup.

If they're using Novell, they should make sure that all of the latest client service packs have been installed and that opportunistic locking, file caching and file commit are turned off.
_________________________
Regards,
Softrak Tech Support

Top
#20976 - 02/11/10 07:13 PM Re: Posting issue with Invoices and A/R [Re: Softrak Support]
DenisM Offline
Adagio Groupie

Registered: 06/28/06
Posts: 16
Loc: Estevan, Saskatchewan
I am a bit confused. Shouldn't file commit be set to on?

From Novell description of option (in client settings)

-Controls whether buffers flushed by an application are committed to disk on the server. Setting this value to On will ensure data integrity at the expense of performance by ensuring file buffers are committed to disk on the server when an application flushes its file buffers.

Top
#20977 - 02/11/10 08:06 PM Re: Posting issue with Invoices and A/R [Re: DenisM]
DenisM Offline
Adagio Groupie

Registered: 06/28/06
Posts: 16
Loc: Estevan, Saskatchewan
Further to this problem, I feel all the settings are correct. The thing I am suspicious of is the number of items in the invoices. This customer routinely does invoices with 350 to 500 items per invoice. The batch we are trying to post has 371 items in one invoice and 444 items in the second. This customer had no problems doing this with DOS Quick Invoice. Would it be possible to send the data to support and have them try to post the batch? That would remove any possibility of the network or workstation being the cause of the problem.

Top
#20978 - 02/12/10 04:41 AM Re: Posting issue with Invoices and A/R [Re: DenisM]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4511
Loc: Wynnewood, PA
Rather than sending the data to support, why don't you restore a backup to your C: drive and test it there - that will remove the possibility of the network being the cause of the problem. If it still fails, then try it on someone else's C: drive.

Finally, try the same thing with sample data, both on the network and locally. If sample data works, but your real data fails, that tells you it's a data issue.

I think with the results of these tests, you will be able to determine what is causing the problem.

Top
#20983 - 02/12/10 09:39 AM Re: Posting issue with Invoices and A/R [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Are you certain that the posting process really hung, and that it wasn't just a user getting impatient with a process taking longer than normal? How was the program "stopped"? Show your user how to add the read I/O bytes and write I/O bytes columns to the task manager so that they can see whether a program has appeared to hang just because the disk got busy.
_________________________
Andrew Bates

Top
#20985 - 02/12/10 10:47 AM Re: Posting issue with Invoices and A/R [Re: Retired_Guy]
DenisM Offline
Adagio Groupie

Registered: 06/28/06
Posts: 16
Loc: Estevan, Saskatchewan
Thanks for the suggestions. The problem appeared when posting this batch, not and others before now. The main difference was these were the first batches with such a large number of items. I tested this last night, and it hung for me as well. I waited 10 minutes for the two invoices to post, and windows came back said the program was not responding. I also tried posting from two other workstations with exactly the same response. The only thing I did not try was to copy the data to the workstation hard drive. I will do that tonight as I am one the road today. I will do as you suggest Andrew and turn on the option you suggest, although I am not familiar with it. I am sure it will be easy to find. Thanks again. I will update you tommorrow.

Top
#20986 - 02/12/10 10:54 AM Re: Posting issue with Invoices and A/R [Re: DenisM]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Just a FYI that getting a "Not responding" message about an application is completely meaningless in Windows. It more usually means that the application is too busy doing something (like writing records to the disk or downloading information from the network) to process a mouse click, than that the application has hung.
_________________________
Andrew Bates

Top
#20997 - 02/13/10 07:03 PM Re: Posting issue with Invoices and A/R [Re: Retired_Guy]
DenisM Offline
Adagio Groupie

Registered: 06/28/06
Posts: 16
Loc: Estevan, Saskatchewan
I spent quite a bit of time today doing testing on this problem.
First off, I copied the data to the local "C" drive as Steve suggested and posted there. It posted the batch with two invoices totalling over 700 items in 15 seconds flat, versus 28 minutes on the Novell server. A testament to your code Andrew. I turned on the option you suggested Andrew, and I could see the reads and writes happening as you described. Suspecting a network or Novell problem, I copied the data to the Windows Terminal server, where it took almost 35 minutes to post! My next step was to connect the workstation and both servers to a new gigabit ethernet switch, with nothing else connected. The test post was repeated. It made no difference. It still took about 28 minutes on the Novell server and 35 minutes on the Terminal server. I then installed the Adagio software on the Terminal server, connected via remote desktop and posted. The data posted in less than 15 seconds, the same as with the local copy on the workstation. It appears when the number of line items in a batch gets large that the network becomes an issue. I am wondering if keeping the data and programs on the Terminal Server would be a bad idea in this case. There is seldom more the three or four users working at one time, and mostly they are are on different data sets at the same time. The Terminal server notes say this is not a recommended or supported method.
Do you have any other suggestions? They do not appear to have posting issues untill the large line item invoices are posted. Thanks for your assistance!

Top
#20998 - 02/14/10 09:56 AM Re: Posting issue with Invoices and A/R [Re: DenisM]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
I vote for either their virus checker on the server getting in the way, or an old, flakey, 10 Mbit hub connecting them to the server.
_________________________
Andrew Bates

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
1 registered (AudreyQuick), 54 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14472 Topics
70682 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31