Hello Everyone,
I'm trying to build a report in FNMS based on Purchase Orders, but I ran into a problem. I cannot find column for Entitlement Status (one where it's Enabled, Disabled or Always enabled).
I am not sure, whether it's not available at all or I am missing something. Anyone knows how to add it?
From what I was able to find, this value is available in EntitlementTransaction table of FNMSCompliance, but I'd like to avoid building SQL report in this case, if it's possible.
Also I think new column can be added to reporting module using ComplianceCustomViewColumnRegister procedure, but that would be last option.
‎May 30, 2019 06:27 AM
‎May 30, 2019 09:07 AM
Hi Jan,
I'm not sure what you are trying to achieve here, can you explain the use case?
Purchase Orders have the following status values: Cancelled, completed, New, Pending.
Kind regards
Thorsten
‎May 30, 2019 06:56 AM - edited ‎May 30, 2019 06:58 AM
Hi Thorsten,
I am referring to a column from Licenses tab of a purchase (or Purchases tab of License).
If PO is linked to a License, column called Entitlement Status is available there. It has 3 options I mentioned above and basically it can be used to stop POs from contributing to license entitlements.
Kind regards,
Jan
‎May 30, 2019 07:25 AM
‎May 30, 2019 09:07 AM
‎May 30, 2019 09:46 AM