N:Credit Management - Open Authorization And Receivables Balance
(Doc ID 2718755.1)
Last updated on OCTOBER 17, 2020
Applies to:Oracle Fusion Receivables Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.
N:Credit Management - Open Authorization and Receivables Balance
Users are trying to use credit management and they need to understand on what the open authorization amount actually comprises of.
For example, Customer xxx has the following values on the case folder data points (attached);
Receivables Balance : 137,550.94
Open Auth : 143,175.39
However the Custom Account Summary shows 111K
There is no recent activity to suggest timing differences
Case Folder amount: 143,175.39
Open Sales Orders Fufilment lines : 32K.
Customer Credit Limit 240,000 :
for this same reason. users was recommended this SQL;
Open Authorization amount: £112,853.53 (export attached)
select * from FUSION.AR_CUST_CREDIT_AUTHORIZATION where
AUTHORIZATION_STATUS = 'OPEN' and CUST_ACCOUNT_ID = (select Cust_Account_Id from
FUSION.Hz_Cust_Accounts where Account_Number='<account_number>');
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document