In the "Finance Manager" DB you requested my input and I would like to see a Purchase Order capability that would include a listing of various vendor's, their products (Name, Prod. Number, Cost, Qty. Ordered, Qty. Received, Subtotal, Variable Tax Rate, Total, etc.) and then be able to link it to a vendor's invoice that would not only have all the pertinent information about the vendor, but would have an editable list of outstanding (undelivered, back-ordered)items that could be assigned to a later invoice. This PO should have a means to link the items ordered to a current or future project, along with just general usage/expendable items. A report of materials /items used per project along with either estimated or actual man-hours for the project, travel expenses, Per-Diem, etc. Any tangible expenses that would need to be added to give an accurate profit-loss report for the project, the month & the year. finally, all these items and expenses could be detailed or over viewed in a company invoice to the customer.
One other function I would like to see is comprehensive means to provide a customer an estimate / proposal. The data for the proposal could come from either a listing of in house manufactured items, vendor's items, general usage items, expense lists and/or random input amounts.
Thanks
Dale
Reply from Richard Rost:
I cover purchase orders in Access 328, but I don't cover the financial end of it - processing the vendor's invoice - just the "receiving parts" end of it. Perhaps I could add that in.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.