I have a module that contains ledger data and includes information such as suppliers, produts, departments and ledger mappings as well as the cost/income on a monthly basis.
I want to create a module that end users can input into for their department where they're entering details for their next year's budget. For this, I'm using a numbered list for them to input a line for each supplier's costs with the product it is mapped to and the ledger mapping for that cost.
Depending on their input I would like to show them the previous year's cost for that combination of inputs. I'd like to be able to do this without creating a large calculation module for the ledger data that is dimensioned by all of the information and doing a lookup as the data will be very sparse and space is limited.
Is there another way I can achieve that lookup?
