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.

All responses (5)

Answers (0)

Ashraf_ahk 75 on at

Like (0)

Report

RE: 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.

//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');
}
Ashraf_ahk 75 on at

Like (0)

Report

RE: 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.

No need to use class but by using view(DimensionAttributeLevelValueAllView) I validated it easily.
Martin Dráb 231,758 Most Valuable Professional on at

Like (1)

Report

RE: 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.

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).
Ashraf_ahk 75 on at

Like (0)

Report

RE: 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.

I don't know how to get dimension value.
Martin Dráb 231,758 Most Valuable Professional on at

Like (0)

Report

RE: 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.

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?