From: "mattc66 via AccessMonster.com" <u16013@uwe>
Date: Thu, 04 Sep 2008 21:42:57 GMT
Hi All,
I am working on a scheduling program. We need to schedule shipments of orders
and pull from stock. The orders would be in a FIFO method or First In First
Out basis. The first order in for an item, if the item is in stock that order
will ship. The thing I am struggling with is orders with multiple items and
the order must ship complete.
We don't have enough inventory to fill Order#1, but we can fill Order#2. Even
though order#1 came in first we would fill Order#2 rather then hold up the
order#2. Does anyone know how I could show in a query or multiple query's
this selection?
Re: Calculate profits on stock sales on FIFO basis ... Date Stock Action Qty Price Gain... 01-01-09 IBM Buy 50 100 ... I wonder how you would handle splits and stock dividends that change basis. ... I need the gain made by me on that particular 'Stock' sale based on FIFO. ... (microsoft.public.excel.newusers)
Re: Computation in one form from the other forms ... which refers to the curremt value of the field txtItemNumber... in the form of the Main Stock where i have a field of Begbal ... and a field for QtyonHand... created a table and form for the issue voucher where the information ... (microsoft.public.access.formscoding)
Re: Computation in one form from the other forms ... in the form of the Main Stock where i have a field of Begbal ... and a field for QtyonHand... only getting one calculation for all of items in the table. ... created a table and form for the issue voucher where the information ... (microsoft.public.access.formscoding)
Re: Computation in one form from the other forms ... i will use to deduct quantity in the Main Stock form but the QtyonHand ... and a field for QtyonHand... only getting one calculation for all of items in the table. ... created a table and form for the issue voucher where the information ... (microsoft.public.access.formscoding)
Re: Computation in one form from the other forms ... i will use to deduct quantity in the Main Stock form but the QtyonHand ... and a field for QtyonHand... only getting one calculation for all of items in the table. ... created a table and form for the issue voucher where the information ... (microsoft.public.access.formscoding)
