Re: How to:Sales Order SQL query for ofBiz

[David E. Jones]

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.

-David

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

smime.p7s
Description: S/MIME cryptographic signature