Bula Team,

We did a Microsoft Teams meeting and had the following discussion;

1. MYOB Integration Process - Explained how the MYOB Integration process works;
   • Invoice creation in MYOB
   • Invoice Integrated to LinkSOFT
   • Invoice signed into TIMS
2. Confirmation on Smart Card for Retail and Restaurant setup
   • We use Client-Server Architecture for setup
   • Recommended to use 1Smart card per work station
   • Krissy Company - an example of 1 Server / Workstation using 1 Smart Card
3. Showed different invoicing scenarios at Krissy Company
4. Resolved Soft SDC decimal points issue which was giving an error in signing to TIMS
5. Krissy Company fully operating live

1. Ah Liki Group HOD staff
2. Elvis Prasad
3. Rajendra Singh
4. Sitla Sharma
5. Vineshwar Prasad

REOPENED THE CASE - See email thread below

*** Email from Sitla***

***

Hi Andrew,

 

Thanks for your email.

 

Sitla and Vineshwar are the representatives from Linksoft who will be developing a solution for the TIMS compliance.

 

Hi Sitla, maybe you could please let Andrew know what you need from NCS?

 

https://www.ncssuite.com/xpedium-mobility

 

 

Local NCS server is running the below web service.

*****************************************************************************

******************************************************************************

Hi Justin, probably more a question for Andrew, will let him follow-up on this for you.

Cheers

Greg

********************************************************************************

Sanjay

Is LinkSoft cloud based or is it installed locally on the AhLiki network?

It seems we need to create 2 SQL SPROCS for you

1. The details of all transactions that have not been confirmed by TIMS
2. An Update SPROC to update transactions that they have been processed by TIMS

For the first SPROC we will likely need data from multiple table to gather the information you need.  Do you have a schedule of all the fields you need for an invoice?

Hi Team,

A proposal has been sent to the customer and there is no issue with pricing., However, this project has gone on hold due to TIMS extension on 

implementation date by IRD Samoa until 01.01.2021.

I will keep this case assigned to me for further updates.

Hi Sanjay,

As per my advice earlier, please kindly send an invoice for the 10 days development work.

I will organize the payment immediately.

Anything else you want me to organize, a meeting, or just an email conversation?

Please let me know at the earliest.

Regards,
Sitla.

Morning Sanjay, Please forward invoice .

We have completed the following:

1. Created integration Scripts templates for the SQL API
2. Sent notification to Edge to initiate Contact with Ah Liki

Attached is the SQL Template. Attachment name:  "IntegrationScriptsTemplate.zip"

Next Step: Waiting for Database containing sample data with Invoices, Quotations, Returns and Credit Notes. Please provide at least 10 transactions of each type.

1. Created SQL API procedures for Customers
2. Created SQL API for Invoice header
3. Created SQL API for Invoice Line Items
4. Created SQL API for Invoice Tax

Completed the following tasks

1. Added comments on interface and Result set for the procedure for Customers
2. Added comments on interface and Result set for the procedure for Invoices
3. Added comments on interface and Result set for the procedure for Invoice Lines
4. Added comments on interface and Result set for the procedure for Invoice Tax 

1. Refactored LinkSOFT SQL API to confirm to AhLiki SQL API Procedures
2. Tested ARMaster Import using another FMIS system (JIWA) - Pass
   
3. Tested ARMaster Import using another FMIS system (JIWA) - Pass
4. Tested ARInvoice Import using another FMIS system (JIWA) - Pass
5. Tested ARInvoiceLines Import using another FMIS system (JIWA) - Pass
6. Tested ARInvocieLienTax Import using another FMIS system (JIWA) - Pass
7. Tested TIMS using signing - Pass

Hi Sitla, Please send to Greg and copy everyone else

*** Start of email ***

Hi Greg Mellis,

Attached are the templates for the 4 SQL Procedures that we require. Attachment name: "IntegrationScriptsTemplate.zip"

Each procedure template has detailed comments on the procedure interface as well as the "result set" that is required. 

Three procedures will return data to LinkSOFT and the last procedure will be called with details of TIMS completion Success/Failure. Full comments on how this will work are on the procedure.

Our team will have a discussion with the operational team on "TIMS Tax code" requirements before we organise a discussion with Sanjay.

Once your technical team has reviewed these "Procedure templates", we can have a conference call with Sanjay to go through any questions/comments

Regards

*** END of email ***

Please kindly advise your availability.

Regards, Sitla.

We had a meeting with Greg, Sitla, Justin and Sanjay. Sitla will send details meeting minutes. here is a summary of what was discussed:

1. Review the 4 procedures and explain how to update the procedure
2. Sitla has not discussed Tax details with Ah Liki, she will get on to this
3. Greg will review the changes required and come up with a plan by next week Wednesday. Sitla to set this meeting up

Hi All,

Following this email you should get a second email with the following attachments.

1. A SQL Server DB Back-up of MobilityConsoleAHLTST. This is a cutdown Ah Liki Test Database. With Two sets af Processed HH uploads into the Staging Tables so you can run the LT… Stored Procedures.
2. A SQL Script that will Append the next BATCH of Transactions in August to the LT Staging Tables so if you want to generate more Test Data you can up to a point of using up all the Batch Numbers.
3. A Spreadsheet that shows the Results of the Test Script being Run Twice Last Night before this back-up was Taken. So ths Data should be immediately Retreivable by calling the LT_ Stored Procedures.

Based on the Spreadsheet I sent earlier, in this database I have set the NCS TIMS Start Date SystemControl as 31^st July 2020 so I could pick up the Transactions in August.

Available Batches Left To Process in the August Test Data Are….

Also, the Database in a SQL Server 2017 Version Database as I have done the development in our AWS Cloud Server for convenience.

The Ah Liki Server is running SQL Server 2008 R2. All the code is Compliant to this version.

Cheers

Greg

Files have been placed on: \\10.0.0.9\LinkSOFT Integration\AH Liki - NCS

Next Steps:

1. Restore DB
2. Run tests to verify TIMS

PART A - Development work for this case has been completed.

1. The change will be available in version: 12.30.0108

2. The following changes were made(Include Database object names, Program classes and any other relevant information):

1. Completed testing of Integration using the files provided by Greg from AH Liki Technical support
2. Reformatted and cleaned up integration procedures
3. Updated documentation and published help files update

3. Affected Areas:

1. FRCSSDC

4. The issue was caused by:

1. New Feature

5. Notes: 
6. Next Step: UAT

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N): Yes

2. Variations to the approved design: No

Hi Rashna,

"AR Receipt View" is not part of integration for "Ah Liki Group".

The integration is to sign transactions from "AR Master View".

regards
Alvis