Re: Wanted some practical problems to solve in data structures

"sweety_s" <gayatri.neelema@xxxxxxxxx> wrote in message
news:4d8ab64d-70c9-4683-bf5a-fed8cee85a9b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am interested in DS, but wanted some real application problems so
that i can improve my concepts regarding this subject

thanks

An invoice. I.E. All information needed to print an invoice. You probably
want to look at "normalizing data" for this. So for this invoice you would
want a customer record. And ship to, inventory item, quantities, etc..
There are quite a few structures invovled in that to tie it all together.

A common way to do it is to have a customer file (with customer records/data
structores). Invoice header. Invoice detail (items). Inventory file.
When goes into A/R (Accounts Receivable).

Make a simple retail store program and you'll find yourself creating
datastructures and normaling data all over. My first professional
programming job was writing a complete POS system for a small store
including inventory, invoicing, accounts receivable, etc.. in dBase III.



.

Relevant Pages

  • Re: tracking inventory
    ... Would you rather enter all the invoice information and expect the data is pushed to the transactional record, or would it be OK to enter the transaction details first and then generate an invoice? ... To your questions about calling up details and adjusting inventory, these should be relatively easy tasks once the broader structure of the application is defined. ... If I were keeping track of inventory, I would have a master "catalog" page that lists all the items, one per row, starting inventory counts, and a /calculated/ current inventory number. ...
    (microsoft.public.excel.misc)
  • Re: tracking inventory
    ... adjusting inventory levels to improve cash flow. ... after filling in the invoice other things happen in the background. ... The transaction record says we sold x ... that lists all the items, one per row, starting inventory counts, and a ...
    (microsoft.public.excel.misc)
  • Re: tracking inventory
    ... Just to expand on the last note about the sales sheet; ... adjusting inventory levels to improve cash flow. ... after filling in the invoice other things happen in the background. ... I have all the products on one sheet with all information and a blank column ...
    (microsoft.public.excel.misc)
  • Re: tracking inventory
    ... product info price/size/supplier etc. including a starting inventory balance. ... Another sheet would be an invoice template, ... that lists all the items, one per row, starting inventory counts, and a ... Well, the transaction history. ...
    (microsoft.public.excel.misc)
  • Re: tracking inventory
    ... the transactional data can ideally take care of adjusting inventory stats and other reporting needs. ... How would I be able to write up an invoice and have that "Transactional data" automatically transferred to a detailed report/worksheet? ... I have seperate worksheets for each supplier with their products. ... If I were keeping track of inventory, I would have a master "catalog" page that lists all the items, one per row, starting inventory counts, and a /calculated/ current inventory number. ...
    (microsoft.public.excel.misc)