Account selection FMS for BP's

[Former Member]

Hi All,

The need is to capture stock transfer account when a particular customer is used. The problem is that we have over 44 such customers and there code starts like 1000001 to 1000100.

The need is that every time any of this customer is used, the stock transfer outward account should be used. I checked the thread and got this query;

SELECT '410030' FROM OCRD T0

INNER JOIN OCRG T1 ON T1.GroupCode = T0.GroupCode

WHERE $[$4.0.0] = T0.CardCode AND T0.GroupCode = '135'

But i need to hard code my customers in this query. Can this be achieved.??

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Joseph,

Try this:

IF $[$4.0.0\] Between 1000001 And 1000100

SELECT '410030'

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

I have tried this. It doesn't show any errors but shows no value either.

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Gordon,

I tried the following query and its working.

SELECT '410030' FROM OCRD T0

INNER JOIN OCRG T1 ON T1.GroupCode = T0.GroupCode

WHERE $[$4.0.0] Between 100001 And 100100

I have set it to auto refresh on a udf. Working fine for me.

Thanks,

Joseph

[Former Member · Accepted solution]

That is great. As long as you have right UDF and refresh assigned correctly. This query is ok.

[Former Member]

Hi Joseph........

Create an UDF at Business Partner level say AccountCode.

Now store the stock account for your respective customers and when do the transaction for stock transfer just make a FMS and capture the account code from BP master directly.

I guess it will solve your problem....

Regards,

Rahul

[Former Member]

Hi Rahul,

Tried as suggested by you. Its not workin. Can't we just hard code this? If you can please help with an example of two or 3 customer codes?

Thanks,

Joseph

[Former Member]

Hi,

Can you explain the issue some more clearly, then it will be usefull for me to give suggestions. Can give an example how the transaction is happening and what is the expectation from that transaction.

[Former Member]

Hi,

We have over 44 branches and we do stock transfer across all the branches. We have defined the branches as customers in our HO database. Now we have defined the such business partners starting from the code 100001 to 100100.

The requirement is to get the gl -- "stock transfer" in case any of the above mentioned customer code is used. The query which i have found uses any customer code but we need the account to change only if code ranges from 100001 to 100100. Hope the scenario is clear now.

Thanks,

Joseph