Dynacom Technologies

Is there a way to get dataset for a specific invoice number without having to loop through the top level Invoice header?  For example in a normal database query I can get data for a specific invoice using the following query. SELECT * FROM inoice_table WHERE inoiceno=1.  How do I do the same using the Dynacom API.

Also, when I loop through the dataset for all invoices, credit memo are also being pulled.  Is this normal?  If so, how do I avoid getting credit memos when I only want invoices?

Hi,

you can give criteria parameter when you open the dataset of your section.

Here's an example :

    If clsheader.DataSet.OpenObject(omDefault, "InvoiId='ABC'") Then

Invoices dataobject include credit memo, quote, order and invoice. You can add a criteria to get only the invoitype that you want. In this blog : http://community.dynacom.com/EN/blogs/dynacom_blog/archive/2006/07/11/30.aspx you have an example on how to get invoitype enum.