Skip to Content
0
Former Member
Dec 09, 2011 at 07:56 AM

FMS displaying previous value when refreshing by Total

46 Views

Hi

I have a formatted search for a UDF that requires "Gross Profit (LC)" in its calculations but when I refresh regularly by either Document Total or Line Total it returns the previous gross profit value instead of the current one.

The reason I refresh by these values is because the FMS changes based on multiple conditions and this was suggested in a previous Forum post.

is-it-possible-to-auto-refresh-a-fms-field-based-o

All the other fields used in the FMS return the correct values except for the Gross Profit. Here is the FMS I used to test the values returned for Gross Profit.

select $[$38.123.number]

Example of values returned:

Original Gross Profit for an item: 8.52

Gross Profit after change of unit price: 9.52

When you enter an item the UDF displays 0

Change the unit price the UDF displays 8.52

Change the unit price back the UDF displays 9.52

I have tested this in multiple DBs using SAP BO 8.81 PL: 07

I would like to know why it does this and if there is workaround to this problem?

Thank you for your time.