Restricting 'Entry Type' selection on item journal

Smashed_Pumpkin

On the item journal you have the 'Entry Type' option of 'Purchase', 'Sale', 'Positive adjustment' and 'Negative adjustment'. As we only want our users to use the 'positive/negative adjustment' options, could the system be set up to give an error message if the user selects one of the other options?

Many thanks.

giulio.cipo

you could modify the option string of the control so that you have only two option.
This already appen becase the option of entry type are more then 4 you can have Transfer,Consumption,Output also.

FabriceG

If you use a sql server , you can resolve this problem with the security filter.
If not write code in the trigger validate of the field

Smashed_Pumpkin

I don't want to remove the options, so code is the way to go. Could you tell me what code I need to add? I'm still very new to this.

Thanks.

FabriceG

To way
In a form, create a new form (copy of the standard form). In the trigger "On validate" insert this code

IF ("Entry Type"<>"Entry Type"::"Positive Adjmt.") AND ("Entry Type"<>"Entry Type"::"Negative Adjmt.")
THEN error(.......);

Smashed_Pumpkin

Cheers, I'll give it a go

Dean_Axon

Seeing as though your new to coding and what your trying to do is in the Inventory Journal, I wouldn't recommend making a new form. Stick with the original form and add something like this to the "on Validate" trigger of the "Entry Type" field of the table

1) Using a case statement:
Case "Entry Type" of
"Entry Type"::Purchase,"Entry Type"::Sale:
begin
Error('Your error message goes here');
end;
end;
2)using if statement:
If ("Entry Type"="Entry Type"::Purchase) or
("Entry Type"="Entry Type"::sale) then begin
Error('Your error message goes here');
end;

'Positive adjustment's and 'Negative adjustment's will continue to work as normal as you have not told the system to do anything different with them.

Remember : Keep it simple

Smashed_Pumpkin

Cheers for the advice. In the end I modified the original form (after taking a backup!) by inserting code into the OnValidate trigger, so now if users select anything other than positive/negative adjustment the system tells them "That option is not available".