J
Jacques
Hi all
If this exact question has been asked, I apologise.
I have a database based on purchase orders. Its still in its infancy.
I need to implement a tracking system of sorts at some point.
How iI would like it to work:
A purchase order will be generated, then sent for authorisation, then
received back, sent electronically to supplier, and finally monitored by
follow-ups to the delivery status.
Unfortunately, due to the order requiring manual signatures, there can be
large time lapses between date of issuing and the date of authorisation of
purchase. Sometime 3 - 4 days, depending when the bosses are available.
For this reason a user will have to capture the delivery date manually,
counting down from the date of actual submittal to supplier and not from date
of P.O. generation.
I would like to set up a query that would flag and list all orders that are
due, BUT two days before actual due date. The user should be able to log on,
run the query and see the priority listing. He / she can then follow up and
ensure timely delivery.
I also need a query that flags deliveries that are overdue (based on date of
delivery) and which not yet marked as delivered complete (this is done by
means of a yes/no)
My fields are:
Purch_ord_num
Date_RDA_creat
Date_RDA_receiv
Date_RDA_Genr
Date_PO_Issued
Exp_del_date
Complete
Date_del_compl
Comment
There are a few other columns, but not relevant to the question. Most of the
info will be automatically drawn from the purchase order and other parts of
the database and placed on the status report table at the time of P.O.
creation. The only thing to be manually entered is the Delivery date and
Issue date. And only once that is done, should the query include the relevant
line item and start counting down from THAT date.
Any help and / or recommendations will be appreciated
If this exact question has been asked, I apologise.
I have a database based on purchase orders. Its still in its infancy.
I need to implement a tracking system of sorts at some point.
How iI would like it to work:
A purchase order will be generated, then sent for authorisation, then
received back, sent electronically to supplier, and finally monitored by
follow-ups to the delivery status.
Unfortunately, due to the order requiring manual signatures, there can be
large time lapses between date of issuing and the date of authorisation of
purchase. Sometime 3 - 4 days, depending when the bosses are available.
For this reason a user will have to capture the delivery date manually,
counting down from the date of actual submittal to supplier and not from date
of P.O. generation.
I would like to set up a query that would flag and list all orders that are
due, BUT two days before actual due date. The user should be able to log on,
run the query and see the priority listing. He / she can then follow up and
ensure timely delivery.
I also need a query that flags deliveries that are overdue (based on date of
delivery) and which not yet marked as delivered complete (this is done by
means of a yes/no)
My fields are:
Purch_ord_num
Date_RDA_creat
Date_RDA_receiv
Date_RDA_Genr
Date_PO_Issued
Exp_del_date
Complete
Date_del_compl
Comment
There are a few other columns, but not relevant to the question. Most of the
info will be automatically drawn from the purchase order and other parts of
the database and placed on the status report table at the time of P.O.
creation. The only thing to be manually entered is the Delivery date and
Issue date. And only once that is done, should the query include the relevant
line item and start counting down from THAT date.
Any help and / or recommendations will be appreciated