In this guide, we're going to walk through how we can automate our stock movements by combining Futrli's Formula Forecast method and advanced options. This will involve us forecasting stock purchases on the balance sheet and then using a formula to decrease the value of our stock as sales are made.
First, we create a Forecast Item against our stock line to represent a new purchase. This will cause our stock line to increase by the value indicated:
Next, we're going to create a Forecast Item on our direct costs line which is tied to our sales. This will allow us to automate our costs and associated stock movements. In this example, we're assuming that our costs will be 30% of our sales, and forecasting accordingly using the Formula Forecast Method:
We'll then need to set the Forecast Item as a 'No cash' item, which will decrease the value of our stock, which can be done by ensuring both VAT and payment terms are set to zero, then hitting 'Override Journal Defaults' in the bottom right corner:
Now, whenever we enter sales on our sales line:
We'll see 30% of the value of the sale automatically being assigned to direct costs:
And our stock value fall by the same amount: