Plan De Cuentas Contables Venezuela Excel Vba -

Este documento presenta un plan de cuentas adaptado a la VEN-NIF PYME (Venezuela). El plan de cuentas está estructurado en clases, Scribd

In the world of Venezuelan finance, where hyperinflation and shifting regulations make every decimal point a battle, a young accountant named faced a daunting task: managing a massive Plan de Cuentas plan de cuentas contables venezuela excel vba

If ValidarCuenta(codigoDebito) And ValidarCuenta(codigoCredito) Then Sheets("Transacciones").Cells(Sheets("Transacciones").Rows.Count, 1).End(xlUp).Offset(1, 0).Value = _ Array(Date, "C-001", codigoDebito, monto, 0, "Asiento VBA") Sheets("Transacciones").Cells(Sheets("Transacciones").Rows.Count, 1).End(xlUp).Offset(1, 0).Value = _ Array(Date, "C-001", codigoCredito, 0, monto, "Asiento VBA") MsgBox "Asiento registrado correctamente" Else MsgBox "Error: Cuenta no válida" End If Este documento presenta un plan de cuentas adaptado

Sub GenerarCodigoAutomatico() Dim rngPadre As Range Dim codPadre As String Dim nivelPadre As Integer Dim nuevoNivel As Integer Dim nuevoCodigo As String Dim ultimoHijo As String Dim ws As Worksheet Dim ultimaFila As Long Dim i As Long Dim maxHijo As Long Set ws = ThisWorkbook.Sheets("Maestro_Cuentas") On Error Resume Next Set rngPadre = Application.InputBox("Selecciona la celda del código padre", Type:=8) On Error GoTo 0 0).Value = _ Array(Date

' Step 2: Scrub the raw ERP dump Dim rawData As Range, r As Range Set rawData = Sheets("ERP_Export").UsedRange