Search Engine: Elastic

Article ID: 128030, created on Jan 12, 2016, last review on Jan 12, 2016

  • Applies to:
  • Business Automation


An account received Overdue Balance notification but this account does not have any overdue invoices.


Overdue Balance notifications are sent by the method FindNotifiableAccounts which is called daily in scope of daily billing process. It does not check the due dates of the documents (such check is performed when account is put on hold), it only checks the current account balance. If the accounts balance is negative, notification is sent out. Basically check is done with query below:

SELECT "A"."AccountID" FROM "Account" "A" CROSS JOIN "AccountBalance" "AB" WHERE (((("A"."NextCBNotifDate" < $1) AND ("A"."VendorAccountID" = $2)) AND ("AB"."AccountID" = "A"."AccountID")) AND ("AB"."Balance_Value" > $3)) AND ((("A"."AStatus" <> $4) AND ("A"."AStatus" <> $5)) AND ("A"."AStatus" <> $6)) ORDER BY "A"."AccountID" DESC

$1 - todays date
$2 - vendor id
$3 - zero
$4 - 12 (full hold account status)
$5 - 10 (credit hold)
$6 - 2 (cancelled)

NextCBNotifDate is changed after the notification is sent out, date set depends of the setting Overdue Notification Interval (Days).

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF