Task Technology FAQs

The AIFRS Template does not contain 'Expense by Nature' or 'Expense by Function' leadsheets for each expense category.

To create these leadsheets, open 'Document Manager' and complete the following steps:

1. Select the location where the leadsheets will be inserted
2. Display the 'New Automatic Document' dialog by either:
1. Selecting Document | New from the 'CaseWare' menu
1. The 'New Document' dialog is displayed
2. Select Automatic Document and click the OK button; or by
   
2. Clicking the New Automatic Document button in the 'CaseWare' toolbar (refer: Figure 1)
3. Modify the properties of the'Automatic Document' to reflect a 'Leadsheet Document' (refer: Figure 2)
4. Customise the leadsheet as an 'Expense by Nature' or 'Expense by Function' leadsheet for each expense category
1. For an 'Expense by Function' leadsheet, enter the following data: Number: (unique for each expense category)
   
   
   Name: (unique for each expense category)
   dBase Filter:

   Administrative:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "500"
   Distribution:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "515"
   Finance:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "530"
   Marketing:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "505"
   Occupancy:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "540"
   Other Expenses:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "900"
   Restructuring:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "590"
   Other Category UD1:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "800"
   Other Category UD2:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "810"
   Other Category UD3:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "820"
   Other Category UD4:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "830"
   Other Category UD5:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "840"
   Other Category UD6:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "850"
   Other Category UD7:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "860"
   Other Category UD8:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "870"
   Other Category UD9:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "880"
   Other Category UD10:	LTRIM(AM->AC_NO2)="2.5*"&MID(LTRIM(AM->AC_NO2),7,3) = "890"

   
   
2. For an 'Expense by Nature' leadsheet, enter the following data:
   Number: (unique for each expense category)
   Name: (unique for each expense category)
   dBase Filter:
   

   Depreciation,Amortisation and Impairments:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "520"
   Employee:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "510"
   Finance:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "530"
   Other Operating:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "600"
   Restructuring:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "590"
   Other Category UD1:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "800"
   Other Category UD2:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "810"
   Other Category UD3:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "820"
   Other Category UD4:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "830"
   Other Category UD5:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "840"
   Other Category UD6:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "850"
   Other Category UD7:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "860"
   Other Category UD8:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "870"
   Other Category UD9:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "880"
   Other Category UD10:	LTRIM(AM->AC_NO2)="2.6*"&MID(LTRIM(AM->AC_NO2),7,3) = "890"

   
   
5. Click the OK button
   

 Figure 1:                                                 Figure 2:







© Copyright Task Technology 2006