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

(1) Share

Report

Posted on by glemar

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.

All responses (3)

Answers (2)

Verified answer

CFROTON 4,710 on at

Like (0)

Report

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 20 on at

Like (0)

Report

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 4,710 on at

Like (1)

Report

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