Sage Evolution
Space shortcuts
Page tree

Versions Compared

Old Version 4

changes.mady.by.user Michael van Zundert

Saved on

compared with

New Version Current

changes.mady.by.user Michael van Zundert

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
title_as_AROverdueClients
CREATE VIEW _as_AROverdueClients
	AS
	SELECT C.DCLink, SUM(t.Outstanding) as OverdueAmount, IsOverdue = CASE WHEN SUM(t.Outstanding) > 1 THEN 1 ELSE 0 END FROM _as_AROverdueTransactions t
		LEFT JOIN Client C ON t.AccountLink = C.DCLink
		GROUP BY C.DCLink


Dependency:

With dependency on:

Include Page
SQL - _etblTerms - Unpivot _as_ARAP_Terms_Unpivot
SQL - _etblTerms - Unpivot _as_ARAP_Terms_Unpivot