• SQL Error in SQL exprsssion using a SUBSTRING

  • GL Account Description

    The GL account description is not pulling into my newly created balance sheet report. When I put in the formula =GLAccountDescription300("SAMINC", $B10) into my cell, when I run the report the account description is not pulling in, I just see the formula…
  • I need to add a field to the AP Tran container. Do I need a connector license

    For a custom report I am making, I need to add the posting date which is not present in the AP tran container. The fiscal period and year is present, but not the post date. I happen to want that. Do I need to make a new container to do this and if so…
  • Excel View in SEI

    Hello - Is it possible to create a view in SEI using an existing excel spreadsheet rather than using the SAGE database tables? If so, how is this done? Thanks
  • SQL Expression to query Optional Field value from APIBDO Table

    Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…