Victor, When an order is placed, it is entered just into only the sale header and detail table, correct?
Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Victor Timmons Sent: Wednesday, April 08, 2009 6:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: ORDER FORM Well that's not to different from what we do. I have sale order tables a header table and an detail, and shipping tables. I schedule the order for shipping and that puts in a shipping header table and shipping detail table (line items) we make the shipment and what doesn't ship gets put back in the shipping table under the same order number but different shippingid. OrderID = 123456-1 ShippingID = 123 So in the shippingheader table you have ShippingID 123 OrderID 123456-1 In the ShippingLN table ShippingID 123 Line 1 123 2 123 3 Next shipment ShippingID 124 OrderID 123456-1 And what ever didn't ship from the last order. It seems to work just fine Remember the goal "100% Attitude, Accuracy and Complete on Time Orders" A 5 Star business since 2001 P Please consider the environment before printing this e-mail -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, April 08, 2009 2:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - ORDER FORM When our company sells products, often we sell items that drop ship from locations other than our main office. This necessitates more then one ship date. In the past we would split the order in essence creating a two orders. Now we want to have in the detail section the fields for ordered, shipped, backorder plus a ship date. Not a problem. What I am after is the most efficient way of being able to: 1) ship everything since that is what happens most of the time. 2) ship partials but keeping everything on the same order. I want our people doing shipping and the invoicing not to miss items that may not have shipped because a ship date has been populated on some items but not the others. Anyone have an idea on the most fool proof method to do this? Jim
