Invoices fail to load

[Bernardo Romero]

 Well, I checked the entries table and the good news is that for bills the
entries are still there, however, they're gone for most of the invoices. In
fact, there are only entries for two of the existing invoices. What could
have happened? For the sake of better explaining my setup, I have created
three views and one routine on top of the existing database structure. I
use them to create transactions lists in a format that allows for external
analysis with Excel or any other tool. None of those views touch either the
entries or invoices tables.




2011/11/10 Geert Janssens <janssens-geert at telenet.be>

> On donderdag 10 november 2011, Bernardo Romero wrote:
> > Thanks Geert,
> > Yes, in the database I have the table called "invoices" and it's
> populated
> > with some 60+ records. I can see as well that all tose foreign keys such
> as
> > post_txn, post_lot and post_ acc are populated.
> >
> Bernardo,
>
> That's the invoices table. Your original mail said your were missing the
> entries on your invoices. Those are stored in the entries table.
>
> Check if you have entries with an invoice guid matching one of your problem
> invoices.
>
> Geert
>



-- 

Cordialmente,



Bernardo Romero C.

*Socio Gerente*

*Scalaria - Consultores de Negocios*

(57) 317 331 5203

bromero at scalaria.co

www.scalaria.co



Considere su responsabilidad ambiental antes de imprimir este correo
electrónico.

Scalaria: comprometida con el medio ambiente