K
klat7292
I have created a workbook template where I have a 'master' page for an Order
Acknowledgment/Confirmation for a Purchase Order for items that are purchased
from one vendor and are waiting to be received. On separate sheets, I have
created a similar template to receive the items purchased on multiple
Purchase Orders for that one original Purchase Order due to backorders. This
is simply for tracking everything on the Original Purchase to insure that all
inventory is accounted for without all the confusion and paper trail. What I
am wanting to do is have a running total of backordered items for each item
ordered on the mater page as new purchase orders for backorderes are entered
for that particular Original Purchase Order.
If someone could let me know how this is done, I would greatly appreciate it
and it would save me a lot of HEADACHE!! I think that I am on the right track
and I am close-if all else fails, I could always enter the info manually, but
I think that might open the door for more error...I know that it can be done!!
Thanks in advance for the answer!!
Acknowledgment/Confirmation for a Purchase Order for items that are purchased
from one vendor and are waiting to be received. On separate sheets, I have
created a similar template to receive the items purchased on multiple
Purchase Orders for that one original Purchase Order due to backorders. This
is simply for tracking everything on the Original Purchase to insure that all
inventory is accounted for without all the confusion and paper trail. What I
am wanting to do is have a running total of backordered items for each item
ordered on the mater page as new purchase orders for backorderes are entered
for that particular Original Purchase Order.
If someone could let me know how this is done, I would greatly appreciate it
and it would save me a lot of HEADACHE!! I think that I am on the right track
and I am close-if all else fails, I could always enter the info manually, but
I think that might open the door for more error...I know that it can be done!!
Thanks in advance for the answer!!