Report Writer - pulling in units instead of dollars

Hi all,

I recently joined a company that uses Lawson, so I only have a couple months experience. I am having issues pulling some of our statistical unit entries into my report through Report Writer. I have loaded the unit data in a specific account and when I enter the account into the Report Writer row, it does not pull anything in. My guess is that it's looking for dollars and doesn't see any so it skips over this account. There is no clear option for selecting dollars vs. units. Have any of you successfully added units to your custom reports?

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Comments

amacknig

in your format, did you use Data Dictionary Names for Units?

unknown

I'm not familiar with "Data Dictionary Names" - I found my issue - In the columns I have selected CPAMT as the criteria, but Units are under CPUNT so I either have to select the dollar amounts or units to display, so my issue is I need amounts and units in the same column because I'll have financials at the top and statistical units at the bottom, in the same column for a specific period.

amacknig

Data Dictionary Names can be found in the format, in the drill-down area of the Data Name field. you can select from the list, filter by type (amounts/units/budgets, etc) . i am assuming you are using a style 2 report. if you are, then you add a second format, and have that format point to units, and attach that format to a line in your row. that way the units will print in the same column as the amounts.

unknown

I created an incident and this is the guidance I just received from them as well. THANKS!

Copyright © 2025 Infor. All rights reserved.