Query an End Balance with Add-ins

Does anyone know a means by which you could query an account's End Balance using the Lawson Excel Add-ins?

I've tried using the application 90.1 route of getting the information but the query seems to just stall. I realize it is a calculated field and may not be possible but would love to find a way to get it in a query.

Thanks for any help!

Find more posts tagged with

Comments

Legacy Contributor

You can recreate the calculation yourself in Excel. The key is, how is the "Derived Field" constructed? Like everything else in Lawson, you can find out, you just have to know what to look for. In this case, use the command-line utility known as the "Derived Field Report".

> derfldrpt

Usage: Derived Field Report
Syntax: derfldrpt ProductLine [FileName]

Example:

> derfldrpt prod apaudit

Product Line - PROD

File - APAUDIT

Conditional Field - FIELD-DESC

If (APDICT-EXIST)
APDICT->FLD-NAME-DESC Data Base
Else
Spaces Value

>

Legacy Contributor

So what I'm trying to explain is, Use the Add-Ins to pull the non-derived-field data. Then set up a column of cells in Excel where the formula, whatever it is, is performed.

0911060553270289.pdf

raymond-irizarry

Use the GLAMOUNTS table. Field CYPYTDxx (xx = period). This will work assuming your period is closed.

timothy-guest

Thank you both very much! This will greatly reduce time I spend creating some reports!

Legacy Contributor

Just a note: In the GLAMOUNTS table, the CYPYTDxx fields are Derived Fields. They are "chained" up in a somewhat complicated fashion. The derfldrpt report shows the complexity. As I don't have Add-Ins at my current employer, I can't try testing anything, however you could try directly pulling the derived fields in as PSlikas explained above. It may just work, like Lawson technology often does.

(The reason I have had to learn the Derived Fields and how to manually compute them has to do with LBI reporting, where I used Crystal Reports to draw directly from Oracle databases. The derived fields don't exist in the underlying DB tables.)

Legacy Contributor

Here's the derived report for computed fields on GLAMOUNTS

Copyright © 2025 Infor. All rights reserved.