Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex accounting report for 'As of' date
Message
From
20/01/2009 16:26:25
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01375665
Message ID:
01375672
Views:
25
This message has been marked as a message which has helped to the initial question of the thread.
I'm assuming you want balances for the 'As of' date? Payments would be added back in, Credits would be subtracted out. Not sure what you mean by allowances, but basically you'd want to reverse the sign.


>Hi everybody,
>
>Just wondering if you ever done an accounting report to show data for "as of" date? I can get payments and allowances before and after the As of date without a problem, but figuring out where to subtract and where to add seems like a very tricky stuff...
>
>Thanks in advance.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform