Formatted Search Problem

362 Views

Hi All,

SAP Business One 2007 A SP01 PL05

I am having a small problem with a formatted search that is not displaying the correct values on only some items.

I have created a UDF with valid values of F, R, and O and it is called Division. All my item codes are 7 digits long for example B123ABC. I have also created profit centers as follows B123ABCF and B123ABCR.

My formatted search is on the profit center field and it is set to auto refresh when exiting altered column Division and display saved user defined values. The query is

SELECT $[$38.1] + $[$38.U_Division]

and that should select the itemcode and the division value and insert it into the profit center field which will select the correct profit center.

This works but there are a few items where it does not work for argument sakes if I select item B123ABC and my Division is R it gives me B123ABCF in the profit center and I cannot workout why this is.

I have removed the item and added it again, changed the formatted search to update on a different column but it has not worked.

Any suggestions on how I can get this to work correctly?

Regards,

Quinn