About Us

[email protected]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can we run FIFO Inventory in excel?	NH	Excel Worksheet Functions	2	March 4th 09 09:29 PM
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene	LunaMoon	Excel Discussion (Misc queries)	0	July 28th 08 11:03 PM
Program for inventory	r1947	Excel Discussion (Misc queries)	2	August 14th 06 06:31 AM
How to prepare Multi Stock Valuation on Fifo Basis in Excel	md12nov	Excel Worksheet Functions	0	April 12th 06 09:09 AM
FIFO Inventory tracking	Marcotte A	Excel Programming	0	September 9th 04 12:33 AM

Menu

About Us