#65852 - 03/25/21 03:00 PM
Re: G/L Detail Listing - Locking Files
[Re: JWH]
|
John Hancock, CPA
Registered: 07/30/12
Posts: 317
Loc: London, ON
|
Thanks in advance Support files have been uploaded.
_________________________
John Hancock John W. Hancock & Assoc. Ltd.
|
Top
|
|
|
|
#65853 - 03/25/21 04:31 PM
Re: G/L Detail Listing - Locking Files
[Re: JWH]
|
Adagio Action Team
Registered: 03/09/99
Posts: 11559
Loc: Vancouver, BC Canada
|
Hi Scott,
Based on the integrity errors that exist in the 'After' data for 8 particular accounts, I believe the problem to have happened when batch 1028 was posted. It was the first batch posted after the 'Before' data backup was made. I determined this because for the one income statement account that had an error, the difference between the Net changes and the Posted Transactions for period 12 of year 2021 is exactly the amount posted to that account by batch 1028. Another batch 1031 posted about 4 hours later contained that same account and it was included in the Net Changes value.
Prior to retrieving batch 1028 from Payables and posting it, 2 other users, different than the user who retrieved and posted the suspect batch, had printed the Detail listing report earlier in the day. One user printed it twice, both about an hour before batch 1028 was posted. They had closed the GL program prior to batch 1028 posted. The other user had printed the detail listing once, about 10 minutes before batch 1028 was posted. They did not exit Ledger until they did the retrieve and post for the other batch 1031.
This doesn't prove nor disprove anything as to how the integrity errors started. It's interesting that there were a number of other accounts posted to from batch 1028 that do not show any integrity errors.
I will email you offline with more specifics, rather than the forum posting here. We can post a solution when we know more.
R&D indicated to me that they couldn't see any differences in the code between GL 9.3A and 9.3B in regards to the Detail Listing report and file handling. But investigation is still ongoing.
_________________________
Regards, Softrak Tech Support
|
Top
|
|
|
|
#65855 - 03/26/21 06:38 AM
Re: G/L Detail Listing - Locking Files
[Re: Softrak Support]
|
John Hancock, CPA
Registered: 07/30/12
Posts: 317
Loc: London, ON
|
Many thanks for you investigation and effort. Got you email and reviewing.
I am convinced it has something to do with the Detail Listing FWIW. I can replicate the file locking of the GLNUMB*.* files on my end and only when I exit Ledger do they get "released". Unfortunately I can not replicate the data corruption. Not sure who posted from Support yesterday but you could on your end replicate that the GLNUMB*.* files do not lock in V9.3A but do in V9.3B.
Regarding your analysis if the user printed the detail listing 10 minutes prior to 1028 being posted and did not exit the Ledger system my assumption is the GLNUMB*.* files are at that point locked and the issue appears. But why did other accounts post OK? That is the maddening part of this.
I am hoping R & D can find something at least correct the issue of the file locking on those files.
So as a pain in the you know what as it might be for the time being before they post anything in Ledger will have:
1. All users will communicate with each other and exit out of Ledger. 2. One user will go back in and check data integrity. 3. User will backup the Ledger data. 3. User will post the batch. 4. User will re-run data integrity to make sure all OK. 5. User will backup Ledger data again.
Thanks in advance for any further investigation and posts on this issue.
_________________________
John Hancock John W. Hancock & Assoc. Ltd.
|
Top
|
|
|
|
#65856 - 03/26/21 11:38 AM
Re: G/L Detail Listing - Locking Files
[Re: JWH]
|
John Hancock, CPA
Registered: 07/30/12
Posts: 317
Loc: London, ON
|
Support their Next fiscal '2022' is open.
Assume this shouldn't make a hill of beans difference but at this point thought I should mention FWIW.
_________________________
John Hancock John W. Hancock & Assoc. Ltd.
|
Top
|
|
|
|
#65861 - 03/27/21 07:02 AM
Re: G/L Detail Listing - Locking Files
[Re: JWH]
|
John Hancock, CPA
Registered: 07/30/12
Posts: 317
Loc: London, ON
|
Support using the above procedures for posting batches there were no issues yesterday at said client.
Any word from Development?
_________________________
John Hancock John W. Hancock & Assoc. Ltd.
|
Top
|
|
|
|
#65864 - 03/29/21 10:17 AM
Re: G/L Detail Listing - Locking Files
[Re: Softrak Support]
|
John Hancock, CPA
Registered: 07/30/12
Posts: 317
Loc: London, ON
|
Thanks Support keep me posted.
_________________________
John Hancock John W. Hancock & Assoc. Ltd.
|
Top
|
|
|
|
#65868 - 03/29/21 11:46 AM
Re: G/L Detail Listing - Locking Files
[Re: Softrak Support]
|
Adagio Maestro
Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
|
Has the service pack in question been halted for download? GL detailed listing is probably the most used report during this week (fiscal year end for all First Nations and most NFP's)
_________________________
Dan Desautels DezTek Solutions Inc. Thunder Bay, ON
|
Top
|
|
|
|
|
1 registered (Douglas Dickie),
79
Guests and
0
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14473 Topics
70688 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
|
|
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
|
|
|