Creating Creditor ageing report using Pivot Table sample 3 pg 82

Sample 3

This sample report shows every invoice for each supplier in each group.

	A					B						C					D
1
2
3	SUM of RM–CREDIT
4	CREDIT AGE GROUP	ACCOUNT–CREDIT			OTHER REF			Total
5	0-30				OTHER CREDITOR A		STACC/11/2000		(1,600.00)
6						OTHER CREDITOR B		AC23118				(1,870.00)
7						OTHER CREDITOR C		AC23972				(12,750.00)
8						OTHER CREDITOR D		1924790				(10,800.00)
9						OTHER CREDITOR E		17697				(402.75)
10						OTHER CREDITOR F		17096				(2,301)
11						OTHER CREDITOR G		17680				(4,712.15)
12						OVERSEA CREDITOR A 		M5400				(92,919.26)
13						OVERSEA CREDITOR B		1211-001			(30,000.00)
14						OVERSEA CREDITOR C		22571003			(164,776.00)
15						OVERSEA CREDITOR D		22571004			(104,378.00)
16												22671072			(121,455.60)
17						OVERSEA CREDITOR E		22571070			(54,732.00)
18												22571074			(54,792.00)
19						OVERSEA CREDITOR F		22571072			(219,168.00)
20												22571091			(154,376.00)
21	0-30 Total														[1,097,766.61)
22 	30-60				OVERSEA CREDITOR A		N5133				(53,174.19)
23						OVERSEA CREDITOR B		NS134				(212,636.78)
24						OVERSEA CREDITOR C		22570605			(324,180.00)
25						OVERSEA CREDITOR D		22670085			(71,229.60)
26						OVERSEA CREDITOR E		22570685			(200,572.02)
27						OVERSEA CREDITOR F		TQA0V602T			(231,747.50)
28						OVERSEA CREDITOR G		TQA0V608T			(48,223.50)
29						TRADE CREDITOR A		0003				(43,446.00)
30 						TRADE CREDITOR B		AC22976				(2,750.00)
31						TRADE CREDITOR C		0105				(43,740.00)
32						TRADE CREDITOR D		17500				(1,045.19)
33 						TRADE CREDITOR E		17324				(1,312.32)
34 	30-60 Total														(1,243,035.39)
35	60-90				OTHER CREDITOR A		STACC/3/2001		(1,224.00)							36						OTHER CREDITOR B		0003				(45,720.00)
37						OTHER CREDITOR C		AC22694				(1,970.00)
38						OTHER CREDITOR D		AC22689				(6,875.00)
39 						OTHER CREDITOR E		17396				(611.22)
40

The steps to produce the 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 ROW box but below the CREDIT-AGE GROUP button, and drop it there. Drag the button OTHER REF/NO into the ROW box but below the ACCOUNT CREDIT 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.

92