I want to use a value variable that works in Report Writer (table GLPCT, field MSL [quantity] but cannot select MSL as a variable field in Report Painter to insert the same variable (it is not a selectable characteristic) using the same Library and Table.
Is there a way to make the field selectable in Report Painter in order to select a value variable that uses the field MSL ? It is a valid field in the Library that I am building the report in.
In building the columns, I can select characteristic fields such as:
Ledger
Record Type
Version
Fiscal Year
Profit Center
Functional Area
Account number
Period
etc
but not MSL Quantity. Is there configuration to make this (or any field) accessible to Report Painter ?
Any advice is welcome.....
Thanks......