How to:Sales Order SQL query for ofBiz

[Joannes Vermorel <jo...@gmail.com>]

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

Re: How to:Sales Order SQL query for ofBiz

["David E. Jones" <jo...@hotwaxmedia.com>]

On Apr 5, 2007, at 12:37 PM, Jacques Le Roux wrote:

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

Actually sales _order_ history information would be from the order  
component. Sales _invoice_ history would be in accounting.

-David

Re: How to:Sales Order SQL query for ofBiz

[Jacques Le Roux <ja...@les7arts.com>]

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

Re: How to:Sales Order SQL query for ofBiz

[Walter Vaughan <wv...@steelerubber.com>]

Joannes Vermorel wrote:
> 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.

ofBiz works with all the databases you already support. It'll be nothing more in 
learning which tables to pull data from, and you know what you need.

http://ofbiz.apache.org/documents.html

--
Walter