hi,

it is not possible to oversell the inventory.

many thanks

wrote:
Sorry, I have one more question for you. Is it possible to oversell
your inventory? I am nearing a solution for you and do not currently
have solution for reducing inventory below 0.


wrote:
hi, amount is for both...
if the bond is sold, then the number shows amount sold
if the bond is purchased, then the number shows amount bought

tha.

wrote:
"Amount" is the volume purchased or sold?

wrote:
dear all,

I have 1 sheet which contains product name, buy or sell, price, amount,
trade date, counterparty.
for example :
book A - buy - $50 - 10 - 1 jan 06 - G
book B - buy - $100 - 20 - 1 jan 06 - G
book A - buy - $60 - 15 - 2 jan 06 - H
book A - sell - $65 - 15 - 3 jan 06 - I
book B - sell - $110 - 15 - 3 jan 06 - J

I would like to have a new sheet which shows FIFO for those books
so it would shows table with something like

book A - sell - $65 - 15 - 3 jan 06 - I consist of : book A - buy -
$50 - 10 - 1 jan 06 - G
:
book A - buy - $60 - 5 - 2 jan 06 - H

(book A sold at 3 jan 06 to I at price $65 is using 10 books bought at
1 jan 06 at price $50 from G & 5 books bought at 2 jan 06 at price $60
from H (in table form))

how can I do that ?

thanks