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

Setting VendInvoiceInfoTable default values for custom fields - D365 FO

  When creating a vendor invoice and you are trying to populate custom fields on table VendInvoiceInfoTable you may find that the following ...