Credit Authorization values counted twice
Summary:
Some customers are failing credit check due to the fact that certain transactions comprised first of a Sales Order and later of an Invoice are effectively counted twice.
Please see the following Example:
- Sales Order
14785257appears to be "closed" when viewing the data via the user interface. - In the AR_CUST_CREDIT_AUTHORIZATION there is a row with column AUTHORIZATION_STATUS = OPEN for the exact same Sales Order
14785257 - Finally, the invoice
40000033related to Sales Order14785257is open and unpaid so it is being counted in the AR_BALANCE view - This amount is effectively being counted twice
I do NOT want to run Process Expired Credit Authorization because I have some order that are "expired", but have not yet shipped.
Tagged:
0