Company: Link Technologies
Case No: L11883. Project: 12.10: LinkSOFT version 12.1
Logged By: Sanjay (Link Technologies) on 15 Jan 2020 11:08AM
Priority: Medium
Product: Framework
Group: New Feature
Time Taken: 134.00 (Weight: 160.00)
Version: 12.10.1020
Assigned To: Sanjay (Link Technologies)
Circulation: DatecFiji, Sanjay
Resolve By: Wednesday, 22 January 2020 03:15 PM [1535 days since logged date]
Status: Closed
Subject: Sign and Email invoices created in SAGE 2019.3
Summary:    

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) 
Audit Notes:Edited by sanjay on 23/01/20 14:58. Edited by sanjay on 23/01/20 09:48. Edited by sanjay on 21/01/20 15:33. Edited by sanjay on 21/01/20 15:28. Edited by sanjay on 15/01/20 11:08. Edited by sanjay on 15/01/20 09:43. Edited by sanjay on 15/01/20 09:42. Edited by sanjay on 15/01/20 09:41. Edited by sanjay on 15/01/20 09:41. Edited by sanjay on 15/01/20 09:20. 
15 Jan 202009:22AM Comment 1 by Sanjay (Link Technologies) Assigned To: DatecFiji Followup Date: 16-01-2020 09:20 AM Time Taken: 3.00

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.


15 Jan 202003:28PM Comment 2 by DatecFiji Assigned To: Sanjay (Link Technologies) Followup Date: 16-01-2020 03:28 PM Time Taken: 1.00 Notes: Created from the WEB url sent to: asheels@datec.com.fj
Approved.

17 Jan 202002:49PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-01-2020 02:39 PM Time Taken: 20.00

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


21 Jan 202003:27PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-01-2020 03:15 PM Time Taken: 60.00

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.

Next steps:
  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



22 Jan 202005:18PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-01-2020 05:10 PM Time Taken: 18.00

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?

23 Jan 202007:46PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-01-2020 04:32 PM Time Taken: 24.00

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?

29 Jan 202008:47PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-01-2020 08:46 PM Time Taken: 8.00

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

29 Jan 202008:53PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-01-2020 08:51 PM
Closing this case as we will handle this change in case L11868

Attachments:
Sage Web APO Documents - Case: L11883:Sage300_WebAPI_EndpointReference.pdf
Sage300SDK_DeveloperReference.pdf
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L11883 in the subject line of all emails regarding this issue.

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