Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jan 2013
    Posts
    74
    Thanks
    19
    Thanked 1 Time in 1 Post

    Advice on developing an inventory tracking system

    I have to develop an inventory tracking system that will allow the customer to run reports for any selected time frame of inventory turns - ins and outs. At the end of the report, it has to accurately show what the current inventory was at that time. The only way I can think of doing this is to have a CRON job run every night that records the inventory of every product by date. This way every day will have a beginning and final inventory tally. But because there are so many products, this will fill up the database pretty quick. I figure after a year a new table will need to be created and the previous one archived.

    Does anyone else have any other ideas on how to achieve something like this without recording daily inventory levels?

  • #2
    New to the CF scene
    Join Date
    Jul 2014
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't have any idea about it.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •