on 05-19-2014 2:56 PM
Hola
Necesito su apoyo para crear una guía de remisión en SAP B1
PROCEDURE:
CREATE Procedure [dbo].[SP_GUIA_REMISION]
@docentry int
as
SELECT
d.DocEntry 'Numero Interno',
D.DocDate 'Fecha Documento',
D.DocDueDate 'Fecha Entrega',
D1.BaseDocNum 'Orden de Venta',
upper(A.CompnyAddr) 'Direccion Partida',
D.Address 'Direccion Destino',
D.CardName 'Razon Destino',
substring(D.CardCode,2,11) 'Ruc Destino',
d1.Quantity 'Cantidad',
d1.Dscription 'Descripcion',
d1.unitMsr 'Unidad'
FROM OADM A,ODLN D
INNER JOIN DLN1 D1 ON d.DocEntry=d1.DocEntry
WHERE d.DocEntry=@docentry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.