Purchase Orders Starter Solution
I started the PO from the starter solution to keep track of the POs we send out for product. A bit of 'history' if you will: The PO starter solution is actually used for material requests, I changed a few things, RO# as it is MY request for materials #. When it is approved and I receive the PO, I enter the number of the PO. I have a drop down field 'fund'. I made a value list of the 'funds' we use to purchase said materials. I keep a running excel spreadsheet on the side with the budget balances. There are 4 balances for 4 departments that I keep track of.
I have (in excel) fomula's for discount cost, final cost (discount cost + S&H) Balance (final cost - the above cell) What I need, IF I can understand what you send me.... is a way that when the total on the PO in congunction with the fund, will subtract from the 'balance' and give me a new balance for that budget.
1. I know it is possible
2. In reading my delima, am I too much of a newbie to understand and to DO what is required?