Invoice Retainage

R

Ruptured Duck

I am trying to create a payables program where I enter invoice information
and select to hold retainage or not. I have a query and report (payment
details) set up that I would run when I pay every two weeks that sums all
invoices with details and gives me a total to write the check for. This all
works great until I try to incorporate retainage into the mix. The need may
arise for me to hold 10% for two months and then release the retainage. On
the invoice table, I have a yes/no column that I check if retainage is to be
taken out of the invoice. This works great, even shows on the payment
details report mentioned earlier and I have it set up to deduct from the
total for the pay period.
My problem arises when I try to set up something that automatically pays the
retainage when it is due in two months. On my Payment Details report that I
mentioned earlier, I would like a :total amount-retainage held (which I
already have)+retainage released, which would give me a total amount to write
the check for.
I've not been able to set up one query that gives me all of the info because
an invoice that has had retainage held from it has been paid so should not
show on an unpaid invoices query which the Payment Details report pulls from.
So I have two queries that give me all of the info.
I can't seem to combine the queries to get what I need. A vendor might not
have any invoices paid but needs to be paid a retainage release. I could
write two series of checks every time, one for payments and retainage held,
and another for releases, but I'm trying to figure out a way to combine them
on the same report. If I combine the two reports, the items related to the
same vendors will not be combined. Please help.
 
L

litepaws

Why do you take those two queries and make a crosstab.. that would be alot
easier. You m,ay not get the full results under one report but your query
will pull the proper information. The report you would have to customize the
fields.... I wish I could send you a screen shot of how to merge two fields
into one using a formula and defaulting todays date or a time frame. with
omiting and adding in items using Criteria working it downwards. that way you
wont miss anything. I have used that many a times with using 6 to 7 queries
to get one bleepin answer.

Is there a way on here to do screen shots????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top