Skip to Content
author's profile photo Former Member
Former Member

Busqueda Formateada Costo del item

Saludos a todos,

Gracias de antemano por leer mi consulta, en esta oportunidad estoy tratando de crear una busqueda formateada a un campo de usuario llamado U_UnitItemCost en la Tabla de Cotizaciones, a nivel de detalles, (QUT1) que me traiga de la base de datos el Costo del Item de la fila actual, pero no se que campo en la tabla Item Master Data (OITM) esta el Costo del item.

Si alguien conoce ese campo y se lo agradeceria muchisimo!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 13, 2015 at 08:26 PM

    Hola Mario.

    Tengo una consulta similar:

    SELECT T0.AvgPrice FROM OITM T0 Where T0.ItemCode = $[$38.1.1]

    Con esta solucionas tu requerimiento.

    Suerte.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.