![]() ( oInvetoryGenExit ) Salida de mercanciasĪ goods issuefrom Extended Warehouse Management (EWM) is a physical departure "TransType " = 59 - Entradas And "Warehouse " 'AMVEN ' - Mall Ventura OIGE - Salida de mercancias - Object type 60 "LineNum " - TOTALES ENTRADAS TIPO 59 Select Count( *) As Cantidad, "TransType " = 59 - Entradas -And "Warehouse" 'AMVEN' And "Warehouse " = 'AMVEN ' - Mall Ventura Order By C. "LineNum " Inner Join OACT CC - Cuentas contables ON D. "DocEntry " Inner Join OINM A - DIARIO DE ALMACENCES. A."Currency", -A."CalcPrice" As PRECIO_UNITARIO,įrom OIGN C - Cabecera Entrada de Mercancias Inner Join IGN1 D - lineas de la Entrada de mercancias ON C. Tabla de filas: IGN1 Entrada de mercancías.Transtype (object type):IGN 59 - Inventory General Entry.It is a goods movement that is used to post goods received from external Is the physical inbound movement of goods or materials into the warehouse. (oInvetoryGenEntry) Entrada de mercancíasĪ goods receipt in the Warehouse Management system (WMS) "DocDate " Between ' ' And ' ' OJDT -Entrada de Diario (Asiento contable) Object Type 30 OIGN - Entrada por movimientos - Object Type 59 "DocLineNum " - TOTALES COMPRAS TIPO 20 Select Count( *) As Cantidad, "DocDate " Between ' ' And ' ' Order By T0. T0."Currency", -T0."CalcPrice" as PRECIO_UNITARIO, T0."CardCode" As CODIGO_PROVEEDOR, -T0."CardName" As NOMBRE_PROVEEDOR, * Tabla de Filas: PDN1 Pedido de entrada de mercancías - FilasĬast(T0. * Transtype (object type): PDN 20 - Purchase Delivery Notes (oPurchaseDeliveryNotes) Entrada de mercancías por compras locales ![]() "TransType " = 14 - Notas de credito OPDN - Entrada de mercancias por compra - Object Type 20 "TransType " = 14 - Notas de credito Order By "U_NROAUTOR ", "NumAtCard " -TOTALES NOTAS DE CREDITO TIPO 14 Select Count( *) As Cantidad, "DocNum " as Varchar( 20)) As DOCNUM,įrom ORIN C - cabecera de la nota de credito (LV MALL) Inner Join RIN1 D - lineas de la nota de credito ON C. NOTAS DE CREDITO MALL VENTURA TIPO 14 SelectĬast(C. (oCreditNote) Nota de crédito de clientes (Anulacion de facturas) "TransType " = 13 - Facturas de venta del mall ventura ORIN - Notas de crédito MV Tipo 14 "DocDate " - TOTALES VENTAS MALL VENTURA TIPO 13 Select Count( *) As Cantidad, "TransType " = 13 - Facturas de venta del mall ventura Order By "U_NROAUTOR ", Cast( "NumAtCard " as int), C. A."Currency", -A."CalcPrice" as COSTO_UNITARIO,įrom OINV C - cabecera de la venta (LV MALL) Inner Join INV1 D - lineas de la venta ON C. SALIDAS POR VENTA MALL VENTURA TIPO 13 SelectĬast(C.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |