Results 1 to 4 of 4

Thread: The owner of my store is amazing

  1. #1
    resident Humboldt's Avatar
    Join Date
    Oct 2000
    Location
    Northern CA
    Posts
    28,150

    The owner of my store is amazing

    As I've mentioned for years, he wrote most of the software we use and can tweak it or write new programs as needed.
    2 time Microsoft MVP.

    Ongoing issue for 20 years I've been there of orders being received and verified but never actually "check in" and added to our inventory.

    Plays havoc with inventory, product doesn't show as in stock online, f*cks with bookkeeping, etc...

    3AM idea a few nights ago.

    Basically, we have an inventory program he wrote 40 years ago, tweaked ever since.

    It can build an order we send to a supplier.
    When the order is received we create a check-in sheet according to what they say they sent.
    Print that, employee verifies and notes errors, we adjust the final check-in taking those into account, click the "check-in" button that adds the products and value to our inventory.

    Problem is one employee who will receive the check-in sheet from an employee, scan it and the invoice, shred them, but never click the damn last button.

    We're talking 7 orders in the past 2 weeks.

    I asked if when the "print check sheet" button is clicked that supplier could get shifted to a queue.
    When the "check in" button is clicked, it gets removed.

    That queue could be viewed at any time.

    Within 90 minutes he created a new Access table with all the info and tweaked the inventory program to write to it.

    See what happens but super simple fix that he made work ASAP!

  2. #2
    Administrator Philip's Avatar
    Join Date
    May 1999
    Location
    Jacksonville, Florida
    Posts
    11,330
    Blog Entries
    6
    Sounds like a good practical eloquent solution... I would have probably just created some type of log file with timestamps and actions, being written into as in that "queue".
    Linux is user friendly, it's just picky about its friends...
    Disclaimer: Please use caution when opening messages, my grasp on reality may have shaken loose during transmission (going on rusty memory circuits). I also eat whatever crayons are put in front of me.
    ๑۩۞۩๑

  3. #3
    resident Humboldt's Avatar
    Join Date
    Oct 2000
    Location
    Northern CA
    Posts
    28,150
    Quote Originally Posted by Philip View Post
    Sounds like a good practical eloquent solution... I would have probably just created some type of log file with timestamps and actions, being written into as in that "queue".
    True, but the data has to come back out also.

  4. #4
    resident Humboldt's Avatar
    Join Date
    Oct 2000
    Location
    Northern CA
    Posts
    28,150
    Works like a charm. F*cking awesome.

    And we don't do anything new, it just works in the background with the same 2 buttons we've always used, just a new way to look at it.

Similar Threads

  1. Pet owner poll
    By Humboldt in forum General Discussion Board
    Replies: 7
    Last Post: 04-04-21, 04:47 PM
  2. Helped reunite dog w/ owner
    By Humboldt in forum General Discussion Board
    Replies: 1
    Last Post: 04-05-14, 02:51 AM
  3. new owner of 6 flags in ky
    By horsemen_ in forum General Discussion Board
    Replies: 76
    Last Post: 05-15-08, 11:31 PM
  4. Welcome Owner
    By RicRogue in forum Distributed Computing
    Replies: 2
    Last Post: 09-02-04, 07:27 AM
  5. stupid RSX owner
    By nightowl in forum General Discussion Board
    Replies: 23
    Last Post: 06-03-03, 03:34 AM

Bookmarks

Posting Permissions

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