FAVORITOS

Imagen
Código
Descripción
Precio

DATOS PERSONALES

Mis datos

Nombre o razón social : §NOMBRE§

DNI o CUIT : §DNICUIT§

Dirección : §DIRE§ , §CIUDAD§ , CP:§CP§

Telefono : §FONO§

Mail : §MAIL§

Tipo Fiscal : §FISCAL§

Por cualquier modificación envía un correo a: matrix@cemsisrl.com.ar

MI HISTORIAL DE PEDIDOS

Pedido # fecha de pedido Total Metodo de envio tacking / detalle Enviado Fecha de envio Seguimiento

MI SERVICIO TECNICO

{{ GBP_LIST; NAME:=RMAHISTORIAL; SQLSCRIPT:= SELECT dbo.tbRMA_Header.rmah_cd AS Fecha, CAST(dbo.tbRMA_Header.rmah_id AS Varchar) + '-' + CAST(dbo.tbRMA_Detail.rmad_id AS Varchar) AS ID, dbo.tbItem.item_code AS Codigo, dbo.tbItem.item_website_desc AS Descripcion, dbo.tbRMA_Detail.rmad_ReceptionNote AS Observacion, dbo.tbRMA_Detail.rmad_serial AS Nro_Serie, COALESCE (dbo.tbRMA_Detail.rmad_DiagnosticNote, ' ') AS Diagnostico, dbo.tbsysDocuments.sd_desc + ' ' + dbo.tbCommercialTransactions.ct_kindOf + ' ' + CAST(dbo.tbCommercialTransactions.ct_pointOfSale AS varchar) + '-' + CAST(dbo.tbCommercialTransactions.ct_docNumber AS varchar) AS Comprobante_Asociado FROM dbo.tbCommercialTransactions INNER JOIN dbo.tbItemTransactions ON dbo.tbCommercialTransactions.ct_transaction = dbo.tbItemTransactions.ct_transaction INNER JOIN dbo.tbsysDocuments ON dbo.tbCommercialTransactions.sd_id = dbo.tbsysDocuments.sd_id RIGHT OUTER JOIN dbo.tbRMA_Header INNER JOIN dbo.tbRMA_Detail ON dbo.tbRMA_Header.rmah_id = dbo.tbRMA_Detail.rmah_id INNER JOIN dbo.tbRMA_Status ON dbo.tbRMA_Detail.rmas_id = dbo.tbRMA_Status.rmas_id INNER JOIN dbo.tbsysRMAProcType ON dbo.tbRMA_Detail.srpt_id = dbo.tbsysRMAProcType.srpt_id INNER JOIN dbo.tbItem ON dbo.tbRMA_Detail.item_id = dbo.tbItem.item_id ON dbo.tbItemTransactions.rmad_id = dbo.tbRMA_Detail.rmad_id AND dbo.tbItemTransactions.rmah_id = dbo.tbRMA_Header.rmah_id WHERE dbo.tbsysRMAProcType.srpt_id <> 1 AND DATEDIFF(DD, dbo.tbRMA_Header.rmah_cd, GETDATE()) <= 60 AND dbo.tbRMA_Header.cust_id = -1; SQLFIELDS4REPLACE:=§1§,§2§,§3§,§4§,§5§,§6§,§7§,§8§; ITEMSBYPAGE:=100; TEMPLATEPAGE:=MDITEMRMA; }}
Fecha ID Código Descripción Observación Serie Diagnóstico Comprobante
{{GBP_INSERTFOOTERSCRIPT}}