Hi All,
I am trying to resolve what seems to be an unusual problem and would greatly appreciate your insight.
The problems emanates after users have posted payment transactions batches that originate from the Cashbook.
Users capture and post batches from:
Transaction > Financial > Bank Management > Batches
After posting CBM Batches transactions users cannot view the source documents linked with the journal entries.
Strangely enough the transactions are copied to GL20000 which I think is the expected result from the posting journals but then when you enquire the journal entry:
Enquiry > Financial > Journal Entry Enquiry
And drill down to the source document by clicking the SOURCE DOCUMENT hyper link to view the source under the Payment Entry \void window an error 'Error in loading Enquiry Screen' is returned.
Please see the Error message below
I traced the error message via DexSQLlog FILE and found that there is a stored procedure checking for the source documents and trying to link them with journal entries in the HISTORICAL YEAR TABLE (GL30000)
See the code below:
SELECT Top 1 CB550001.CHEKBKID,CB550001.CHEKNMBR FROM CB550001, GL30000 WHERE CB550001.CB_Audit_Trail = GL30000.ORTRXSRC AND CB550001.CHEKNMBR = GL30000.ORDOCNUM AND GL30000.JRNENTRY = 1240932
I then copied the journal entry from gl20000 to gl30000 and the error message went away (disappeared) and users were able to view source documents but I DOUBT THAT THIS IS THE RIGHT SOLUTION!!!.
MY QUESTION IS WHY IS THE SYSTEM QUERYING SOURCE DOCUMENTS TRANSACTIONS AGAINST JOURNAL ENTRIES IN THE HISTORICAL FROM TABLE INSTEAD OF THE OPEN YEAR TABLE??
Note that these batches are posted to open periods.
ANY INSIGHT THAT MAY BE HELPFUL WOULD BE APPRECIATED.
MANY THANKS,
NOEL
