Datanory Production » Datanory - SNEKKU

Datanory:
select * from txn_sales_order_header where order_no= 'SOMS1000405-240605'
select * from txn_sales_order_details where ord_hdr_id= '1ec63653-865f-46a7-9e2e-26531318a127'

SELECT SUM AS total_sales
FROM txn_sales_order_details where ord_hdr_id= '1ec63653-865f-46a7-9e2e-26531318a127';

at datonory side it able to view the discount
--------------------
select * from APIMiddleTable where VoucherNo= 'SOMS1000405'

select * from SOPHeader where order_number= 'SOMS1000405'
select * from SOP_Detail where order_number= 'SOMS1000405'

SELECT SUM AS total_sales
FROM SOP_Detail where order_number= 'SOMS1000405'
My soft-->

As I checked with shan The PROMO discount did not cater to the mysoft.
This will be discussed with miss jann and have to follow up with Shan you again