FMS in BP Master

[Former Member]

Dear All,

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

Thanks

Aravind.

[former_member583013 · Accepted solution]

Aravind,

First and foremost, to get the Next Vendor Code, you need to not have it Auto Refresh. This is probably what is causing the problem.

If you want it to work only on Add mode, then you could use

IF $[$1.0.0] = 'Add'

[Former Member · Accepted solution]

Hi Sudha

Thanx for ur input. But i have already tried this, and when i change the BP type from Vendor to Customer the Code Generated for Vendor disappears...

Regards,

Aravind

[former_member583013 · Accepted solution]

I am not clear with what you are saying...Unless you paste your query....I will not know what you have

[Former Member · Accepted solution]

Hi Sudha,

This is the query:

IF $[$40.1.0] = 'S' and $[$1.1.0]='Add'

Begin

SELECT Distinct '7' from OCRD T0 where T0.cardtype=$[$40.1.0] and $[OCRD.Cardtype]='S'

END

[former_member583013 · Accepted solution]

Aravind,

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 ?

[Former Member · Accepted solution]

That was just an example for the Prefix...

Thanx for ur Input.

[former_member187989]

Select option Dispaly saved values When Auto refresh When the field changes & Update FMS.

Jeyakanthan

[somchitra_oun-anuiom]

May be you should generate your vendor code, only if it does not xist in the BP Table.