To Turn on an Exec ID

Step One:
Flag ledger account for exec id

LDG > Maintenance Options > Chart of Accounts

Open

Open

Step Two:
Flag SJI Setup to turn on Exec id by Package

SJI > Setup > Exec id Options
Be sure to flag screen 2 > Group Code for Execution Id Numbers > 3) Category/Item Number
NOTE: this field must be flagged as 3) in order to have the option to turn OFF exec id numbers on stock additions.
Product Category can be flagged NO so that no items in that category have an exec id required.
but only if the Group Code for Execution ID numbers is a 3) Category/Item Number

Open

Open

Step Three:
Setup exec id number

   SJI > Execution ID > Execution ID maintenance
Leave Location Code BLANK unless you want to lock this exec id to only be used at that location code. By leaving blank, any location could use this code.
the VERY LEAST setup is:

• Execution ID #

• Description

• Active Status

• Setup Date
  
  Examples of id’s:

•     Vehicles (blue truck, red truck, green truck) this allows you to track one ledger account called VEHICLE EXPENSE but run reports from exec id that show which truck received the expense.

  Open

  

•     Elevator Repair (E00100, E00125, E00150) this would allow one ledger account for repair expense, but each time ledger code is used, AGRIS will ask for an exec id number, and you can key E00100 to that ledger entry.  Allowing you to run reports from work file for just that exec id number E00100.

  Open

  

•    Construction Projects: (220321for new bins,  211015 for new overfill tank)  as each expense is added and paid for the new assets you are building, you can tag that ledger entry with the exec id that associates with that project.  Then run exec id reports for that project to get a detailed listing of the project.

  Open

  

   

To Use an Exec ID

Start a document in the package that is flagged to allow Exec ID.
If you key a document that would use the flagged ledger account, an exec id screen will appear for selection.

Open

To Run Reports on Exec ID

Step One: Build an exec ID work file.
SJI > Exec ID > Build Exec ID work file

Step Two: Run Standard Exec ID report.
SJI > Exec ID > Exec ID Report
Select work file
Standard Reports > Exec ID report.

Open

Exceptions:

• Product Category can be flagged NO so that no items in that category have the exec if on them.
  But you must also set your exec id option to 3. Product Category/item number.

• Any account that acts as a rollup subsidiary (AR and AP transaction codes) do not track exec id.