Alpha Video Training
Results 1 to 5 of 5

Thread: Backorder design advice needed

  1. #1
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,622

    Default Backorder design advice needed

    My wife has a craft business, and she often ships and bills partials. So, I need to add a backorder system to the Alpha Order Entry system, and I,m looking for advice on the best design.

    For example, would you create a new (backorder) order when the order is posted if not shipped complete, or would you use a child table of deliveries?

    Thanks for any help,
    Pat

  2. #2
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: Backorder design advice needed

    Pat,

    I think a lot depends on how you're set up now. Which would be the easiest way to show the delayed shipment? Perhaps a logical field to mark an item as delayed shipment and then uncheck it when it's shipped.

    You could easily create a query or whatever to show which customers's orders have been delayed. I wouldn't make it any more detailed than necessary. Keep it simple.

    kenn

  3. #3
    VAR
    Real Name
    Martin W. Cole
    Join Date
    Apr 2000
    Location
    Terrell, Texas (near Dallas)
    Posts
    5,950

    Default RE: Backorder design advice needed

    I have a client who sells merchandise on the internet. We daily get data from AuctionWorks and MonsterDotCom in excel files. I import the data and then process orders.

    When an order cannot be filled, I write the backorder to a matching "backorders" table.

    Naturally, inventory parts available is the key to the backorders. So when he gets new product delivered, it updates the inventory table.

    When the system processes orders, it appends backorders to current new orders, (empties the backorders table,) and processes back orders with the highest priority.

    When daily process orders completes, it creates and prints a picking list, for staff to pull items, gives him the opportunity to correct inventory count, and reprocess.

    When finished, it writes to backorders all unfilled orders, and sends the data for shipping to UPS and USPS software that prints mailing labels with postage, assigns tracking numbers, etc.

    When finished the postage software sends the data back, his alpha software looks for incomplete shipping info, etc., and then emails are sent to all clients with date sent, via, tracking numbers, etc.



  4. #4
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,622

    Default RE: Backorder design advice needed

    Martin,

    Thanks. You brought up some very good points.

    Your procedure sounds excellent, but my wife's business doesn't have that kind of volume yet. So, for an interim step, I think I'll also take Ken's advice and just make the new order directly into the order table. I'll add a logical field "BackOrder" and a "FromOrder" field so she can track back to the original order if she needs to, and I can use the BackOrder field and Order dates to prioritize the picks. This sounds easy enough that even I can figure it out!

    Thank you both for all your help.

    Pat

  5. #5
    Member
    Real Name
    gary keramidas
    Join Date
    Jul 2000
    Location
    Michigan
    Posts
    418

    Default RE: Backorder design advice needed

    read this by bill warner from a recent alpha newsletter

    http://newsletter.alphasoftware.com/0040203.htm

Similar Threads

  1. Form Advice Needed .....
    By Rich Hartnett in forum Alpha Five Version 4
    Replies: 19
    Last Post: 01-15-2006, 03:54 AM
  2. Advice/Help on Export needed.
    By PhilD in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-18-2005, 06:53 AM
  3. Advice needed
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 8
    Last Post: 01-16-2005, 02:12 AM
  4. Network advice needed
    By Charlain in forum Alpha Five Version 5
    Replies: 6
    Last Post: 06-06-2003, 07:37 AM
  5. Upgrade Advice Needed
    By David LITTLE in forum Alpha Five Version 4
    Replies: 15
    Last Post: 02-15-2001, 12:01 PM

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
  •