Validation Rule

Par 0

1

2

3

6-8

Description

1

Currency code validation.

To ensure that the currency code is not changed after the first balance update. An To ensure that an invoice account has same currency

2

Field validation

0-256

Start character within field

1-256

Number of characters

D

Digit

d

Digit if Entered

A

Alpha

a

Alpha if Entered

_

Not blank

3

Standard cost / price change validation.

To ensure that the standard cost price is not changed if any balance on a part number.

4

Compare input data with current field value.

def

Warning if not equal

1

Error if not equal

2

Error if not equal, but no message (secure oak password / user)

1

No update

Value

Passed two function G as Parameter 1, 4 and 7 if condition in parametric 5 fails

5

Batch control indicator validation.

If a party is controlled variant, it must be batch or serial number controlled.

If a batch indicator is changed the stock must be zero.

6

Not used

7

Part Variant

8

Part Variant

9

Check document

def

Main document of record

1

Guideline document (participants)

10

Period dates

def

Period table

1

Contract dates

11

Not used

12

Date validation

Def

Date is within period table

1

Date is within tables previous period, last and this year

2

Date is within user restriction for table

3

Date is within user restriction on suppliers invoice date

Def

Warning

1

Fail

13

Calendar validation.

14

Accounts web password maintenance

15

EAN check digit calculation and validation

16

Purchase Invoice Control

Def

Payment stop indicator only change if outstanding

1

Payment stops set to No only by invoice responsible

2

Invoice responsible can only be changed if payment stops set to Yes

17

J table analysis