GL Advance Allocation using Lookup Table

Has anyone created an allocation code using a Formula Ratio Setup Option? I am expecting to fetch the GL Allocation using a dynamic formula defined via a Lookup Table or a BAQ.

I can add the parameters defined via the target account but wondering if there is any way that would help me to do the following:

  • Choose the Target Account dynamically (based on the account defined using the Lookup Table)

  • Define the allocated amount based on the Target Value defined via the Lookup Table