Printing dimension value of customer or vendor.


static void ShowcustDefaultDimensions(Args _args)
{
CustTable custTable;
DimensionAttributeValueSet dimAttrValueSet;
DimensionAttributeValueSetItem dimAttrValueSetItem;
DimensionAttributeValue dimAttrValue;
;

custtable = Custtable::find(‘Customer Id’);

while select dimAttrValue
exists join dimAttrValueSetItem
exists join dimAttrValueSet
where dimAttrValueSet.RecId == custTable.DefaultDimension &&
dimAttrValueSetItem.DimensionAttributeValueSet == dimAttrValueSet.RecId &&
dimAttrValue.RecId == dimAttrValueSetItem.DimensionAttributeValue
{
print dimAttrValue.getValue();
}
pause;
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s