| Subject | Re: SQL or Array Rowset ? |
| From | Robbie Nott <robnott@mweb.co.za> |
| Date | Tue, 6 Apr 2021 15:02:49 +0200 |
| Newsgroups | dbase.getting-started |
On 4/6/2021 10:49 AM, Mervyn Bick wrote: > On 2021/04/06 09:21, Akshat Kapoor wrote: > >> Sorry Robbie Have not been able to devote time to this issue as busy >> with some other non computer work. >> >> But as Bruce has mentioned making calculations and displaying data at >> the same time could be an issue. >> >> On a side note why not store current inventory in a table. >> My only app is a inventory and accounts control package. >> >> I store the current inventory info in a different column. All pieces >> sold are instantly deducted and purchased qty are updated. >> >> So when I have to view current inventroy I just have to view the >> required column data. > > Robbie's problem is a bit more complicated but this is a good starting > point. Although there's a school of thought that holds that one should > never save a value which can be calculated there are cases, such as this > one, where keeping a running total can save time in presenting results. > > There are so many unknown factors to take into account not the least of > which is how long does it take to get stock. > > If you have 15 items in stock you can issue a quotation for, say 10, for > immediate delivery. Unless you can replace stock immediately you can't > sell the 10 items or issue another quotation for more than 5 items > during the validity of the quotation. Your list would, therefore, also > need a column for reserved items. > > If it takes, say, a month to replace stock you can now only issue a > quotation for 10 items for delivery in a month's time provided you place > an order on your supplier for 10 units assuming you need a minimum of 5 > items in stock for "walk in" customers. If neither quotation is > accepted you sit with 25 items in stock. Can you afford to have so much > cash tied up in stock? > > The alternative is to issue the second quotation valid for a month but > only delivered a month after acceptance with the possibility of earlier > delivery if the initial quote is not accepted. Great if the customer > will accept those terms. It is, of course, quite likely that the > customer will shop elsewhere. > > Mervyn. Hi Mervyn All your stock points are valid. Client and I have gone to great pains to make it a bit easier. Program has an elaborate system to calc demand based on historical sales. Stock items are turned on site. Over 1000 bins Program issues a "To Make" report every day to maintain stock levels. I have been battling with the idea of "live" columns in a grid... As I mentioned to Akshat - I'll try to create and attach field objects to my queries Then I can display the "live" data in my grid Many thanks for feedback Robbie | |