Forum Discussion

svelamuri's avatar
svelamuri
Regular Visitor
2 years ago

Update AR Aging with Amounts Received

I have an Accounts Receivable aging report that I want to update as we receive funds. The amounts received are not consistent with the exact dollar amount of the dues, so I have to subtract the amoun...
Need Help
Tips and Tricks
johnbasha33's avatar
johnbasha33
Super User
2 years ago

Hi svelamuri 

try below measure

Current Due =
VAR RemainingDues =
ADDCOLUMNS (
FILTER (
AgingReport,
[Amount Due] > [Amount Received]
),
"RemainingDues", [Amount Due] - [Amount Received]
)
RETURN
SUMX ( RemainingDues, [RemainingDues] )

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

svelamuri's avatar
svelamuri
Regular Visitor
2 years ago

Hi johnbasha33 

Thank you for your response.

However, this doesn't work in my case because Amount Due and Amount received are not in the same table or the same format. Please refer to the screenshots - let me know if you need more information. 

 

Also, I need to be subtracting the amount received from amount due in the descending order of the aging category - so subtract from 60 days first (if anything in 60 days exists), then any remaining amount received from 30 days and lastly from current due. 

 

Thank you!