Datec Fiji has requested the ability to Ficialize invoices created in Sage 2019.3. This case lays out the design of how this will work.

Since the exact details and knowledge on Sage API is limited, we will design and develop this integration as we explore the API.

PART A - Controls and Processes summary:

1. Create a design and cost summary (Sanjay) ETA: 15/01/2020

2. Review, Validate and approve the summary design (Asheel) ETA: 16/01/2020

3. Development work commences (Sanjay) ETA: 16/01/2020

4. System Test and UAT (+ any rework) (Alvis/Sanjay/Kirit) ETA: 27/01/2020

5. Release ETA: 29/01/2020

PART B - Summary Requirements:

1. Using the Sage 2019.3 API, LinkSOFT will extract a list of invoices that needs to be signed by FRCS using the Inspur Device

2. The invoice will be signed using the standard LinkSOFT VMS framework

3. An email will be sent to the customer with the Signed VMS invoice. The email address to send the invoice will be extracted from the customer's record

4. Full audit and compliance required according to FRCS requirements

5. Ability to see audit trail of emails

6. Ability to preview emails before sending or select the option to Automatically send email

7. Ability to edit and resend emails

PART C - Summary Design

1. LinkSOFT will be installed on the customer's Web Server and configured with the Datec Inspur Device

2. LinkSOFT will extract "Finalised Invoices" from SAGE using the SAGE API

3. LinkSOFT will sign the invoice using the Standard LinkSOFT VMS engine

4. LinkSOFT will send an email of the signed invoice to the customer using the LinkSOFT Email Engine

PART D - Costs

1. Link Technologies will absorb the cost of development
2. An integration licence fee of 2500 will be added to the licence module. This fee will be by Server. 1 licence per server.

PART E - Pre Requisites

1. LinkSOFT 11.5 or later
2. Microsoft SQL Server 2016 or newer (for JSON Support)
3. IIS Server 7.5 or newer with Dot Net Framework 4.6 or newer (Installed with LinkSOFT 11.5)
4. Crystal Runtime 13.0.25 or newer (Installed with LinkSOFT 11.5) 

Hi Asheel,

Please Review, Validate and approve the summary design. You can add a comment "Approved" either by logging into helpdesk or adding a comment using the link at the end the email alert.

Thanks for the Approval. Status: Development in progress. Project is on time.

PART A - Development work has started. The following work has been completed:

1. Build an interface to SAGE Customers to PULL and PUSH customers from SAGE DB using WEB API (Completed and Tested)
2. Verify SAGE Web API  functionality and volume tests (Passed)
3. Build Audit logs for Sage Web API interface (Completed)

PART B - Next Step:

1. Extract Orders from SAGE using Web API
2. Extract Order Lines from SAGE using Web API
3. Repeat 1 and 2 above for Quotations, Returns and Credit Note
4. Sign Sage Invoice using LinkSOFT VMS Framework
5. Using Customers email from SAGE Customer record, send an email of the signed invoice
6. System Test with Datec Functional users - 1 transaction at a time
7. System Test with Datec Functional users - Volume transaction processing > 100 in the queue
8. System Test with Order Variations

Sanjay/Alvis/Rashna

Completed the following tasks (18th to 21st Jan: Sanjay/Alvis/Rashna)

1. Extract AR Invoices from Sage
2. Extract Customers from Sage
3. Extract Tax maintenance from Sage
4. Deserialise SAGE INVOICE, Customer and Tax Details JSON and update LinkSOFT AR API
5. Prepare invoices for VMS Signing
6. Build facade for FRCS VMS invoice signing
7. Add a scheduler interval to handle high/Real-time transaction extraction
8. Added a batch size to handle volume processing
9. Create filters for Invoice extraction (Posted/Date)
10. Added Tax Authorities for FRCS Standard Tax codes
11. Created a new invoice report with VMS Compliance
12. Performed VMS Signing and audit tracking
13. Added signed invoice to Email Queue
14. Setup Cashier TIN as a parameter on LinkSOFT Integration as SAGE does not have a USER Security API
15. Extracted CustomerTIN from SAGE.ARCustomer

End to end tests for the above items has been completed.

1. Add OEInvoices to the LinkSOFT integration platform
2. Add OEOrders to extract Quotations
3. Add ORDebitAndCreditNotes to extract Returns
4. Perform System test with Kirit/Preeti (Preeti is creating invoices in the FIJI COMPANY Sage setup to assist with this testing)
5. Perform Volume Tests
6. System Test with Datec Functional users - 1 transaction at a time
7. System Test with Datec Functional users - Volume transaction processing > 100 in the queue
8. System Test with Order Variations
9. Sanjay/Alvis/Rashna

Completed the following development today:

1. Added "Order Invoices" to the integration platform and included this in the VMS Signing process
2. Quotations in SAGE can be DELETED, therefore this will fail the FRCS Audit requirements. further discussion required. Can we remove the "QUOTE" "Delete" button? (Asheel)
3. Added Tax description to Invoice Integration so the description can be displayed in the PDF invoices
4. Sage limits 100 records per extraction. This causes an issue with master files where more than 100 entries are modified. Added function to handle 100 entry limitation in Sage API
5. Preeti has completed entering volume test entries in "AR Invoices". These have past System tests. Request sent to Preeti to do the same for "Order Invoices"
6. Added parameterised query configurations to API integration framework to handle API filters
7. System tested email process from VMS
8. System tested end to end process

Next steps:

1. Add ORDebitAndCreditNotes to extract Returns
2. Perform System test with Kirit/Preeti (Preeti is creating invoices in the FIJI COMPANY Sage setup to assist with this testing)
3. Perform Volume Tests
4. System Test with Datec Functional users - 1 transaction at a time
5. System Test with Datec Functional users - Volume transaction processing > 100 in the queue
6. System Test with Order Variations?

The following Tasks were completed:

1. Added credit notes to the VMS process 
2. Added validation to prevent large amounts from flowing into VMS. VMS Amount limit is 99,999,999
3. Added routine to log VMS failure in a batch and continue to sign other invoices
4. Added view to list pending VMS transactions
5. Performed volume tests

Issues Encountered:

1. Invoice lines cannot be Negative (see sample invoice in Sage which has a batch with negative amount)

Next Step

1. System Test with Datec Functional users - 1 transaction at a time
2. System Test with Datec Functional users - Volume transaction processing > 100 in the queue
3. System Test with Order Variations?

Completed the following

1. Round 1 of System Tests with Datec
2. Improvements to API to handle generic WEB API calls
3. Address issue with Email functionality - Issue with Crystal Runtime will be resolved in the next build