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.
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.