Re: Logic to Solve different companies mapping to SKU as input
Without any further understanding of the requirement, I assume that the time period input will be some sort of exception per C7 code. Please find the quick mockup that I did. Hopefully it helps with what you're trying to do.
I made a modification to the input per SKU to only show Unit Sales Price and Time Period as you have already made the checkbox selection on SKU Data.
Step 1: Define the check box by c7 code and company then translate that it into a count.
Step 2: Create another module with c7 code as list and define the price exception (assuming this is the case for all the checkboxes per c7 code).
Step 3: Create another module with c7 code, company and time as lists then refer to the sales price exception. For those not defined, I assume that they will just refer to the price defined per c7 code. If this is not the case, you can easily refer to a different module or just stick to the prorate formula: