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.
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
¿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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
