jAcct()

Estimated reading time: 1 minute

Function Summary

A helper function that specifies filters for up to six segments of a Chart of Accounts.

Function Arguments

Type Cell/String
Constraints Max 255 char
If Blank

Excel Formula Bar Example

=jCellN(jAcct("Revenue - Sales",7002),11,2001,Actual)

Function Composition

The jAcct function is wrapped in the jCellN function to filter which account it will pull.

An example of this function is currently in construction in our documentation labs. Check back soon for an example with more context. However, for a demo report using this feature, visit the Epicor Demo in the report Library and open the file PL Trend - w/ DataCells.

Argument Name Example Mapping Explanation
Function Name jCellN The name of this function.
Segment1 "Revenue - Sales" The first filter segment. Take only the revenue sales account.
Segment2 7002 Filters to a specific location for a more specific account.