Future stock calculation based on budget Units with multiple SKUs

[Jameswh91]

Hi Community,

I have an issue when it comes to predicting future stock based on budgeted units. In a simple world i would have been able to calculate this based on current stock - budgeted sales + goodsins by sku.

Unfortunately, we have multiple sku's for some products and the budget has been produced by product type and not sku. So the normal calculation would not work as if we have 2 sku's for one product it would be doubling the forecasted units.

Is there a work round for this?

Any help would be much appreciated.

[PaulDBrown]

Can you share some sample non-confidential data and a depiction of the expected outcome?

[Jameswh91]

Sure. Here's an example. SKU RB0001 and RB0002 are black briefs.

January stock amount in inventory table is:

RB0001 = 80 Units

RB0002 = 20 Units

Budgeted Units for January are that black 50 black briefs will be sold.

So i need the predicted amount of stock for Febuary to show 50 units.