FMS in BP Master
In Business Master while creating a vendor i have put a formatted search for autogenration of code with prefix5 which is working fine, when i am updating an existing BP vendor the Vendor code is changed according to teh FMS which is not required....This FMS much work only in ADD mode.
Hope u all got my query....
Suda Sampath replied
You need to carefully see what I posted. It is
$[$1.0.0] AND NOT $[$1.1.0]
Please note all Header level fields will always have 0 in the second spot. This number represent the column number and only applies to row level data.
IF $[$40.0.0] = 'S' AND $[$1.0.0] = 'Add' BEGIN SELECT DISTINCT '7' FROM OCRD WHERE CardType = 'S' END
I am not clear with what the SELECT DISTINCT '7' is actually meant for ?