Skip to Content
0
Dec 29, 2018 at 07:52 AM

FMDerivation Rule Error

355 Views Last edit Dec 29, 2018 at 09:22 AM 3 rev

Hello Eli and other experts,
We have a FMDerivation rule to derive Functional Area and Funded Program by Funds Center.
This rule is to derive specifically for one Fund Type where the FA and FP is static and this was working fine until now for (AP invoice / PO Cost Center based).

Source Field
Funds Center - 100001 - 100075

Target Fields

Functional Area = 2018FunctionArea (do not overwrite if field already filled)

Funded Program = ABCFundedPrg (do not overwrite if field already filled)

Now as New Fiscal Year approaches, there is a new Budget period and with new 2019FunctionArea, so the rule was changed to derive FA and FP with the new Budget Period. With new rule FA and FP not deriving.

Source Field

Funds Center - 100001 - 100075

Budget Period = 2018 -2018

Getting : Derivation not performed. Reason: Source field contains no value for Budget Period field empty in Trace

Funds Center - 100001-100075

Budget Period = 2019 - 2019

Target Fields
Functional Area = 2019FunctionArea (do not overwrite if field already filled)

Funded Program = ABCFundedPrg (do not overwrite if field already filled)

Was able to post AP invoice (FA and FP gets derived after pressing Enter button twice.) For PO based able to derive in second pass in trace but PO fields not getting updated.

Need your input where the issue could be.

Thanks,

Sam.