how validate default dimension value using x++

(0) Share

Report

Posted on by Sachin Mittal

supoose i have a defualt dimension=/SectionD/ and its display value is /Outdoor/ , how to validate is this value exists in system for section d or not ?

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 238,593 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What do you mean by whether the value exists?

Whether it exists in the backing table, i.e. it can potentially be used as a dimension value? Or whether it exists in DimensionAttributeValue table, i.e. it is or it was used as a dimension value? Or something else?

Was this reply helpful? Yes No
Sachin Mittal 2 on at

Like (0)

Report
Copy link

Link copied!

yes first i have to validate if its display values exists in the system or not , and if its value is usable or not ,

Was this reply helpful? Yes No
Martin Dráb 238,593 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You just the same thing, i.e. that the value should exist, but you didn't explain what you mean by that. Please answer the question in my previous reply.

And how do you define "usable"?

Was this reply helpful? Yes No
Sachin Mittal 2 on at

Like (0)

Report
Copy link

Link copied!
ok i mean, suppose Department
public boolean validateFinDim(str _String) { DimensionAttributeValue dimensionAttributeValue; DimensionAttribute dimensionAttribute; boolean ret = true; container dimCon = str2con('102-345', "-"); // Departments if(conPeek(dimCon, 1) != "") { dimensionAttribute = DimensionAttribute::findByName('Department'); dimensionAttributeValue = DimensionAttributeValue::findByDimensionAttributeAndValueNoError(dimensionAttribute, conPeek(dimCon, 1), false, true); if (!dimensionAttributeValue.RecId) { ret = checkFailed("Financial dimension Department value is not correct."); } return ret; } }
have these display values in system 1,2,3,4,5 , if someone use other than these system should throw error , i have created this method , is this approach fine ?

Was this reply helpful? Yes No
Sachin Mittal 2 on at

Like (0)

Report
Copy link

Link copied!

if i pass values apart from these values for department , it should throw error , department values dont exists

Was this reply helpful? Yes No
Martin Dráb 238,593 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

All right, so you mean "yes" to the question in the very first reply where I asked whether you mean "whether it exists in the backing table, i.e. it can potentially be used as a dimension value". But... what if the department exists but the value is suspended or not valid in for the given date and company? It's not clear whether you didn't mention these things because you're aren't interested in them or because you failed to specify your actual requirements.

Was this reply helpful? Yes No

Join the conversation

Community site session details

how validate default dimension value using x++

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

how validate default dimension value using x++

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates