Creating Creditor ageing report using Pivot Table sample 2 pg 81

Sample 2

This report shows the suppliers' names for each credit-age group.

	A					B								C
1
2	
3	Sum of RM–CREDIT
4	CREDIT AGE GROUP	ACCOUNT–CREDIT					Total
5	0-30				OTHER CREDITOR A				(1,650.00)
6						OTHER CREDITOR B				(870.00)
7						OTHER CREDITOR C				(2,750.00)
8						OTHER CREDITOR D				(10,000.00)
9						OTHER CREDITOR E				(402.75)
10						OTHER CREDITOR F				(2,301.86)
11						OTHER CREDITOR G				(4,712.15)										12						OVERSEA CREDITOR A				(92,913.25)
13						OVERSEA CREDITOR B				(38,025.00)
14						OVERSEA CREDITOR C				(164,375.00)
15						OVERSEA CREDITOR D				(285,831.60)
16						OVERSEA CREDITOR E				(109,504.00)
17						OVERSEA CREDITOR F				(383,544.00)
18	0-30 Total											(1,097,706.61)									
19	30-60				OVERSEA CREDITOR A				(53,174.19)
20						OVERSEA CREDITOR B				(212,096.70
21						OVERSEA CREDITOR C				(324,106.00)
22						QYERSEA CREDITOR D				(71,225.80)
23						OVERSEA CREDITOR E				(200,572.82)
24						OVERSEA CREDITOR F				(231,747.58)
25						OVERSEA CREDITOR G				(48,323.50)
26						TRADE CREDITOR A				(43,440.00)
27						TRADE CREDITOR B				(2,750.00)
28						TRADE CREDITOR C				(43,748.00)
29						TRADE CREDITOR D				(1,543.10)
30						TRADE CREDITOR E				(1,312.32)
31	30-60 Total											(1,243,005.00)
32	60-90				OTHER CREDITOR A				(1,224.00)
33						OTHER CREDITOR B				(45,720.00)
34						OTHER CREDITOR C				(670.00)
35						OTHER CREDITOR D				(16,875.00)
36						OTHER CREDITOR E				(611.22)
37						OTHER CREDITOR F				(2,634.35)
38	

We can build the above report by performing these steps:

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 RM-CREDIT into the DATA box.

3. Follow steps 15 to 17 from Sample 1.

You should get the above report.

91