{"id":7428,"date":"2020-01-03T21:12:37","date_gmt":"2020-01-04T00:12:37","guid":{"rendered":"https:\/\/www.alfagestion.com.ar\/ag\/?p=7428"},"modified":"2020-01-04T06:58:49","modified_gmt":"2020-01-04T09:58:49","slug":"enviar-tabla-nutricional-a-balanza-kretz","status":"publish","type":"post","link":"https:\/\/www.alfagestion.com.ar\/ag\/enviar-tabla-nutricional-a-balanza-kretz\/","title":{"rendered":"Enviar tabla nutricional a balanza Kretz"},"content":{"rendered":"

La tabla nutricional, se carga en el campo observaciones del Sistema Alfa, para importarlo al software Itegra, debe cargar la siguiente consulta SQL en la opci\u00f3n “Importar”, desde base de datos.<\/p>\n

 <\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>1<\/span>,<\/span>OBSERVACIONES<\/span>)<\/span>
\nAS<\/span> OBS,<\/span>'1'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>2<\/span>,<\/span>OBSERVACIONES<\/span>)<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'2'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>3<\/span>,<\/span>OBSERVACIONES<\/span>)<\/span>
\nAS<\/span> OBS,<\/span>'3'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>4<\/span>,<\/span>OBSERVACIONES<\/span>)\u00a0<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'4'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>5<\/span>,<\/span>OBSERVACIONES<\/span>)\u00a0\u00a0<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'5'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>6<\/span>,<\/span>OBSERVACIONES<\/span>)\u00a0<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'6'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>7<\/span>,<\/span>OBSERVACIONES<\/span>)\u00a0<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'7'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>8<\/span>,<\/span>OBSERVACIONES<\/span>)\u00a0<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'8'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>9<\/span>,<\/span>OBSERVACIONES<\/span>)\u00a0<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'9'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1
\n<\/span><\/code><\/span><\/p>\n

UNION
\n<\/span><\/code><\/span><\/p>\n

SELECT\u00a0<\/span>LTRIM(<\/span>IDARTICULO)\u00a0<\/span>AS<\/span> IDARTICULO,\u00a0<\/span><\/span><\/span><\/span>DBO<\/span>.<\/span>FN_EXTRAERENGLON<\/span>(<\/span>10<\/span>,<\/span>OBSERVACIONES<\/span>)<\/span>
\nAS<\/span> OBS,\u00a0<\/span>'10'\u00a0<\/span>AS<\/span> RENG
\n<\/span><\/span><\/code><\/p>\n

FROM<\/span> V_MA_ARTICULOS WHERE<\/span> PESABLE =<\/span> 1<\/code>
\n<\/span><\/p>\n

Adjunto imagen.<\/p>\n

\"\"<\/p>\n

Esto se debe, a que el software itegra toma como texto fijo renglones de 50 caracteres.<\/p>\n

Previo a esto, tambi\u00e9n debe importarse los art\u00edculos, asociando el rengl\u00f3n al mismo c\u00f3digo de articulo.<\/p>\n

Compartir:<\/h3>