Trial Balance - Function and As of Date

Kinetic ERP
1

Hi I was given a few requests regarding the Trial Balance

  1. A trial balance with a cut off date - not the period ending date.

I found an ‘As of’ date on the Kinetic form but it is always read only and may not be what I need. The Application help states that it is an As of Date which isn’t helpful and does not mention it again.

This is for internal auditing purposes so stating no it does not work like that is not the path forward :wink:

I figured if we ran the trial balance every day that could help us going forward.

Has anyone made a Kinetic Function that can call the report?

I do have a BAQ that is trying to pull a Trial Balance and we are proofing that but I would like to use Epicor objects if possible to pull the Epicor report itself.

2

Hi Tim,

It sounds to me like the “As of” date is what you’re looking for. The way to open that field up from being read-only is to change the “Retrieve By” dropdown from “Fiscal Period” to “As of Date”.

I don’t think you need a function to pull the report every day, you can set the report up to run as “Recurring” and on a schedule you define. One thing worth noting with that is you’ll want to check the “Dynamic” checkbox next to the “As of date” field and set it to “Today” so it doesn’t just repeatedly run for one specific date.

Pretty sure it can be done with a function if needed, but that wouldn’t be the first approach I’d try.

1 Like
3

Thank you very much! If I set it as ongoing where does it go?
Also I found Epicor reports not very dynamic - will it always pull the current period?

My intend with the function was so I could have it write to a file share.

Ideally the report would go somewhere where the Finance Team could get it.

4

Here’s how I’d do it based on my understanding of your requirements. We’re on SaaS here, so writing out to a file location isn’t something I’ve done, but these instructions will get it sent as an email. Maybe set up a finance email distribution list ahead of doing this?

  1. Navigate to “System Agent” and create the desired schedule for this automatic report
  2. Navigate to “Trial Balance”
  3. Change “Retrieve By” to “As of Date”
  4. Check the “Dynamic” box next to the “As of Date” dropdown and confirm that “As of Date” has “Today” in it
  5. Open the “Advanced” card, select your schedule from the dropdown, and check the “Recurring” checkbox
  6. In the overflow menu, choose “Send By Email”
  7. Populate the email details and then click “Send”

I followed these steps in my PILOT environment with a schedule of every 5 minutes, and I’m receiving an email with the PDF trial balance every 5 minutes.