Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex accounting report for 'As of' date
Message
 
 
À
20/01/2009 17:09:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01375665
Message ID:
01375786
Vues:
14
>Assuming that y'all are keeping Closed Dates and Open Dates on Accounts, it's easy to figure out what accounts were open on a specific date. An account is either open or closed.
>
>Somewhere there has to be code to handle each specific type. Find that code and reverse the operation. if addition, subtract; if subtraction, add

I applied the logic, but somehow one column doesn't match regardless on how we run the report. This one is a very complex report...
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform