Day 18 (10 Nov 2022)

I started my day by continuing the general ledger test. I performed the following steps:

1. Copy cleaned trial balance to ‘Advantage trial balance template’ under the source file

2. Go to the tab ‘TB review’ and click ‘TB quality review’

3. Under the IDEA, go to ‘select’, choose ‘external project’, choose the unzipped file

4. Input the general ledger, then open the ‘Generate GL’ script

5. ‘GL_H’ and ‘GL_D’ fields will then be generated, major test is run on ‘GL_H’ while the COA test is on ‘GL_D’

6. Run the ‘import TB’ macro, then go for ‘generate TB macro’

7. Under the ‘generate TB macro script’, close either the ‘opening amount’ or ‘prior amount’

8. Create ‘generate completeness check’

9. Go to ‘generate COA template’ under Macro file, click ‘000z Generate blank COA-Non advantage template then click ‘000z Generate Compcode list’

There are all steps I can do, there are further steps need to do but this needs to wait for the engagement team colleague to fill up the COA template first. All nine steps take a very long as the files are large so the processing time required is extremely long and you are unable to continue another task as the laptop will be lagging if we do any other thing when the IDEA is processing a large file. So I end the day by performing all nine steps.

---

Main things that have learned

• Continue the general ledger test for Envictus group

---

Comment/idea/opinion

Today I realized that the IDEA might need an extremely long time to process if the files are of extreme size.