Prototipo de Aplicación Móvil para el control de cuentas por cobrar integrado con SQL Anywhere para la empresa Faccsystem SA.
Fecha
2022-03
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad de Guayaquil. Facultad de Ciencias Matemáticas y Físicas. Carrera de Ingeniería en Sistemas Computacionales.
Resumen
RESUMEN El proyecto que se está presentando describe el diseño de un prototipo de aplicación móvil para el control de cuentas por cobrar integrado con SQL Anywhere, que mediante Xamarin como lenguaje de programación y un dispositivo móvil, permite ingresar, procesar y consultar los pagos de los clientes en tiempo real, además, tiene un módulo de reportes que permite saber los estados de los clientes con su respectivo historial de cartera; de esta manera se logra optimizar el proceso al realizar las cobranzas a través del dispositivo móvil por la app. Referente al software utilizado tendremos una aplicación móvil que se utiliza como IDE el Visual Studio Community. Con respecto a la base de datos que vamos a utilizar en el proyecto, se emplea el sistema de gestión de base de datos SQL Anywhere 17 donde crearemos las Apis que entregaran formato J-SON que permite extraer la información de la base de datos hacia la aplicación móvil, la misma que mediante una IP publica realizando un port forwarding permite tener acceso a la información mediante el internet permitiendo a los diversos usuarios receptar datos en tiempo real desde cualquier lugar sin tener la necesidad de estar en el mismo segmento de la base de datos. La interfaz que se utilizara es una interfaz para los dispositivos móviles, la cual apunta a la base de datos interpretando la información para generar los recibos y los reportes. Con este prototipo, se busca la optimización, seguridad, efectividad y eficiencia del proceso de cuentas por cobrar para la empresa Faccsystem SA.
The project that is being presented describes the design of a mobile application prototype for the control of accounts receivable integrated with SQL Anywhere, which, using Xamarin as a programming language and a mobile device, allows entering, processing, consulting customer payments In real time, it also has a reporting module that allows us to know the status of the clients, with their respective portfolio history, in this way we manage to optimize the process when making collections through the mobile device through the app. Regarding the software used, we will have a mobile application that we use as IDE the Visual Studio Community. Regarding the database that we are going to use in the project, the SQL Anywhere 17 database management system is used where we will create the APIs that will deliver J-SON format that allows us to extract the information from the database to the mobile application, which through a public IP carrying out port forwarding allows us to access information through the internet allowing various users to receive data in real time from anywhere without having to be in the same segment of the database data . The interface that will be used is an interface for mobile devices, which points to the database interpreting the information to generate receipts and reports. With this prototype, the optimization, safety, effectiveness, and efficiency of the accounts receivable process for the company Faccsystem SA is sought.
The project that is being presented describes the design of a mobile application prototype for the control of accounts receivable integrated with SQL Anywhere, which, using Xamarin as a programming language and a mobile device, allows entering, processing, consulting customer payments In real time, it also has a reporting module that allows us to know the status of the clients, with their respective portfolio history, in this way we manage to optimize the process when making collections through the mobile device through the app. Regarding the software used, we will have a mobile application that we use as IDE the Visual Studio Community. Regarding the database that we are going to use in the project, the SQL Anywhere 17 database management system is used where we will create the APIs that will deliver J-SON format that allows us to extract the information from the database to the mobile application, which through a public IP carrying out port forwarding allows us to access information through the internet allowing various users to receive data in real time from anywhere without having to be in the same segment of the database data . The interface that will be used is an interface for mobile devices, which points to the database interpreting the information to generate receipts and reports. With this prototype, the optimization, safety, effectiveness, and efficiency of the accounts receivable process for the company Faccsystem SA is sought.
Descripción
PDF
Palabras clave
Aplicación Móvil, Portabilidad, Interfaz, Cuentas por cobrar, Base de datos, Mobile application, Portability, Interface, Accounts receivable, Database