Monday, 20 November 2023

Get Financial Dimension values for Financial Dimension X++ in SQL

select DimensionFinancialTag.Value, DimensionFinancialTag.Description from DimensionFinancialTag
join DimensionAttributeDirCategory on DimensionAttributeDirCategory.DirCategory = DimensionFinancialTag.FinancialTagCategory
join DimensionAttribute on  DimensionAttribute.RecId = DimensionAttributeDirCategory.DimensionAttribute
and DimensionAttribute.Name = 'InBound'

No comments:

Post a Comment

validate offsetLedgerDimension in d365 FO

 /// <summary> /// This class is used to validate offsetLedgerDimension /// </summary> class PNG_InventMovValidateOffsetLedgerDi...