Good day
i need some help with a selection formula to select description from 5 different tables. once a user selects a transaction i need the formula to match it with the correct subledger and then using that it gives the description as of that subledger.
i.e.
Purchase order - description
inventory control - description
General ledger - description
Accounts payable - description
so if the transaction is coming from purchase order it should select the description as per the purchase order