I was working with Flowgear-Sage Evolution Integration.I can able to create the Orders & Accounts and other services in sage evolution using flowgear node.But I cannot find the relevant node for retrieving the Accounts or Order based on some input.Please help me out doing this.
On connectors which we have access to the database, we use a SQL Query to read from the product, and use the connector to write to the product.
You will use the same SQL details on the SQL Query connector as you did on the Sage Evolution connector.
The accounts table is called Clients, the order header is InvNum, and the order detail is _btblInvoiceLines.
The AutoIndex on InvNum links to iInvoiceID on _btblInvoiceLines.