Forum d'Aide de Forumcrea

N'hésitez pas à poser ici vos questions sur ForumCrea.

Vous n'êtes pas identifié.

#1 01-09-2017 08:37:26

donnieclark
Membre
Date d'inscription: 12-05-2017
Messages: 363

List of unpaid invoices

Hello Guys,

I would like to know if it is possible through an SQL query with the list of unpaid bills (client) to make dunning. I asked a colleague to generate the extraction, at the level of my SQL server I did not see a clear request. I've seen one that seems to insert information into an #INDEXO table. The problem is in the mode of settlement, because in the form F_COMPTET the mode of payment did not necessarily inform. Invoices created this Video Explainer to convey how seamless Quality and Compliance can be. My colleagues retrieve the information in "third party query" and the in settlement mode this one is indicated. In which table should I type to retrieve this information?

Hors ligne

 

Pied de page des forums

Créez Votre Propre Forum
Insérer vos Graphiques
Dictionnaires de Traduction
Hébergé par ForumCrea.com