This is just a P+L for internal purposes, therefore general accounting
principles do not matter. If someone could answer with formulae it would be
much appreciated

"Gordon" wrote:

"marabona" wrote in message
...
I am creating a P+L and need a formula for this instance. I am reasonably
profficient on this software but have never had to generate a spreadsheet
like this.


Re-order of goods for re-sale comes from a STOCKS record, NOT the P&L......
In your stock sheet you just say "if the quantity of free stock is less than
a certain amount, re-order" Of course a time calculation also comes in
because you can't get delivery instantly (well not usually anyway).
I think you'll find this is a lot more complicated than you think.....