batman1056
Registered User.
- Local time
- Today, 14:28
- Joined
- Aug 23, 2004
- Messages
- 37
Hi, Firstly, Big Hi, just found this site and its great...and now I need some help.
I am creating a purchase order system and I am haveing major probs. the layout is as follows:-
I have about 9 projects, and each project mayhave up to 10 differnt sub sections i.e. Project 3, with heading like, salaries, marketing, adim. and these sections have a value allocated against them.
When you place a purcahse order you first choose which project you want to spend against , it will then give you the choice of the headings availale, after adding that item, you can select anther project on the same order and add that one too etc.. so int he end you haev a PO with lots of differnt cost centres from differnt projects. That bits done. the bit I haev problmes with is:-
I want to be able to add up each projects `bit` and allocate it agaisnt the value on that cost heading. so if Purchase Order No 20 had project 2 ( salaries £300, admin £500) and project 8 (salaires £200, marketing £900) I would like to be able to pull this info against the corrosponding cost heading.
so..
on my main project set up screen (called frm_projects with sub form subfrm_costheadings) the cost headings have a figue i.e. Project 2 -- Admin £3000, I want to add another coloum that says expenditure and it will have all the purchase orders I have created which are equal to Project 2 Admin added up, then I can create another text field with the remaining .
(eventually I`ll have it so I`ll have the following fields on the sub diredtory--
cost centre,value, po expenditure, actual expenditure, value remaining) what will happen is when I recieve an invoice I go back into the PO and tick a box that says invoice revieved, it will then remove the PO from the po expenditure and add it to the actual)
so I have two very confusing problems, any help really apprecaited.
I am creating a purchase order system and I am haveing major probs. the layout is as follows:-
I have about 9 projects, and each project mayhave up to 10 differnt sub sections i.e. Project 3, with heading like, salaries, marketing, adim. and these sections have a value allocated against them.
When you place a purcahse order you first choose which project you want to spend against , it will then give you the choice of the headings availale, after adding that item, you can select anther project on the same order and add that one too etc.. so int he end you haev a PO with lots of differnt cost centres from differnt projects. That bits done. the bit I haev problmes with is:-
I want to be able to add up each projects `bit` and allocate it agaisnt the value on that cost heading. so if Purchase Order No 20 had project 2 ( salaries £300, admin £500) and project 8 (salaires £200, marketing £900) I would like to be able to pull this info against the corrosponding cost heading.
so..
on my main project set up screen (called frm_projects with sub form subfrm_costheadings) the cost headings have a figue i.e. Project 2 -- Admin £3000, I want to add another coloum that says expenditure and it will have all the purchase orders I have created which are equal to Project 2 Admin added up, then I can create another text field with the remaining .
(eventually I`ll have it so I`ll have the following fields on the sub diredtory--
cost centre,value, po expenditure, actual expenditure, value remaining) what will happen is when I recieve an invoice I go back into the PO and tick a box that says invoice revieved, it will then remove the PO from the po expenditure and add it to the actual)
so I have two very confusing problems, any help really apprecaited.
