Sage: find articles’ purchase price (FindBasePrice )

Sage: find articles’ purchase price (FindBasePrice )

Read the data for one or more data records for the articles’ purchase prices. In the input parameter group, multiple parameters can be filled with the corresponding search criteria. If the parameters contain the character %, a search is made with like, otherwise with =. The individual search criteria are connected with AND. All fields in the table e025 can be entered. Alternatively, the complete search command can be given as well by using the parameter where in the search parameter group (e.g. baseprice_such.where = ’identnr eq \’0 093 S 544 1N\’ and menge_ab gt 1’). With the parameter select, you can specify which fields are to be read. If a select is not entered, all fields are read. The function returns all prices found in an indexed parameter group. The indexation of the parameter group is adjusted if necessary. If unknown search criteria are used, the service delivers a corresponding error message. This is entered via the parameter Message. Before evaluating the output parameter group, the parameter Message should be verified.

The following parameters in the parameter group are filled:

identnr, konto, dataen, datneu, useraen, userneu, best_art, bonuskz, datvon, ekpreis, faktor, formelnr, kn_aktionsprs, kn_bestueb, menge_ab, peek, pr_art, pr_bezug, preisgrp_e, pr_herk_e, waehrung, znr, zu_ab, zuab_wert, zuab_wertf, zuab_wert2, zuab_wert3, zu_ab2, zu_ab3, mep, umrechb, mep, umrechp.