Question Accounts Receivable

[waredata]

Basically I have two major tables: Customers info & data
I'm trying to create statements base on the data per month.

Statement would have Beg Total (prior month ending total), current month charges - payments + taxes = Ending Total

I use a ([BegDate]And[EndDate] on [Date Posted])to show current month activities.
However if there is no charges between thoes dates on any customers accounts, but have a outstanding balance. My report won't print out a statement. Only those with activities during the current month.

Query: BegTotal i uses <1[BegDate]
Current charges for the month
Any payment made during the month
Taxes posted for the month
Ending Total.
I really am lost.. I need to run all customers statements.

I know I am a newbe, just any suggestion

 

[gemma-the-husky]

the truth

as a beginner, i would not try and build any standard accounts package

ie receivable, payable, or nominal/general ledger

if you know what you are doing, then its 2-3 days each for something useful

if you don't know what you are doing, it will be a complete struggle, and you may as well buy a cheap accounting package.


-----------
sorry - i doubt if its what you wanted to hear.

 

[waredata]

I am not that much of a newbe, I have been working with database since db1, I'm just a user/basic.. Never had a chance to learn programming such as VBA.

Thanks, anyway

 

[gemma-the-husky]

you see, your tables and field names sound a bit .. random.

if the data isn't set up correctly it makes everything hard to do.

-----

you probably want a query to find all the accounts with opening balances
and another to find all the ones with transactions this month

union them together to find all the ones you need to do statements for.

that's a start - but there are likely to be other ways to achieve this.

 

[MarkK]

...and maybe a left or right join in a query would help. Right click on a relationship line in a query in the design grid, select 'Join Properties' and you can include all records from a particular table. This way you can force a parent record to appear even it has no child records.
Cheers,
Mark