Company: Link Technologies
Case No: L08558. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineet (Link Business Solutions) on 26 May 2017 02:42PM
Priority: High
Product: Payroll & HR
Group: New Feature
Time Taken: 11.00 (Weight: 11.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Vineet
Resolve By: Friday, 02 June 2017 12:00 AM [2973 days since logged date]
Status: Closed
Subject: Create new report for Creditor GL Transactions
Summary:    

Create a new report for Creditor GL Transactions. 

Report parameters:

  1. Date From
  2. Date To
  3. GL Account From
  4. GL Account To
  5. Creditor Account No From
  6. Creditor Account No To
  7. Invoice No (data retrieved from: SELECT InvRemitNo FROM CR_Trans)
  8. Reference No (data retrieved from: SELECT Ref FROM CR_Trans)
  9. Group By: C=Creditor, G=GL Account. Default to G.

Report Layout:

Grouping by GL Account


Grouping by Creditor Account:


Audit Notes:
29 May 201707:08AM Comment 1 by Vineet (Link Business Solutions) Case 8558 added to project Customization-Client
29 May 201707:08AM Comment 2 by Vineet (Link Business Solutions) Case 8558 added to project Customization-Client
29 May 201703:24PM Comment 3 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 29-05-2017 03:24 PM Time Taken: 6.00
Development work for this case has been completed.
The change will be available in version: 8.12
Documentation update required(Yes/No. Add change details below): 
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Designed report in FMSPortal.

Documentation details:
  

04 Jun 201706:27PM Comment 4 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-06-2017 12:00 AM

Hi Rashna

Please kindly test these report in 8.12. You can get the FMS Portal link for 8.12 from Alvis as he has hosted this on Dev Server. This link points to Client upgraded DB on QA4

Regards
Vineet Ram


20 Jun 201702:27PM Comment 5 by Alvis (Link Technologies) Case 8558 removed from project Customization-Client
20 Jun 201702:31PM Comment 6 by Alvis (Link Technologies) Case 8558 added to project 8.12
26 Jun 201703:11PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-06-2017 03:11 PM Time Taken: 3.00
1. Was this test completed using Demo / New / Other database? Client Database
2. Did the test pass or fail? Failed
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? Pass
4. Data verified, saved, edit, delete/void?
5. Documentation update required?
Additional Details (Risks, issues, special conditions required for this test to pass etc):

Hi Alvis, I have set the 6513 and 7175 database in QA4 as 

  • CLIENT-JIWA-6513
  • CLIENT-JIWA-UPGRADED

We hosted FMIS in QA1 and made a connection as Test 3 in QA4.

We generated the Creditor GL Report in FMIS and JIWA 6513. The two reports were successfully generated the  figures do not tie.

Filters 

  • Date from - 01/01/2016
  • Date to  - 25/02/2016
  • Creditor From - 94
  • Creditor To - SWCU
  • Group by - Creditor 

Refer to the credit balance for creditor 96 on the two reports.

Figure 1 : Report in 6513 


Figure 2: Report in 7175



28 Jun 201708:14AM Comment 8 by Alvis (Link Technologies) Case 8558 removed from project 8.12
28 Jun 201708:14AM Comment 9 by Alvis (Link Technologies) Case 8558 added to project LINKFJ
30 Jun 201708:47AM Comment 10 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-06-2017 08:47 AM Time Taken: 1.00

Hi Rashna,

I have re-run the reports and the figures do tie. See screenshot below:




regards
Alvis


11 Jul 201709:06AM Comment 11 by Alvis (Link Technologies) Case 8558 removed from project LINKFJ
11 Jul 201709:06AM Comment 12 by Alvis (Link Technologies) Case 8558 added to project 8.12
25 Jul 201707:47AM Comment 13 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 25-07-2017 07:47 AM Time Taken: 1.00
UAT and Documentation on the case has been completed.

09 Oct 201908:14AM Comment 14 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
If you have any queries regarding this support incident, please email Support@LinkTechnologies.com.au and include the Case No: L08558 in the subject line of all emails regarding this issue.

Document size: 4.6 KB
For call complaints, please contact the Managing Director of the company using this form.