image004.png (2327 bytes)
General Ledger and Inventory Control
v09.02

Home Up FAQ Summary Changes Client / Server

 

Summary of the modifications made in the versions:

09.01 Version (27/08/2009) FINANCIAL STATEMENTS

Olds versions:

  1. 08.01 version (Access 2007 platform)
  2. 08.01.1 version
  3. 08.01.3 version    (10/23//2008)
  4. 08.02 version   (01/25/2009)
  5. 08.02.5 version (03/20/2009)
  6. 08.03 version (20/06/2009) Multi Company

 
  1. 07.10.1 Version
  2. 07.10.8 version    (10/23/2008)
  3. 07.11 version     (01/25/2009)
  4. 07.11.4 version (03/20/2009)
  5. 07.12 version (20/06/2009) Multi Company

Older Versions:

  1. 07.09 Version
  2. 07.09.2 Version
  3. 07.09.6 Version
  4. 07.09.9.4 version    (10/23/2008)
    5.

 

  1. 07.02.1 Version
  2. 07.02.2 Version
  3. 07.04.1 Version
  4. 07.04.2 Version
  5. 07.04.3 Version
  6. 07.04.4 Version
  7. 07.04.5 Version
  8. 07.04.6 Version
  9. New functions

Descriptions:

09.01 Version (27/08/2009)

  1. It was enabled the new module FINANCIAL STATEMENTS that make possible to the final users define and print the FINANCIAL STATEMENTS reports like:

BALANCE SHEET (*)

PROFIT AND LOSS STATEMENT (*)

FLOW OF FOUNDS (*)

STOCKHOLDERS’ EQUITY VARIATION

WORKING CAPITAL, ETC.
(*) Submitted predefined in order to help final user definitions.

<Back to beginning>

 

08.01 Version (Access 2007)  (07/30/2008)

  1. It was eliminated the annoying control Activex "Date and Time Picker" library "Microsoft Windows Control Commun-2 sp6" (MSCOMCT2.OCX) due to the new property of date box of Access 2007: DatePicker.
  2. It was enabled the ability to print receipts of Third Parties without crossing against Sales Invoices.
  3. It was defined a new function called: cgGRnd_Costo(ByVal locvlv) As Double, in order to define the number of significant decimals to be used in Costs fields: Decimals parameter defined in table Company + 4

<Back to beginning>

08.01.1  version (26/08/2008)

  1. It was fixed, to Access 2007 necessities, all Queries of ConGeneIros, including Queries for alternate language "Alt_Query..".

<Back to beginning>

08.01.3 version (24/10/2008)

  1. Enabling the option to manage the images: Product Pictures and Company Logo, using API - Application Programming Interfaces,  to avoid annoying problems of management with Microsoft OLE in some installations of Office suite.

<Back to beginning>

08.02 version (01/25/2009)

  1. Enabling the option to manage Amounts into Texts with the module: ConGeneIrosME.mde (or accde) useful for printed Sales Invoices and Cash Receipts. This module can be used with other applications without any cost.
  2. Enabling Automatic interface when print the Sales Invoice or Ticket, Purchase Voucher or Inventory voucher. This facilitates the process of integration between inventory control and General Ledger.
  3. The deduction code is extended to 5 characters for better documentation of sales invoices or sales ticket.
  4. Enabling the ability to print Accounting Balances separately from the Profit and Loss statements.
  5. They were separate in two databases, Modules and Programs (Forms and Reports), for the source versions (mdb and accdb), to facilitate the end user to develop their own functions.

     

<Back to beginning>

 

08.02.5 version (03/20/2009)

  1. Enabling the option to create Customer when you are reporting Sales Invoices.
  2. Enabling the option to create Supplier when you are reporting Purchases Invoices.
  3. Enabling the option to create Inventory Code when you are reporting Purchase invoices lines.

     

<Back to beginning>

08.03 version (20/06/2009)

  1. Enabling the option to create several companies and switch into them: Multi Company.

<Back to beginning>

-------------------------------

07.10.1 Version

  1. (19/10/2007) The database was divided into two databases for a typical installation Client / Server: See explanation in the section: Client / Server.
  2. (24/10/2007) Control of VAT Purchases is corrected for the case of Companies with VAT régime simplified where the VAT is part of the Cost of the Merchandise.

07.10.8 version (24/10/2008)

  1. Enabling the option to manage the images: Product Pictures and Company Logo, using API - Application Programming Interfaces,  to avoid annoying problems of management with Microsoft OLE in some installations of Office suite.

<Back to beginning>

07.11 version (01/25/2009)

  1. Enabling the option to manage Amounts into Texts with the module: ConGeneIrosME.mde (or accde) useful for printed Sales Invoices and Cash Receipts. This module can be used with other applications without any cost.
  2. Enabling Automatic interface when print the Sales Invoice or Ticket, Purchase Voucher or Inventory voucher. This facilitates the process of integration between inventory control and General Ledger.
  3. The deduction code is extended to 5 characters for better documentation of sales invoices or sales ticket.
  4. Enabling the ability to print Accounting Balances separately from the Profit and Loss statements.
  5. They were separate in two databases, Modules and Programs (Forms and Reports), for the source versions (mdb and accdb), to facilitate the end user to develop their own functions.

 

<Back to beginning>

 

07.11.4 version (03/20/2009)

  1. Enabling the option to create Customer when you are reporting Sales Invoices.
  2. Enabling the option to create Supplier when you are reporting Purchases Invoices.
  3. Enabling the option to create Inventory Code when you are reporting Purchase invoices lines.

     

<Back to beginning>

07.12 version (20/06/2009)

  1. Enabling the option to create several companies and switch into them: Multi Company.

<Back to beginning>

----------------------------------------

Older Versions:

07.09 Version

  1. (01/09/2007) New Order Entry Section.
  2. (01/09/2007) Audit Control Log.

<Back to beginning>

07.09.2 Version

  1. 01/10/2007) Two new ranges criteria's for issue the report Daily Summary Sales ([Diario de Ventas]): Dates and Periods.
  2. (05/10/2007) New fields (columns) are defined in the Table [Productos] and improvements of the form Products Inventory [Inventario Productos]:
    1. Maximum stock and Minimum stock: very useful to define Purchase Orders.
    2. Product Group: to classify the products according to user definitions in the new table [GrupoProductos].
    3. Product Image (Photo): in order to complement the product information in the new report Catalog of Products ([Productos_Catalogo]).
    4. Dimensions (1/2/3) y units 1/2/3: in order to complement the product description.
  3. (05/10/2007) Two new reports are defined and calling from the form [Inventario Productos]:
    1. Catalog of Products ([Productos_Catalago]).
    2. Price (Sale) List ([Productos_ListadePrecios]).

<Back to beginning>

07.09.6 Version

  1. (05/12/2007) It is enabled the alternate inventory code (CodInvProv). Useful for a Bar Code control for example.
  2. (05/12/2007) New Queries were included in the sections of General Ledger and Sales Invoices.

<Back to beginning>

07.09.9.4 version (24/10/2008)

  1. Enabling the option to manage the images: Product Pictures and Company Logo, using API - Application Programming Interfaces,  to avoid annoying problems of management with Microsoft OLE in some installations of Office suite.

<Back to beginning>

 

07.02.1 Version

(22/03/2007) they are added the action buttons [Comando0] and [Comando1] to the form [CgPanelControl] to call external applications (including other Databases) , based on definitions in the table [TitulosFormularios]. It is used for such an effect the field [TextoTag] of the record (Line) with NombreObjeto “CgPanelControl” and NombreCuadro the name of the respective button.

<Back to beginning>

Versión 07.02.2

(14/04/2007) they are added the action buttons [Comando2] and [Comando3] to the form [CgPanelControl] to call specific forms developed by the user based on definitions in the table [TitulosFormularios]. It applies for the version Source MDB only, the versions MDE calls external applications (because they don't allow to add forms or reports). It is used for such an effect the field [TextoTag] of the record (Line) with NombreObjeto “CgPanelControl” and NombreCuadro the name of the respective button.

(17/04/2007) the form [FactVtos] is corrected to add him the control of the parent form [FactTercerosVtas] in the event “Current”.

(17/04/2007) the Tax concept of Retention is added in the invoices

<Back to beginning>

 

07.04.1 Version

(14/06/2007) The Product description field is changed up to 250 characters and the respective reports.

(14/06/2007) The Country field is changed up to 50 characters in table [Terceros].

(21/06/2007) the following modifications are made for handling of purchases:

a.   Percentage discount is added by product (line) in detail purchases (form [LineasMovInv Subformulario2]).

b.   It is created the new form of Retentions for the maintenance of foot discounts of invoices in Purchases (form [TercerosCompras]).

c.   For the Companies with VAT simplified régime (it does not bill VAT) the VAT amount is added to the product cost.

(21/06/2007) The handling of the flag *Duplicated* is corrected in invoices and sale tickets reports, it is activated to only by form [Parameters InformesFac] requests.

(21/06/2007) The Key length field for search of thirds (Clvprov) is changed from 4 to 6 characters in table [productos].

(21/06/2007) Bypass the generation of physical inventory for the product code 0 (dummy for the handling of descriptions without associate code product in the invoices lines).

<Back to beginning>

 

V07.04.2

(30/06/2007) The size of the field TextoTag in table [TitulosFormularios] is change to type memo in order to be able to include redefinitions of SQL instructions (Queries).

(30/06/2007) the line number of the detail lines in invoices is calculated automatically.

<Back to beginning>

 

V 07.04.3

(10/07/2007) The Form [FactLineasMovInv Subformulario] (lines of detail of the invoices) is corrected to call the form [LineasMovInvDescr] (Lines without code inventory associate) when it occurs double click on the line or the inventory code and this it is the code 0 (dummy).

12/07/2007 It is implemented the new query: [ZZ_Consulta Saldos_Inventarios] for the analysis of balances and turnover of inventories using export tools to Excel.

<Back to beginning>

 

v 07.04.4

1. (16/07/2007) The main control panel form [CgPanelControl] is corrected to add the option of calling the panel control ParametrosINV from the subpanel of Sales Invoices.

(23/07/2007) These forms are corrected: [TercerosRetenciones], [TercerosRet Subformulario], [TercerosCompras] and [CompbteCompras] in order to calculate the retention base or discount when the company is VAT simplified régime (it doesn't bill VAT and the VAT goes at the costs of the inventory).

<Back to beginning>

 

V 07.04.5

(26/07/2007) The query [ZZ_Consulta Saldos_Inventarios] (Inventory balances) is corrected to add the rotation percent and the sales / costs department.

(04/08/2007) the user's (license owner) length is changed up in the corresponding reports.

<Back to beginning>

 

V 07.04.6

(10/08/2007) The Physical inventory report is corrected to manage closing date instead of date movement inventories, because they may be records without movement (in case of inventory code 0 (dummy).

<Back to beginning>

 

They are defined some new functions:

<Back to beginning>

Descripción

Nuevo nombre
To Convert Amounts into Texts: cgMTextenLetras(ByVal fnVlr As Double) As String

fnVlr = Amount to be converted into texts
             Support up to 15 digits
             with 2 decimals

Return an string with the amounts converted into words.
The form parameters has on line Help.
For use in other applications, you must add the reference of the module ConGeneIrosME.MDE (o ACCDE) in the Visual Basic section of Access.

 

To call the function cgUActTituloFormularioEtiqueta() from the form properties. This function is useful in source version (mdb or accdb) when the user define his own forms.

cgUAbrir_Formulario (frmN As String, Optional frmPpal As String)

 

Process the specific definitions contained in the Table  [TitulosFormulario] and the company Parameters.

FrmN = Form Name
FrmPpal = Main (Parent) form name (in case of sub forms)

To call the function cgUActTituloCuadroEtiqueta() from the report properties. This function is useful in source version (mdb or accdb) when the user define his own reports

 

cgUAbrir_Informe (frmN As String, Optional frmPpal As String)

 

Processs the specific definitions contained in the Table [TitulosInformes] and the company Parameters..

Frm = report name
FrmPpal = Parent report name (in case of sub reports)

Sub to create predefined Queries of ConGeneIros calling the function: cgQCrea_ConsultaEsp(locName, locSQL)

cgQCrea_ZZ_Consultas()

To create an specific Query

cgQCrea_ConsultaEsp(locName As String, locSQL As String)

locName = Query Name
locSQL = String with the SQL sentences

Sub To delete the specifics queries of ConGeneIros

cgQBorra_Consultas()

To delete an specific Query:

cgQBorra_ConsultaEsp(locName As String)

LocName = Query name
   

Para calcular totales retenciones. Esta función es útil para las versiones MDB en que el usuario define sus propios formularios o informes.

cgUSumaTotRetenciones(ByVal cl As String, ByVal cp As Long,
Optional ByVal pr As String = "*", Optional ByVal fp As String = "*",
Optional bsr) As Double

Cl = Clase Movimiento
Cp = Comprobante
Pr = Tercero (ClvProv)
Fp = Factura terceros
bsr = Suma Bases de la Retención

Para calcular numero línea disponible en movimiento inventarios

cgULineaDisponibleInv(ByVal cl As String, ByVal cp As Long, ByVal pr As String, ByVal fp As String) As Long

Cl = Clase Movimiento
Cp = Comprobante
Pr = Tercero (ClvProv)
Fp = Factura tercero

Para mostrar el cuadro de dialogo para Buscar/seleccionar un archivo y devuelvar la ruta completa (absoluta) con el nombre del archivo (max. 255 caracteres)

 cgBOpenCommDlg()

Para convertir una dirección relativa respecto a la ubicación de la Base de Datos del Host (que es la que generalmente se guarda en las tablas) en dirección absoluta.

 cgBCalculeDir(ByVal DirFoto)
Calcula el costo unitario promedio de un producto y devuelve las existencias. cgVCostoUn_Prom(ByVal meCodinv As Long, locexist As Long) As Double

meCodinv = Codigo de inventario
loce = existencias actuales
Determina condición de venta para contados cgVCondContado() As String
Determina Tipo de transacción contable para un movimiento de facturación cgVClaseMv_Tipotr(locClaseMv As String) As String

locClaseMv = Clase Movimiento inventarios
Devuelve Verdadero si la factura tiene vencimientos (cuotas) cgVHayVtos(locFacturaP As String) As Integer
Devuelve Verdadero si un comprobante contable tiene líneas de detalle cgUEsCompbteConLineasCG(mitipotr As String, micompbte As Long) As Integer

mitipotr = Tipo Trasnaccion Contable
micompbte = número de comprobante
Devuelve Verdadero si un comprobante de Inventarios tiene líneas de detalle cgUEsCompbteConLineas(miclasemv As String, micompbte As Long) As Integer

miclasemv = Clase Movimiento Inventarios
micompbte = número de comprobante
(V08.nn) Devuelve cierto si la clase de movimiento de inventarios es de Ventas cgVEsClMv_Ventas(locClaseMv As String) As Boolean
(V08.nn) Devuelve cierto si la clase de movimiento de inventarios es de Compras cgUEsClMv_Compras(locClaseMv As String) As Boolean
Devuelve línea disponible para Movimiento Contable cgULineaDisponibleCompr(ByVal cl As String, ByVal cp As Long) As Long

cl = Tipo Transacción
cp = Numero comprobante
Graba una linea en el archivo de Logs de auditoria cgUGrabaLogAuditoria(locname As String, loctipo As Long)

locname = nombre del objeto utilizado
loctipo = Tipo objeto (1/Form, 2/Report)
Redondea valores (caso costos) con cifras decimales cgGRnd_Costo(ByVal locvlv) As Double

<Back to beginning>

 
 

Summary Changes

    

 

Commercial Representative
 Liliana C. Castellanos (USA / Canada) 
Jorge Combeau (Latin America)

Contact us
 Information ConGeneIros
Copyright José Tomás Castellanos Caro