Follow

Retrieve an information about an Item

The art_info() function allows you to retrieve an information from an Item once you know its ID.

 

The Item ID is articles.ar_numero. It can be found in the Item table (articles.dbf), and in any table that has a foreign key relation with the Items table. Check the chapter about commonly used tables in order to find out this information.

Examples

*/ Display the default Item purchase price in a commercial document. Dl_article must be available, and it is the foreign key for ar_numero in the Document lines table.

art_info(dl_article, 'ar_fn_prix')

*/ Display the creation date of an article. The Items table must be already opened.

art_info(ar_numero, 'ar_datecre')

*/ Display the weight of an item. Dl_article must be available, and it is the foreign key for ar_numero in the Document lines table.

art_info(dl_article, 'ar_poids')

*/ Same as above, but from a report not including documents.

art_info(ar_numero, 'ar_poids')

*/ Display the content of one of the 1st miscellaneous field of an Item.

art_info(ar_numero,'ar_utilis1')

art_info(dl_article,'ar_utilis1')

*/ Display the weight of an Item.

art_info(dl_article, 'ar_poids')

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments