Company: Link Technologies
Case No: L11859. Project: 12.10: LinkSOFT version 12.1
Logged By: Sanjay (Link Technologies) on 13 Dec 2019 10:52AM
Priority: Low
Product: Framework
Group: New Feature
Time Taken: 52.00 (Weight: 52.00)
Version: 12.10.1020
Assigned To: Development
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 14 February 2020 04:34 PM [1568 days since logged date]
Status: Closed
Subject: LinkSOFT FRCS VMS Integration with Vodafone Web Billing - TOPUP System
Summary:    

1. Introduction

The purpose of this document is to outline the design of FRCS VMS integration to ERP Systems.  The complete document is available at this link.

The system proposed in this document will extract Invoices from The ERP system, Sign the invoice through FRCS VMS and Email the signed invoice to the customer. The following functionality will be available in the standard LinkSOFT Framework:

  1. A scheduled process that can be configured to Load invoices required for FRCS signing, Sign the invoice and Email the invoice to the customer

  2. Full FRCS Compliance including audit requirements

  3. Ability to review emails sent to customers and view attachments

  4. Ability to set email templates

  5. Ability to resend customer invoices

2. Design

The LinkSOFT application needs to be installed on the WEB server and configured to connect to a SQL database server. The database server will contain the LinkSOFT database which contains the necessary objects to perform the integration to FRCS and to provide a framework to manage audit logs and emails.

2.1. Summary Design Notes

Below is a summary of this design

  1. LinkSOFT will be installed on the Web Server and will connect to a SQL server (version 2008R2 or above)

  2. Two views will be created to list the Invoices that require VMS Signing

  3. LinkSOFT will have a scheduled task which will Sign the invoices and send a PDF to the customer's Email address. 

    1. The frequency of the scheduled task will be configurable. 

    2. The report layout will be defined in Crystal Reports. 

    3. The Email body will be configurable.

  4. Once the invoice is signed, a procedure will be called to update the “External ERP” system to mark the invoice as “Signed”.  This invoice will no longer appear in the views (refer to 2.1.2 above)

Audit Notes:Edited by sanjay on 08/04/20 15:15. Edited by sanjay on 12/02/20 16:38. Edited by sanjay on 12/02/20 13:12. Edited by sanjay on 12/02/20 13:10. Edited by sanjay on 17/01/20 13:02. Edited by sanjay on 17/01/20 13:02. Edited by sanjay on 15/01/20 11:08. Edited by sanjay on 15/01/20 09:42. Edited by sanjay on 06/01/20 18:05. 
29 Jan 202008:50PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-01-2020 08:49 PM
Closing this case as we will handle this change in case LL883

12 Feb 202001:11PM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 14-02-2020 01:10 PM
Reopen case - refer to The complete document is available at this link.

12 Feb 202004:37PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-02-2020 04:34 PM Time Taken: 48.00

Completed the following:

  1. Setup environment for the VFL system
  2. Discussion with Prasant - re-billing tables
  3. Development of API for Vodafone WEB Billing
  4. Complete System tests on the billing

Next Step:

  1. System Test with Alvis and Prasant

Sanjay/Alvis/Rashna

--- Notes

--Web TOP UP
Use tax label - A (VAT)
Sign when TopTransactionLogs.Status = 7 (Mobile has been topped up)
All amounts are inclusive of taxes. There are no discounts
Cashier TIN will be configurable
1 signature per entry on the transaction table.
Email PDF signed document to customer

select *
FROM TopUpTransactions t
JOIN TopTransactionLogs l ON t.ID = l.TopUpTransaction_Id and l.Status = 7

--Ezy Top Up
Use tax label - A (VAT)
Sign when TopTransactionLogs.Status = 4 (Mobile has been topped up)
All amounts are inclusive of taxes. There are no discounts
Cashier TIN will be configurable
1 signature per entry on the transaction table.
Email PDF signed document to customer

select *
FROM EzyTopUpRegistrations t
JOIN EzyTopUpTransactionDetails d ON t.ID = d.EzyTopUpRegistration_ID

12 Feb 202004:58PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-02-2020 04:43 PM Time Taken: 2.00

Hi Rashna,

Please update the framework documentation when using the SQL API.

When using SQL API where the Server is located on a different machine (Different IP Address), the "Distributed Transactions Coordinator (DTC)"  needs to be configured.

To configure DTC, follow these steps:

  1. Enable the DTS Service on the remote machine. Refer to figure 1 below.
  2. Configure the Firewall on both machines to allow DTC for all 3 (RPC, RPC-EPMAP, TCP-IN) in the Inbound and Outbound Rules. Refer to figure 2 below
  3. Go to "Administrative Tools > Component Services > Computers > My Computer > Distributed Transaction Coordinator". Right-click on "Local DTC", select "Properties" and set the options shown in figure 3 on both SQL Servers machines. 
  4. Restart both machines

Assign the case back to me once you have documented.

Figure 1: DTS Service


Figure 2: Firewall configuration for DTC



Figure 3: Component Services Configuration


13 Feb 202008:41AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 19-02-2020 07:37 AM Time Taken: 1.00

Hi Alvis, 

I have completed documentation. following sections have been updated,

  1. Linkweb - Integration Setup
  2. Add a page as "Framework Enable Distributed Transaction Coordinator" under Technical References.
Thanks
Rashna


03 Mar 202008:47AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-03-2020 08:46 AM Time Taken: 1.00
This work has been completed and tested by Datec. Datec will take on the implementation from this point.

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11859 in the subject line of all emails regarding this issue.

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