Backorder info

Mar 27, 2006 2 Replies
N

Does anyone know where the backorder information is stored in the SQL database? I have a custom intranet designed around RMS, one area that shows the customer purchase history for each customer. It would be nice to show the backorders each customer has also. I know it can be looked up directly in RMS, but not every computer has RMS installed, but all computers can get on the intranet.

Thanks, Nick

Vote
Twitter Facebook LinkedIn
N

Does anyone know where the backorder information is stored in the SQL database? I have a custom intranet designed around RMS, one area that shows the customer purchase history for each customer. It would be nice to show the backorders each customer has also. I know it can be looked up directly in RMS, but not every computer has RMS installed, but all computers can get on the intranet.



Thanks, Nick


Vote
Twitter Facebook LinkedIn
R
[Order] and OrderEntry tables, the same as WorkOrders and Layaways. It is the [Order].Type that determines that if it is a BackOrder or not. Order.Type 2: Work Order 3: Quote 4: Back Order 5: Layaway

Rob

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required