Thanks, Yosiasz for getting back. Please find my sample table below:
declare @sample table(CustID int, invoiceID varchar(20), invoicedate datetime, invoiceamount float)
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (46380, '9001429535', '2018-06-30',70.00);
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (46380, '9001709570', '2018-09-30',185.00);
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (46380, '1003998056', '2020-12-31',50.00);
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (106429, '0002436660', '2019-07-31',80.00)
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (106429, '0002729420', '2020-01-31',90.50)
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (106429, 0002988848, '2020-12-31',100.00)
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (119558, 9001599620, '2018-08-31',57.00)
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (119558, '9001866447', '2020-12-30',140.00)
INSERT INTO @sample (CustID, invoiceID, invoicedate, invoiceamount)
VALUES (119558, '0002134324', '2019-02-28',127.00)
Select CustID, invoiceID, invoicedate, invoiceamount, cast('' as datetime) AS DueDate, cast('' as int) AS DaysOutstanding
from @sample
Thanks in advance
Bekky