Acnts Rec - Accounts Receivable in Microsoft Access


	Back to Accounts Receivable Comments List

Upload Images Link Email

Acnts Rec

Jeffrey Kraft

8 months ago

How much more difficult would it be to have the Aged Accounts Receivable Report do the Current, 30, 60, 90, Call the Collection company now by Customer rather than by Order. I've done similar but I can't remember how to do that.

Right now I'm seeing a lot of queries (in my head). One with Customers with unpaid invoices. One for current. One for 30 Days. And to keep this short the > 30 days.

	Richard Rost 8 months ago
I'm pretty sure that's what I show in the Extended Cut.

Jeffrey Kraft OP

8 months ago

The extended cut gets close.... except it was by Transaction. In the Extended Cut you had 2 entries for Richard Rost and OrderId 1 for 56 and Current and OrderID 3 for 1123. Also Current. What I would have wanted was 1 Row form Richard Rost Current 1179.00. What got me in trouble and unable to think Query and query design was watching 2 hours? of One to Many Queries and brain had turned to mush. And no I haven't solved my problem 100 percent.

	Richard Rost 8 months ago
You should be able to just aggregate the data together, then if that's what you want. If not, show me a sample of what you're trying to do. Maybe mock up some Excel sheets or something so I can see it. It's easier to understand if I can visually see it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Accounts Receivable.