Anyone using User defined formula to derive a segment value

Summary:

Deriving Accounting in AR for invoices that are transferred from PPM. We have to derive the natural account based on the event type or expenditure type associated with the Invoice Line. AR is limited in what sources you can use, e.g. we can not use an api to update the Global Line DFF in the interface table. So we need to look at the line description.

The issue with using a mapping set is entering each expenditure type and event type you have to account for the extra spaces that are associated with the PPM Line Formats.

We tried to create User Defined formulas and assign it to an account rule but they have not worked. Example below: