Home Page link  

Backorder info

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Backorder info Nick 03-27-2006
Posted by Nick on March 27, 2006, 11:37 am
Please log in for more thread options
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




Posted by Rob on March 27, 2006, 12:33 pm
Please log in for more thread options
[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

> 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
>
>
>



Similar ThreadsPosted
Backorder info March 27, 2006, 11:37 am
Backorder Processing June 2, 2005, 2:28 am
Backorder deposit October 10, 2006, 5:26 pm
Backorder Deposits October 10, 2006, 5:27 pm
picking up a backorder with 100% deposit January 25, 2006, 5:59 pm
Backorder for item never stocked February 23, 2006, 7:20 pm
Work Order Vs Backorder May 9, 2006, 5:34 pm
Backorder Printing as Invoice December 15, 2006, 2:01 pm
Shipping charges on a backorder January 2, 2007, 9:00 pm
how to cancel or void a backorder July 16, 2007, 12:38 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap