How to find the Financial dimensions for the PO Sync lines?

Run the below query changing the PurchID appropriately. Row 1 == Financial Dimension 1, Row 2 == Financial Dimension 2, etc... to FinDim 6.


select
pl.PurchID,
pl.ItemID,
pl.DefaultDimension,
davsi.DimensionAttributeValue,
davsi.DisplayValue
from
PurchLine pl
join DimensionAttributeValueSetItem davsi on
pl.DefaultDimension = davsi.DimensionAttributeValueSet
where pl.PurchID = 'CON-000013'
order by
pl.ItemID,
davsi.DimensionAttributeValue
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk