Supplier Payment Term Due Date

Hi guys, I’m new at using epicor. I need your guidance and expertise on how to show result due date amount from APInvHed. I would like to show the result in the dashboard like below :

but when I tried the BAQ it shows different result than I expected

image

Below is my BAQ

MW_Supplier_Summsry.baq (74.8 KB)

Much Appriciated