SDC Processing fails for items which have quantity decimal places in excess if 3 digits. 

2. Error Message (Include screenshot of error)

SDC Processing Failed.

SQL Log Message

Log Message:Error processing ESDC Tax Integration.

Log Data:{"OrderLines":[{"Line":1,"ProductCode":"1121","Description":"Imported Leek KG","UnitPrice":16.00000000,"Quantity":0.00060000,"TaxCode":"TAXIN","TaxAmount":0.00,"Discount":0.00,"LineTotal":0.01,"Deleted":false,"ReceiptDescription":"0.00060000 x $16.00 Imported Leek KG"}],"TransactionID":"LTTX0000988022","TransactionDate":"2018-11-08T11:13:35.4","TransactionType":null,"TransactionTypeInt":1,"ReferenceNo":"LTK10000985060","DocumentNo":"","CustomerCode":"POSCASH-201811","ShiftID":"LTSH0000003936","UserName":"0240"}

3. Relevant History Information

We provided the above log data to SOFTSDC. Below is the response from them.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Dear Mr. Prasad,

thank you for reaching out.

The issue you are experiencing is due to inadequate UnitPrice and Quantity values.

We have developed our app following the instructions for developers from FRCS website: 

Meaning, the minimum value for Quantity is 0.001 and should have 3 decimal spaces and your POS displays Quantity:0.0006 (4 decimal spaces)
Next, the value for UnitPrice is limited to 2 decimal spaces and your POS displays 27 decimal spaces in several cases. However, this amount will be accepted, but please follow the instructions for developers in order to prevent further possible error messages.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

FRCS file-spec can be found here. Please refer to page 28 for specifications. We also need to fix unit price decimal place.

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

Hi Sanjeet, in the case where the Quantity is for example 0.0001, what do you want shown in the SDC?. See example below.

Figure 1 - Quantity < 0.0005

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

1. Quantity rounded to 3DP
2. Unit Price rounded to 2DP

Regarding Note 4 in comment 5, the SDC value is rounded to 3 DP as this is a limitation on the SDC system. The POS system will continue to store values in the actual decimal value.

The Minimum SDC value of 0.001 needs to be accounted for when implementing prices, especially in scale systems.

For SDC Processing, the UNIT PRICE is calculated from the "Line Total" and "Quantity' sold. This is done to handle discounts and to ensure that the SDC line total correctly reflects the unit price and quantity sold.

Hi Sanjay, 

1. SDC fails when quantity is 0.0004 or less. 

Notes:

When the quantity is less than 0.001 and more than 0.0006. Quantity will be rounded to 0.001, here the unit price will be recalculated as per the line total.

Thanks
Rashna

Changes to SDC integration to facilitate limitations and rules:

1. Move the "global SDC enabled" configuration to the LinkWEB integration.
2. Add the following rules:
   1. Minimum quantity for a product. Datatype decimal, value 0.001.
   2. Allowed Tax labels (comma separated) value: E,A,F,P

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

1. Moved Global SDC configuration to "Integrations" framework
2. Added rule to validate "minimum Product Quantity" on Transaction Save (Before SDC is processed)
3. Added rule to validate "Tax Labels" on Transaction Save (Before SDC is processed)

Hi Sanjay, 

Documentation has been updated on the case.

Documentation updated under Link Web Application Portal - Integration - Integration Setup.

Thanks
Rashna