Hi Vineet, before I add this in as a Software Defect, can you confirm the following: I have tested this in DEMO and was not able to cause the JIWA activation to fail or for a reconciliation difference to occur. 

1. Using the Standard Demo Database (10.0.0.18, LinkSOFT-DEMO)
   1. Create one transaction in POS with Rounding and send it to JIWA.
      1. Use a day where there are NO OTHER TRANSACTIONS so we can easily work out where the issue is.
      2. Activate and confirm if there is an issue with activation. Also, check the reconciliation report and confirm if it is OK. This will allow us to validate a single entry works correctly.
   2. Now perform 10 entries with a mix of Rounding and Non-Rounding transactions. 
   3. Repeat 1.1.1 and 1.1.2 above and confirm if this reconciles.
2. Note that I did the above two steps in our DEV and was able to balance.

Once you confirm the above two items, we can look at the OTGL database and see what is missing.

Bula Sanjay

I have done 47 transactions in 3 different shifts using Linksoft-Demo on QA8. The rounding was spot on. See below transaction details. 

I am unsure what has happened in the OTGL database. However, note that this is not an issue with their Jiwa 6513 integrated into Linksoft at the moment. We have faced this in Jiwa 7. I have tried to study the data for shift SRSH0000012939 but all lines seem to have correct rounding.

Please review this on the QA4 setup to see what we can do to resolve this on the client database.

Thanks
Vineet Ram
222 0085

Hi Vineet, discussion notes:

1. Using JIWA and OTGL Database, the analysis was done on JIWA Sales Order: 0000000002, Shift: SRSH0000012939
2. We found that JIWA is recalculating the TAX and Extended Line Totals to 6 decimal places, causing there to be a difference between LinkSOFT and JIWA
3. LinkSOFT sends the following information to JIWA:
   1. Unit Price (4dp)
   2. Line Tax Charged (2dp)
   3. Line Total (4DP)

The analysis can be seen on This Google Sheet.

Bula Guys

We have logged case JIWA-10774 Sales Order Ordered Ex-GST is greater than the Delivered Ex-GST. We will monitor this with Jiwa for now

Thanks
Vineet Ram

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

Teams Meeting - Vineet and Sanjay. 9 AM to 6 PM AEST.

Meeting Notes:

1. Analysis shows that the Sales Order created in JIWA is correct and matches between LinkSOFT and JIWA, however, when the order is amended in JIWA, all the Tax and Line Total numbers changes. It is crucial, therefore to make sure users DO NOT edit the Sales Orders in JIUWA before Activating in JIWA as the amounts in LinkSOFT have been signed in VMS.
2. There are some instances where the JIWA TAX amount and "This Delivery" amounts are different to LinkSOFT by a few cents. This seems to be caused by JIWA Recalculating the Tax Amount and then adding this to the existing "Line Total Without Tax" to calculate the "Line Total With Tax".
3. Jiwa "This Delivery" Before GST + GST does not equal the "This Delivery INC GST". We were able to make this number match when we rounded the Sales Order Line "CurrentLineTotal" Field to 2 decimal places. This amendment is in LinkSOFT Version 14.90 BETA2 +
   1. JIWA Sales Order Line UPDATE: UPDATE SO_Lines SET CurrentLineTotal = round(CurrentLineTotal,2) WHERE InvoiceHistoryID = 'XYZ'
4. After applying this change, we performed several tests for entire Shifts to try and cause the JIWA Sales Order Line Totals and Tax (for This Delivery Amounts) to deviate from LinkSOFT. We were not able to cause a difference between LinkSOFT And JIWA. We will perform further tests in the release phase.

Next Step: UAT and Volume Tests

Bula 

This has been tested on the below database with the following steps:

1. Activated Sales Order for 01/01/2023 to 05/01/2023
2. Activated the Cash Books Receipts created. (~130 Cash Book Batches)
3. All were activated without allocation errors.

Test Environment Details:

1. LINKQA4\CP1
2. CLIENT-OTGL-LinkSOFT-HQ
3. http://10.0.0.18/Linksoft

You can review and close this case.

Thanks
Vineet Ram