logo dolibarr Dolibarr   En los informes no aparecen las facturas marcadas como pagadas

I've noticed that reports of Expenses-Income They generated from Dolibarr (Financial> Reports) Bills that have marked as "do not appearpaid". These bills are characterized by having no record of payment on our bank account. But is it logical that do not appear ?. In my case, I sign many bills as "paid"To simplify the registration process Dolibarr because I do not have an exhaustive control of the movement of my account because that account I have many personal movements that are alien to the movements of my company. For that reason, I do not do often action "payment issue"And use the option"classified as paid"Because I facilitates the task.

Clarified the concept, for those who are in my situation, I leave what I have modified to show me all the moves we have with suppliers. This does not affect customer invoices, since in these Dolibarr always forces you to "payment issue“.

The following modifications have tested the Dolibarr 3.6.

We need to modify the following files:

  • htdocsdolibarrcomptaresultatindex.php
  • htdocsdolibarrcomptaresultatclientfourn.php

At index.php modified as follows:

For invoices from suppliers, we seek the block is commented as "Frais, fournisseurs factures."And we modify the ELSE follows:

$sql = "SELECT sum(f.total_ttc) as amount_ttc, date_format(f.datef,'%Y-%m') as dm";
$sql.= " FROM ".MAIN_DB_PREFIX."facture_fourn as f";
$sql.= " WHERE f.rowid > 0";

At clientfourn.php modified as follows:

For invoices from suppliers, we seek the block is commented as "suppliers invoices"And we modify the ELSE follows:

$sql = "SELECT s.nom, s.rowid as socid, sum(f.total_ttc) as amount_ttc";
$sql.= " FROM ".MAIN_DB_PREFIX."facture_fourn as f";
$sql.= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s";
$sql.= " ON f.fk_soc = s.rowid";
$sql.= " WHERE f.rowid > 0 ";
if (! empty($date_start) && ! empty($date_end))
$sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'";

In both queries, we have used:

  • total_ttc: Because the amount is zero field
  • Datef: As invoice date in the absence of payment as such

Now you can view the report Expenses / Income completely.

Keep updated your ERP / CRM Dolibarr

logo dolibarr Dolibarr   En los informes no aparecen las facturas marcadas como pagadas

 

  • Upgrade your Dolibarr without complications or risks to the latest version.
  • Keep your data safe. I perform backup before performing the process.
  • all information is migrated without losing anything.
  • Escríbeme y te daré presupuesto personalizado sin compromiso pulsando el siguiente botón:

Quiero saber más sobre cómo Actualizar Dolibarr

 

Dime qué te ha parecido el artículo...

rating off Dolibarr   En los informes no aparecen las facturas marcadas como pagadasrating off Dolibarr   En los informes no aparecen las facturas marcadas como pagadasrating off Dolibarr   En los informes no aparecen las facturas marcadas como pagadasrating off Dolibarr   En los informes no aparecen las facturas marcadas como pagadasrating off Dolibarr   En los informes no aparecen las facturas marcadas como pagadas (Ninguna valoración todavía)
loading Dolibarr   En los informes no aparecen las facturas marcadas como pagadasCargando…
Advertisements

Use of cookies

This site uses cookies for you to have the best user experience. If you continue to browse you are giving your consent to the acceptance of the above cookies and acceptance of our cookies policy, Click the link for more information.

OK
Notice of cookies

Veo que te gusta mi Blog...

Si te ha parecido interesante este artículo, no esperes a suscribirte a mi blog. Cuando vuelva a escribir otro seguro que te interesará y no desearás no haberte enterado. Puedes suscribirte con total tranquilidad de que no recibirás spam. Lo odio igual que tu. Solo quiero que aprendas cosas nuevas y te sientas agusto con mis artículos. ¡Gracias!

Thank you for subscribing!

Pin it on Pinterest

Share This

Share

Share this with your friends!