Creating Creditor ageing report using Pivot Table sample 4 pg 83

Sample 4

This sample report shows the date of each invoice for each supplier in each group:

	A			B			C			D			E
1
2
3	Sum of RM-CREDIT
4	CREDIT AGE GROUP	ACCOUNT-CREDIT		OTHER REF/NO	DATE		Total
5	0–30				OTHER CREDITOR A	STACC/11/2000	04-Apr-01	(1,650.00)
6						OTHER CREDITOR B	AC23116			14-Apr-01	(870.00)
7						OTHER CREDITOR C	AC23072			06-Apr-01	(2,750.00)
8						OTHER CREDITOR D	1924788			11-Apr-01	(10,800.00)
9						OTHER CREDITOR E	17697			11-Apr-01	(402.75)
10						OTHER CREDITOR F	17696			11-Apr-01	(2.301.86)
11						OTHER CREDITOR G	17680			11-Apr-01	(4,712.15)
12						OVERSEA CREDITOR A	N5498			20-Apr-01	(92.919.25)
13						OVERSEA CREDITOR B	1211-001		11-Apr-01	(38,025.00)
14						OVERSEA CREDITOR C	22571003		21-Apr-01	(164,376.00)
15						OVERSEA CREDITOR D	22571004		22-Apr-01	(164,376.00)
16											22571072		26-Apr-01	(121,455.60)
17						OVERSEA CREDITOR E	22571070		25-Apr-01	(54,792.00)
18											22571074		26-Apr-01	(54,792.00)
19						OVERSEA CREDITOR F	22571072		26-Apr-01	(219,168.00)
20											22571091		28-Apr-01	(164,376.00)
21	0-30 Total															(1,097,766.61)
22 	30-60				OVERSEA CREDITOR A	N5133			08-Mar-01	(53,174.19)
23						OVERSEA CREDITOR B	N5134			08-Mar-01	(212,696.78)
24						OVERSEA CREDITOR C	22570505		24-Mar-01	(324,186.00)
25						OVERSEA CREDITOR D	22570585		24-Mar-01	(71.229.60)
26						OVERSEA CREDITOR E	TQAOY602T		24-Mar-01	(208,572.82)
27						OVERSEA CREDITOR F	TQABY808T		13-Mar-01	(231,747.59)
28						OVERSEA CREDITOR G	98309869		29-Mar-01	(48,323.50)
29						TRADE CREDITOR A	0003			21-Mar-01	(43,446.00)
30						TRADE CREDITOR B	AC22876			07-Mar-01	(2,750.00)
31						TRADE CREDITOR C	0105			21-Mar-01	(43,748.00)
32						TRADE CREDITOR D	17508			16-Mar-01	(1,849.19)
33						TRADE CREDITOR E	17324			10-Mar-01	(1,312.32)
34 	30-60 Total															(1,243,035.59)					
35 	60-90				OTHER CREDITOR A	STACC/9/2001	03-Feb-01	(1,224.00)
36						OTHER CREDITOR B	0003			23-Feb-01	(45,720.00)
37						OTHER CREDITOR C	AC22694			02-Feb-01	(870.00)
38						OTHER CREDITOR D	AC22689			07-Feb-01	(6,875.00)
39

Steps to produce the above report are as follows:

1. Follow steps 1 to 13 from Sample 1.

2. Drag the button CREDIT-AGE GROUP (partly hidden) into the ROW box. Drag the button ACCOUNT-CREDIT into the ROW box but below the CREDIT-AGE GROUP button, and drop it there. Drag the button OTHER REF/NO the into the ROW box but below the ACCOUNT CREDIT button, and drop it there. Drag the button DATE into the ROW box but below the OTHER REF/NO. button, and drop it there. Drag the button RM-CREDIT into the DATA box.

3. Follow steps 15 to 17 from Sample 1.

You should get the above report.

93