We have an instance where we sale to a wholesaler who then sales to two different channels and the price varies depending on the channel.
We currently invoice out at the higher of the prices (we only maintain one price list in SAP) then receive a rebate on a monthly basis to correct the net sales but we do not have visibility within SAP of this sales split for reporting.
Does anyone have an ideas of how we could manage two prices/ correct which price they go out at retrospectively/be able to pull a report on the volumes going to each channel?
We currently handle most of this outside in excel.
Hmmm, that would depend on if one channel always has the higher of the two prices, which you say that you invoice at or if it depends on the product that is being sold. The first scenario is easy because you simply sell out of that channel and then handle your rebate processing monthly. If it depends, then that opens a HUGE can of worms where you need to initiate sales orders that are distribution channel specific, but how would the wholesale entity know which one is appropriate in every case.