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)

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

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

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.