Journal Entries - Duplicates and Sequence Testing

This template takes a look at your journal entries. It helps identify duplicates by ID and amount. It also helps you identify any JE ID's that might be missing in a sequence or out of an expected range of ID's.

Input Requirements

• A journal entry file sourced from your ERP systems (SAP, Oracle, Microsoft Dynamics, etc.).

• Parameters

  1. Journal Entry Sequence Beginning: Beginning number of journal entry ID's you'd expect to see

  2. Journal Entry Sequence End: Ending number of journal entry ID's you'd expect to see

  3. File Input Parameter

Output Expectations

• A population of journal entries that are considered duplicate by ID

• A population of journal entries that are considered duplicate by amount

• A population of journal entries that are considered missing from your sequence

• A population of journal entries that are considered out of your expected ID range