Any ESSjob to refresh the credit schema when I have some order change?
We are doing some tests about Credit Limits.
Here are our steps:
- Set a customer credit limit to $100,000.
- We created an order and the amount equal to $100,000.
- Cancel it.
- Created another order which amounts equal to $18,150.
- We got an error message below.
After that, I check the schema AR_CUST_CREDIT_AUTHORIZATION:
(SELECT
/*SR Number*/
--SUM(CREDIT_AUTH_AMOUNT)
*
FROM FUSION.AR_CUST_CREDIT_AUTHORIZATION
WHERE AUTHORIZATION_STATUS = 'OPEN'
AND CUST_ACCOUNT_ID = '300000044495516')
The order 21638 status keeps on 'open' but not 'cancel'.
Any ESS job I should run?
Tagged:
0