Work order

Question

Where I can find the work order header & material details in C# language?( help-sage100.na.sage.com/.../index.htm In which table I can find those? 
 Eg: For purchase order I fetch the details from PO_PurchaseOrder_bus. Where I can find the details of work order 
 Sage 100 Help help-sage100.na.sage.com

David Speck · Accepted Answer

You have the legacy Work Order module and cannot use BOI to read work order details. 
 There is a class called WO_WorkOrder_svc but I have never used it and I think it is only good for reading data in WO1. 
 Refer to the link in my first response, that list all of the files used along with their table name as seen through ODBC. 
 You are likely going to be after at least WO1 and maybe WO2 and/or WO3.

David Speck · Answer

Depends on your version and product. 
 If you really mean Work Order as in the legacy Work Order module, there aren't business objects (or rather only a couple for reading purposes IIRC) and one of your only options is to query the data through ODBC. 
 Refer to the file listing for the Work Order module. 
 https://help-sage100.na.sage.com/2019/FLOR/#File_and_Table_Listings/WOFileSizes.HTM 
 If you mean Work Tickets and have Sage 100 Manufacturing (JobOps) installed, IIRC, the data is stored in SO_SalesOrderHeader and SO_SalesOrderDetail and you can query it through ODBC or use SO_SalesOrder_Bus and its Lines object handle property. 
 If you mean Work Tickets and have Sage 100 Production Management installed, the data is stored in JT_WorkTicketHeader, JT_WorkTicketDetail, and JT_WorkTicketStep and you can query it through ODBC or use JT_WorkTicket_Bus and its Steps and Parts object handle properties.

Sage 100

Work order

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING