02-28-2018, 05:09 PM,
|
|
wissedenis22
Senior Member
|
Posts: 57
Threads: 24
Joined: Aug 2017
|
|
RE: double posting in both General ledger Accounting
(02-27-2018, 08:53 AM)TurboPT Wrote: Can you say from which petty cash script, such as PcExpenses.php, or some other file that this is happening?
Hello Sir,
these are the two scripts;
GLAcountInquiry.php and BankMatching.php
|
|
03-03-2018, 05:54 PM,
(This post was last modified: 03-03-2018, 06:03 PM by TurboPT.)
|
|
TurboPT
Administrator
|
Posts: 727
Threads: 10
Joined: Jun 2012
|
|
RE: double posting in both General ledger Accounting
Phil/Tim/Andy:
Any ideas as what could be contributing to this doubling issue?
The files that can write the narratives shown in the images is: PcAuthorizeExpenses, and PcAuthorizeCash.
Though there appears to potentially be some "odd handling" within those scripts, it is not clear as to how the doubling can occur.
There may be more to the picture to know?
One way that I could perceive the behavior, is if the query at line 69 (in both files, same query) could be returning more than one entry, and if so, then there may be doubles (duplicates) in pcashdetails?
The loop for that query is where the GL inserts occur.
BankReconciliation also has GL inserts, but based on the narrative message there, I don't believe this script is related. (the 'reconciliation' message is not in the attached images)
GLAccountInquiry does not have any GL inserts.
|
|
03-04-2018, 07:10 AM,
(This post was last modified: 03-04-2018, 07:32 AM by TurboPT.)
|
|
TurboPT
Administrator
|
Posts: 727
Threads: 10
Joined: Jun 2012
|
|
RE: double posting in both General ledger Accounting
@wissedenis22:
We never know (though I might be naive on this aspect) how much use that the Petty Cash module actually has by others.
So far, you are the first to report (AFAIK) this issue from this area.
Based on post #7, is there any use of the PcAssignCashTabToTab.php file? (or possible mixed use of the two?)
If so, can you try (if possible) to avoid using the 'TabToTab' option for a few days (or more) to see if the issue ceases?
On the Petty Cash menu, in the first column, 2nd link: the option to avoid is "Transfer Assigned Cash Between PC Tabs".
We may need to eliminate that script based on the post #7 info, especially if it is causing the trouble as you are experiencing.
If you might need to disable the option for all users, it is a simple matter to comment-out two lines. Let me know if you might need this change.
|
|
03-04-2018, 08:31 AM,
|
|
afcouling
Senior Member
|
Posts: 123
Threads: 16
Joined: Aug 2015
|
|
RE: double posting in both General ledger Accounting
(03-03-2018, 05:54 PM)TurboPT Wrote: The files that can write the narratives shown in the images is: PcAuthorizeExpenses, and PcAuthorizeCash.
Yes, I was under the impression that nothing is posted until either an expense or assigned cash is authorised in PcAuthorizeExpenses and PcAuthorizeCash.
When I implemented Tims petty cash tax code last year (not yet released), I had a close look at the petty cash GL postings, and didn't spot anything like the symptom described.
From the attachments in post #1, it appears that only assigned cash is duplicated, not expenses. Please confirm this is the case.
Also, are all petty cash tabs affected? Again, in the attachments, I can see duplication on tab 'TRAVEL' and 'COMMISSIONS', but perhaps not on 'TRANSPORT'.
https://www.linkedin.com/in/andrewcouling
|
|
|