backorder design advice needed - alpha software message board
backorder design advice needed - alpha software message board
alpha software message board
> alpha five desktop
> old versions of alpha five
> alpha five version 5
backorder design advice needed
user name
remember me?
password
register
faq
members list
calendar
mark forums read
thread tools
02-20-2004, 06:36 am
#1
pat bremkamp
var
join date: apr 2000
posts: 835
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
pat bremkamp
view public profile
send a private message to pat bremkamp
find more posts by pat bremkamp
02-20-2004, 10:50 am
#2
forskare
member
join date: apr 2000
location: walker, mn
posts: 5,408
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
forskare
view public profile
send a private message to forskare
find more posts by forskare
02-20-2004, 12:14 pm
#3
martinwcole
var
join date: apr 2000
location: terrell, texas (near dallas)
posts: 3,528
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.
martinwcole
view public profile
send a private message to martinwcole
visit martinwcole's homepage!
find more posts by martinwcole
02-20-2004, 04:22 pm
#4
pat bremkamp
var
join date: apr 2000
posts: 835
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
pat bremkamp
view public profile
send a private message to pat bremkamp
find more posts by pat bremkamp
02-22-2004, 08:56 pm
#5
gkeramidas
member
join date: jul 2000
location: michigan
posts: 134
re: backorder design advice needed
read this by bill warner from a recent alpha newsletter
http://newsletter.alphasoftware.com/0040203.htm
gkeramidas
view public profile
send a private message to gkeramidas
find more posts by gkeramidas
«
previous thread
|
next thread
»
currently active users viewing this thread: 1 (0 members and 1 guests)
thread tools
show printable version
email this page
posting rules
you may not post new threads
you may not post replies
you may not post attachments
you may not edit your posts
vb code is on
smilies are on
[img] code is on
html code is off
forum jump
user control panel
private messages
subscriptions
who's online
search forums
forums home
announcements
alpha five application server
alpha five application server version 8
web application server v7
web application server v6
alpha five desktop
alpha five version 8
alpha five version 7
features wishlist
upgrading to alpha five from alpha four
old versions of alpha five
alpha five version 6
alpha five version 5
alpha five version 4
alpha five versions 2 and 3
alpha five version 1
qreportbuilder
qreportbuilder
alpha four
alpha four versions 7 and 8
alpha four version 6 and prior
regional forums
uk users
other forums
database design
other products
code archive
forum support
forum support
similar threads
thread
thread starter
forum
replies
last post
form advice needed .....
rich hartnett
alpha five version 4
19
01-15-2006 03:54 am
advice/help on export needed.
phild
alpha five version 5
4
01-18-2005 06:53 am
advice needed
brian gray
alpha five version 5
8
01-16-2005 02:12 am
network advice needed
charlain
alpha five version 5
6
06-06-2003 07:37 am
upgrade advice needed
david little
alpha five version 4
15
02-15-2001 12:01 pm
all times are gmt -4. the time now is 12:01 pm.
contact us -
archive -
top
powered by vbulletin® version 3.6.8copyright ©2000 - 2007, jelsoft enterprises ltd.
copyright © 2007, alpha software, inc.
backorder design advice needed - alpha software message board Précédent 281 Précédent 280 Précédent 279 Précédent 278 Précédent 277 Précédent 276 Précédent 275 Précédent 274 Précédent 273 Précédent 272 Précédent 271 Précédent 270 Précédent 269 Précédent 268 Précédent 267 Précédent 266 Précédent 265 Précédent 264 Précédent 263 Précédent 262 Précédent 261 Précédent 260 Précédent 259 Précédent 258 Précédent 257 Précédent 256 Précédent 255 Précédent 254 Précédent 253 Précédent 252 Suivant 283 Suivant 284 Suivant 285 Suivant 286 Suivant 287 Suivant 288 Suivant 289 Suivant 290 Suivant 291 Suivant 292 Suivant 293 Suivant 294 Suivant 295 Suivant 296 Suivant 297 Suivant 298 Suivant 299 Suivant 300 Suivant 301 Suivant 302 Suivant 303 Suivant 304 Suivant 305 Suivant 306 Suivant 307 Suivant 308 Suivant 309 Suivant 310 Suivant 311 Suivant 312