How to Create a Custom A/R Register:
I'm new to a lot of customization, but thanks to Evan I was able to create a custom A/R Search that I can use in Portlets on any tab. The search below will filter to only show customers with transactions in the past 180 days. This also lets you highlight various fields, etc.
Create a new Transaction Search and customize it as below.
Criteria>Standard>
Filter|Description
Type|is Invoice
Main Line |is true
Amount Remaining|is greater than 0.00
Criteria>Summary>
Summary Type|Field|Description|Formula
Maximum|Formula (Numeric)|is less than or equal to 180|TRUNC({today})-{duedate}
Results>Columns>
Field|Summary Type|Formula|Custom Label
Name|Group
Formula (Currency)|Sum|CASE WHEN TRUNC ({today})-{duedate} < 1 THEN {amountremaining} END|Current
Formula (Currency) |Sum|CASE WHEN TRUNC ({today})-{duedate} BETWEEN 0 AND 30 THEN {amountremaining} END|30
Formula (Currency)|Sum|CASE WHEN TRUNC ({today})-{duedate} BETWEEN 31 AND 60 THEN {amountremaining} END|60
Formula (Currency)|Sum|CASE WHEN TRUNC ({today})-{duedate} BETWEEN 61 AND 90 THEN {amountremaining} END|90
Formula (Currency) |Sum|CASE WHEN TRUNC ({today})-{duedate} > 90 THEN {amountremaining} END|91+
Formula (Currency) |Sum|CASE WHEN TRUNC ({today})-{duedate} > 0 THEN {amountremaining} END|Amount Outstanding
Amount Remaining|Sum||Total Due
Formula (Numeric)|Maximum|TRUNC ({today})-{duedate}|Max Days