Accessing and using transaction testing tables

In the Evidential Testing areas and also in a number of other places to allow transactions to be added manually or imported into a testing grid.

These pages are usually respawners - in other words the dialog box stays even though testing pages have been created allowing multiple versions of the testing pages with their own testing tables may be created.

Here is a step-by-step guide - assuming you wish to test transactions in say the Expenditure section (principles are the same for all sections):

1. If you haven't already done so create the lead schedule. In this case the question is at 13.2 on the Control Page:
Screen_Shot_2014-04-16_at_4.46.04_pm.png

2. A "Yes" response generates a button to create the lead schedule for Expenditure:
Screen_Shot_2014-04-16_at_4.48.34_pm.png
3. Click the button to create:
Screen_Shot_2014-04-16_at_4.50.10_pm.png 

4. Follow the link to H1 to open the page. Point 1.7 on H1 asks whether there are payments transaction that require testing. Click "Yes":

Screen_Shot_2014-04-16_at_4.52.34_pm.png

5. Click on "Detailed Substantive Testing - Purchases" to create page:

Screen_Shot_2014-04-16_at_4.53.15_pm.png

6. At this point you may if you wish give the page a unique name - as you may want to create more that one version of this page say for different types of expenditure:

Screen_Shot_2014-04-16_at_4.54.52_pm.png

7. Select "Add" to save then follow the link that is created to page H2, or if you wish click "Detailed Substantive Testing - Purchases" again to create another version of the page:
Screen_Shot_2014-04-16_at_4.56.59_pm.png

8. On page H2 under point 1.1 use the drop-down selector to choose what tests you want to apply to the data. You may choose one of the standard tests or click "Other Test" to make your own custom tests (try to keep descriptions brief so that they fit in the table):

Screen_Shot_2014-04-16_at_4.58.39_pm.png

9. Once tests are selected and rationale for sample size is documented click "Create Table":Screen_Shot_2014-04-16_at_5.03.26_pm.png
10. The name of the table may be changed at this point if a more specific title is wanted. Data columns are pre-selected but these may be changed, removed or dragged and dropped into a different sequence as required. There is a limit to the total width available and when this is reached no more columns will be able to be selected. When you have chosen click "Add":

(For extra width "landscape" may be selected from drop down - in this case if want to test specific stock items we could add some extra columns so we switch to landscape and select additional columns) 

11. Now follow the link H2-2.2 to the table itself:

Screen_Shot_2014-04-16_at_5.11.51_pm.png

12. The table has the tests included (you can't see them yet), the column you specified but no data - this may be loaded manually "Add Row" or from an Excel/CSV import using "Import Rows":

Screen_Shot_2014-04-16_at_5.12.33_pm.png

13. Here two rows have been added manually. Note that the $ column is totalled allowing you to see the total value of your sample:

Screen_Shot_2014-04-16_at_5.17.02_pm.png

14. To view your tests, click the arrow next the "pending tests". Click Pass, Fail or n/a:

Screen_Shot_2014-04-16_at_5.19.56_pm.png

15. You may also add comments in the box, or click the down arrow to the right to add further comments or attachments (a scanned copy of the supporting document for instance). The results of the tests are shown - in this case "0 deviations":

Screen_Shot_2014-04-16_at_5.22.54_pm.png

16. If there is a deviation the test where the deviation occurred will be noted in the comment:

Screen_Shot_2014-04-16_at_5.26.25_pm.png

17. The number of deviations on the testing page is noted back on the parent page (H2 in this case) to alert the user to any exceptions found:

Screen_Shot_2014-04-16_at_5.27.35_pm.png

18. There is no conclusion on testing pages - they are like an attachment to the parent page and are indexed as such:

Screen_Shot_2014-04-16_at_5.30.13_pm.png

19. To add data from an Excel or CSV file the columns must match - but no headings are required. For example:

Screen_Shot_2014-04-16_at_5.44.59_pm.png

20. To import select "Import Rows":

Screen_Shot_2014-04-16_at_5.46.33_pm.png

21. Browse to where Excel/CSV file is saved:

Screen_Shot_2014-04-16_at_5.48.41_pm.png

 22. Save - data will populate table.

Screen_Shot_2014-04-17_at_8.55.32_am.png

23. Edit lines by clicking on edit (pencil) icon at left - may also delete from this option:

Screen_Shot_2014-04-17_at_9.04.07_am.png

24. Lines may be reordered by dragging and dropping on the edit icon (without opening the edit dialog).

Have more questions? Submit a request

Comments

Powered by Zendesk