What populates CURRNIDX on SOP10105 table?
Client has MC registered for USD (only currency in use).
Currency ID = 'USD'
CURRNIDX = '1008'
Client is working with k-commerce integration which pulls transaction currency ID from CURRNIDX on the SOP10105 table. K-commerce integration is failing as a result of CURRNIDX showing value of 0. Below set of queries and screenshot of results follow a sample transaction and respective setup tables that displays the issue nicely.
Note 1: Some transactions have the correct CURRNIDX value of '1008'.
Note 2: client uses Avalara Avatax for tax calculation
SELECT * FROM MC40000
SELECT CURNCYID, * from RM00201
SELECT CURNCYID, * FROM RM00101 WHERE CUSTNMBR = '105626'
SELECT CURRNIDX, * FROM SOP10105 WHERE SOPNUMBE = 'INV142564'
SELECT CURRNIDX, CUSTNMBR, * FROM SOP30200 WHERE SOPNUMBE = 'INV142564'
SELECT CURRNIDX, CUSTNMBR, * FROM SOP30200 WHERE SOPNUMBE = 'ORD132066'