How can I throw an error when user try to change offset account when location on (Journal Name form) and offset account on (General journal > Lines) are same.

(0) Share

Report

Posted on by Ashraf_ahk

I need to validate the location and offset account.

When both are same and user try to change offset account on a form then it should through an error/message.

I have the same question (0)

All responses (5)

Answers (0)

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

All right, so what do you need from us. You don't know how to write any validation at all, you don't know how to get the dimension value, or what?

Was this reply helpful? Yes No
Ashraf_ahk 75 on at

Like (0)

Report

I don't know how to get dimension value.

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

Like (1)

Report

Than this is the question you should have asked. You can't build a wall if you don't have the bricks.

Do you understand the difference between default dimensions and ledger dimensions?

Let's start with default dimensions on journal name. You mean LedgerJournalName.DefaultDimension, right? You can use DimensionAttributeValueSetStorage class to work with it (look for examples either on internet or F&O codebase).

Was this reply helpful? Yes No
Ashraf_ahk 75 on at

Like (0)

Report

No need to use class but by using view(DimensionAttributeLevelValueAllView) I validated it easily.

Was this reply helpful? Yes No
Ashraf_ahk 75 on at

Like (0)

Report

//used validate write method on form

DEFAULTDIMENSIONVIEW ddv;
DimensionAttributeLevelValueAllView dalvav;
LedgerJournalName ledgerJournalName ;

SELECT DISPLAYVALUE
FROM ddv
join ledgerJournalName
WHERE ddv.DefaultDimension == ledgerJournalName .DefaultDimension
&& ddv.NAME == 'my req location name' && ledgerJournalName .JournalName == ledgerJournalTable.JournalName;

select DISPLAYVALUE
from dalvav
where dalvav.VALUECOMBINATIONRECID == ledgerJournalTrans.OFFSETLEDGERDIMENSION
&& dalvav.ValueOrdinal == 2;

if(ddv.DisplayValue != dalvav.DisplayValue)
{

isValid = checkFailed('Set correct offset account location');
}

Was this reply helpful? Yes No

Join the conversation

Community site session details

How can I throw an error when user try to change offset account when location on (Journal Name form) and offset account on (General journal > Lines) are same.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

How can I throw an error when user try to change offset account when location on (Journal Name form) and offset account on (General journal > Lines) are same.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates