Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Orden de trabajo-Factura-cantidades-articulo no tiene existencia

Posted on by 20

En ordenes de Servicios -Factura -Detalles tiempo y Materiales (SD.203.00) Cuando intento introducir un valor en el cuadro cantidad me dice que articulo no tiene existencia. Ya revice el inventario y si tiene existencia y disponible esos artículos.

  • Verified answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Orden de trabajo-Factura-cantidades-articulo no tiene existencia

    Hello

    The screen is running the proc below. I will think that perhaps its not returning the correct record.

    I ran the proc on the inventory item that does not have qty and "right" side of the record read NULLS

    I would suggest that you create a case in MS-Support, if running the proc passing your data returns accurate results, I'm thinking something is not joining up with the location and loctable tables.

    SP_HELPTEXT DMG_LocTable_LocAvail -----  'INVTID',  'SITEID',  'WHSELOC'

    CREATE PROCEDURE DMG_LocTable_LocAvail

    @parm1 varchar ( 30),

    @parm2 varchar ( 10),

    @parm3 varchar ( 10)

    AS

    SELECT LocTable.*, Location.*

    FROM LocTable

    LEFT JOIN Location

    ON LocTable.SiteID = Location.SiteID

    AND LocTable.WhseLoc = Location.WhseLoc

    AND Location.InvtID LIKE @parm1

    WHERE LocTable.SiteID LIKE @parm2 AND LocTable.WhseLoc LIKE @parm3

    ORDER BY LocTable.SiteID, LocTable.WhseLoc

  • glemar Profile Picture
    glemar 20 on at
    RE: Orden de trabajo-Factura-cantidades-articulo no tiene existencia

    ¿Está disponible mostrando correctamente en la esquina inferior izquierda de la pantalla? Si aparece disponible, ya se verifico en almacen y hay existencia

     Â¿Está usted en el sitio correcto y utiliza la ubicación que contiene esa cantidad? si correcto verificado

    ¿Qué versión de MSDSL? 2015

  • Verified answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Orden de trabajo-Factura-cantidades-articulo no tiene existencia

    Hello Glemar,

    In regards:

    In Service orders -Invoice -Details time and Materials (SD.203.00) When I try to enter a value in the quantity box it tells me that article has no existence. Already check the inventory and if there are existing and available those items.

    Is available showing correctly on the bottom left corner of the screen? Are you in the correct site and whouse location that contains that qty.

    It runs the following: DMG_LocTable_LocAvail  '0RBOLT',  'HOWLONGCAN',  'NA'    (this passes invenotry, site, wherehouse location)

    What version of MSDSL? I find it records the correct qty at the site on the screen.

    Best Regards,

    Jana MacDonald

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans