Why not have a BackOrder Table and print a daily report for items due on that date, or tommorrow's date. or no date. Bernie Lis ----- Original Message ----- From: Jim Belisle To: RBASE-L Mailing List Sent: Wednesday, April 08, 2009 5:21 PM 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
