cancel
Showing results for 
Search instead for 
Did you mean: 

FMS query not working

Former Member
0 Kudos

Hello, I recently created an FMS query which pulled all expense gl accounts. I linked the query to a UDF on business partners. This way my users could select a default GL account for a business partner which would appear automatically on the ap invoice. It was working fine, but now the fms query on the BP UDF is failing, returning no results. I also get NO error messages either so I don't know why its failing.

I can run the fms query in Query Manager fine.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please post your FMS query here in order other to help.

Thanks,

Gordon

Former Member
0 Kudos

Select FormatCode, AcctName from OACT where FORMATCODE BETWEEN '500000000' AND '900000000'

ran fine last week, nothing has changed. it just does nothin now.

Former Member
0 Kudos

THe magnifying glass does appear in the udf field indicating the query is linked, but when i click on the manifying glass it disappears and i just have the cursor in the udf field. ???

Former Member
0 Kudos

Hi Robert ,

Press Shift +F2 on your User Defined field and you will see the list of accounts .

Your problem will be solved .There is no issue with query .

Thank you

Bishal

Former Member
0 Kudos

Bishal, yes shift+F2 worked! So why does my fms query not work with the mouse and magnifying glass anymore?

Former Member
0 Kudos

Shift + F2 is the only way to make it work. Or you have to refresh it based on other field. You may use ShiftAltF2 to edit/remove it. Magnifying glass is there to show you have assigned an FMS.

Former Member
0 Kudos

Hmm..ok, i don't know what could have changed, but yes the magnifying glass did work at first for a day or 2. Now I guess we'll have to use shift+F2. now I need to get the fms query to work on the AP invoice. I will create another thread.

Former Member
0 Kudos

Hello, im getting the same error, but my Boss wants the magnify glass working, my boss do not want to use shft+F2 there are any solution for this?

we have SAP 8.8 SP00 PL06

Answers (2)

Answers (2)

Former Member
0 Kudos

Have you checked if you are in the right database?

Former Member
0 Kudos

Have you tried restart your B1? It may just have some kind of temporary problem need to reboot your B1.

Former Member
0 Kudos

I have not rebooted the B1 server, but yes I have closed and logged back into SAP B1 many times.

Former Member
0 Kudos

I even deleted the UDF and recreated it with a different name, assigned the fms query and it still doesn't work. ugh!