Skip to Content
0
Nov 15, 2012 at 08:37 AM

help for an FMS

18 Views

Hello to all

i am interested for a help in an FMS

a customer has created a groupcode in bp master data with code 116

i have created an fms which is used for feeling the Accounts Receivable field automatically.

the FMS created byme is the following

SELECT code FROM dbo.[@MAP_OCRD] WHERE CODE=$[OCRD.GROUPCODE]

i have created the above table with info Code and Name

Code is the same code with groupcode from ocrd table

and Name is the GL Account

the new groupcode will have a new code value but wants to have the same gl account with an othwer code from the above table

for example

100 30.00.00.0000 103 30.01.00.0000 104 30.01.02.0000 101 50.00.00.0000 106 50.01.01.0000 116 30.00.00.0000

i tried to use the same fms but while adding the value 30.00.00.0000 in the above table it is not alloed

do you have any idea how to manage it?

i also tried this

DECLARE @GLACCOUNT NVARCHAR(50)

DECLARE @GROUPCODE1 NVARCHAR(20)

SET @GLACCOUNT='30.00.00.0000'

SET @GROUPCODE1=(SELECT GROUPCODE FROM OCRD WHERE CARDCODE=$[OINV.CARDCODE])

IF (@GROUPCODE1='100')

BEGIN

SELECT code FROM dbo.[@MAP_OCRD] WHERE CODE=$[OCRD.GROUPCODE]

END

ELSE

BEGIN

SELECT @GLACCOUNT

END

but it does not work