Subject: | Invoice Listing Report to compute Annual Maintenance split for Licence Revenue |
Summary: | A new report is needed to determine the Licence Revenue split for resellers. Requirements are as follows: - Report Description: This report calculates licence fees to charge based on selected parameters.
- Report Name: Licence Revenue Analysis Report
- Input Parameters:
- Date From and Date To
- Date Type: Option is: "Invoice" or "Receipt".
- Item Classification - Use wildcard enabled search. So we want to put in LINK% and we should get all invoices with items assigned to product codes starting with the word LINK
- Less Reseller Rebate %. This will be used in the calculation later on
- Less Taxes %. This will be used in calculations later on
- Conversion rate. This will be used in calculations later on
- The report should display the following columns:
- Date
- Customer Code
- Invoice Number
- Reference No
- Order No
- Qty
- Unit Price (Excl Tax)
- Tax Amount
- LineTotal (Excl Tax)
- Add totals on the following columns: Line Total
- Add the following below the total in 5. above:
- Less Reseller Margin. This amount = 3.4 * 5 above
- Less Taxes. This amount = 3.5 * 5 above
- Licence Fees subtotal = 5 - 6.1 - 6.2
- Conversion Amount. This amount = 3.6 * 6.3 above
- Sort records by Date, Customer Code, Invoice Number
|
Audit Notes: | |
14 Mar 2018 | 12:52PM Comment 1 by Sanjay (Link Technologies) Case 9212 added to project 9.3 |
16 Mar 2018 | 09:49AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 16-03-2018 09:49 AM Time Taken: 4.00 |
| The report has been designed in FMSPORTAL. Ready for UAT. |
|
16 May 2018 | 03:56PM Comment 3 by Alvis (Link Technologies) Case 9212 removed from project 09.4 |
16 May 2018 | 03:56PM Comment 4 by Alvis (Link Technologies) Case 9212 added to project 09.4 |
24 May 2018 | 03:26PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2018 03:26 PM Time Taken: 1.00 |
| System test completed. Verified the report "Licence Revenue Analysis (ERP)" is showing data extracted from JIWA sales order based on item classification. |
|
06 Jun 2018 | 07:50AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 07-06-2018 12:00 AM Time Taken: 2.00 |
| Hi Alvis, This case has been tested and below are the results Test Environment - Version 9400 Beta 4
- Database - LINKSOFTNEW and JIWA on QA1
- Application on QA1
- OS - Windows 7
- URL - http://10.0.0.11/FMSPortal/Account/Login.aspx
Below is the test results. Test | Description | Status | 1 | Activate sales order 100495 with the initiated date as 03/05/2018 | Pass | 2 | Generate the reports with date 03/05/2018, Reseller Rebate as 30 and Taxes as 9. The report should be generated without errors. Tested PDF, Crystal and ViewDatain Grid | Pass | 3 | Records for sales order 100495 should be in the report. Date = 03/05/2018, Invoice = 100495, Order No = 10356, Part No,Description and Quantity from SO | Pass | 4 | Unit Price (VEP) and Line Tax are extracted from the SO. Line Total should be quantity x unit price. For item 573066 Line Total should be 45.01. | Pass | 5 | Reseller amount should be Line Total x Rebate Rate. For item 573066 Reseller amount should be 13.50 (45*.3) | Pass | 6 | Taxes should be calculated with the less rate of 9. For item 573066 taxes amount should be 2.84 ((45-13.5)x0.09) | Pass | 7 | License Fee should be Line Total less Reseller amount and Taxes. For item 573066 License amount should be 28.67 (45-13.5-2.84) | Pass | 8 | The report was generated with the conversion rate of 0.6669 (Fiji has 4 digits). Conv Amount should be 19.12 (28.67x0.6669) | Failed. The report is calculating the conv.amount using conv.rate with 2 decimal places. The report was generated with rate 0.6669. However the conv.amount was calculated with 0.67 | 9 | Generate the report with item classification as "Food", this should only populate "SUTS-83" and "0U-PeasIN" for SO 10495 | Pass |
|
|
06 Jun 2018 | 01:42PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-06-2018 01:42 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 9.4 Beta5 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed the Report API to use DECIMAL(14,4) data type for conversion rate.
2. The issue was caused by: - Report API was using 2dp for conversion rate calculation.
3. Next Step - UAT
|
|
08 Jun 2018 | 02:10PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 08-06-2018 02:10 PM |
| Proceed with UAT |
|
11 Jun 2018 | 09:12AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-06-2018 12:00 AM Time Taken: 1.00 |
| This case has been successfully tested. Test Environment. - Version 9400 Beta 5
- Database - LINKSOFTNEW on QA1
- Application on QA1
- OS - Windows 7.
Test Plan The report was generated with the conversion rate of 0.6669 (Fiji has 4 digits). Conv Amount should be 19.12 (28.67x0.6669) | Pass. |
Next Step: Document case |
|
13 Jun 2018 | 07:54AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-06-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, Documentation on the case has been completed. - Financial Management System -- Business Intelligence -- Reports -- License Revenue Analysis Report.
Thanks Rashna |
|
13 Jun 2018 | 08:00AM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-06-2018 08:00 AM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 12 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 |