> > We are considering implementing a sales forecasting add-on for ofBiz (we have > already done this with other ERPs, see http://community.lokad.com). In order > to support ofBiz, our needs are quite limited, since we need only a SQL > query to retrieve the sales order history. Yet we have no experience with > ofBiz at this point. > > A few naive questions: > - was is the "right" module for to retrieve the sales orders history? > accounting or POS?
accouting, the POS is only an interface using other modules. > - we are making the query from a .NET application; it is possible to achieve > a database independence? (Web Services API maybe?); if not what would be the Yes using SOAP/WDSL you can use the OFBiz's services . It Require a tool like Apache Axis Java2WSDL : http://ws.apache.org/axis/java/user-guide.html#UsingWSDLWithAxis Because OFBiz currently deals only with simple WDSL type (not complex types) and uses the transport style="rpc" and not "document" used by .Net Jacques > suggested instead? > > Best regards, > Joannès Vermorel > http://www.lokad.com > Hosted sales forecasting > -- > View this message in context: http://www.nabble.com/How-to%3ASales-Order-SQL-query-for-ofBiz-tf3531848.html#a9856541 > Sent from the OFBiz - User mailing list archive at Nabble.com. >
