WebSAMS Old NCSI Jira Case

Operational problem

260150

匡智獅子會晨崗學校

[email protected]

FMP

Data problem

UNRESOLVED

Impact to particular school only, operation timeline is impacted.

Sat, 5 Mar 2022 10:20:17 +0800 (HKT)<br />Kenny Leung: <br/> Assigned to Wilson to help check this case.<br /><br />Mon, 7 Mar 2022 14:40:22 +0800 (HKT)<br />Please execute the below sqls and return us the results in excel. <br/> <br/> select * from TB_FBK_GENERAL_LEDGER where acct_year = 2021 <br/> select * from TB_FBK_BUDGET_TRANSACTION where acct_year in (2020, 2021) <br/> select * from TB_FBK_JOURNAL_ACCTLINE where acct_year = 2021 <br/> select * from TB_FBK_JOURNAL_HEADER where acct_year = 2021 <br/> select * from TB_FBK_VOUCHER_DETAILS where acct_year = 2021 <br/> select b.* from TB_FBK_VOUCHER_DETAILS a join TB_FBK_VOUCHER_ACCTLINE b on a.voucher_no = b.voucher_no where a.ACCT_YEAR = 2021 <br/> <br /><br />Mon, 14 Mar 2022 15:23:20 +0800 (HKT)<br />Kenny Leung: <br/> Requested user for the above details.<br /><br />Mon, 14 Mar 2022 16:52:43 +0800 (HKT)<br />Kenny Leung: <br/> Replied by user that her user right in this school does not include the required data management right for the running of SQL, as the arrangement of DM right is pending due to the VPN issue. <br/> <br/> For our additional information, user has performed a similar reallocation of project costs in another Hong Chi School, but with the JV saved just ONCE, and the reports in that school are tally. She just wonders if the JV was saved more than once will affect the balances in the budget reports as she can recall the JV which she has adjusted and saved for a second time in the WebSAMS of Hong Chi Lions Morninghill School.<br /><br />Tue, 15 Mar 2022 09:37:00 +0800 (HKT)<br />Please help get the audit trail<br /><br />Mon, 21 Mar 2022 15:34:23 +0800 (HKT)<br />Andrew: <br/> User reported the problem might be similar to <a href="https://helpdesk.hk.ncs-i.com/browse/WPSII-80134" title="Discrepancies were found between the variance report (FBG003) and trail balance (FBK009)"><strike>WPSII-80134</strike></a> and inform us to check first<br /><br />Mon, 21 Mar 2022 15:40:22 +0800 (HKT)<br />Andrew: <br/> In addition, the variance between the FBG and FBK report for both <a href="https://helpdesk.hk.ncs-i.com/browse/WPSII-80387" title="The FMP reports FBG004A(expenses variance report) and FBK009(Trial Balance) for February, in which, the expenses from the two reports do not agree with one another."><strike>WPSII-80387</strike></a> and <a href="https://helpdesk.hk.ncs-i.com/browse/WPSII-80134" title="Discrepancies were found between the variance report (FBG003) and trail balance (FBK009)"><strike>WPSII-80134</strike></a> appeared to be caused by adjusting and saving a journal voucher for a second time. Perhaps we can make use of the information from <a href="https://helpdesk.hk.ncs-i.com/browse/WPSII-80134" title="Discrepancies were found between the variance report (FBG003) and trail balance (FBK009)"><strike>WPSII-80134</strike></a> first<br /><br />