Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

account payable access templete

Posted on 2012-04-12
7
Medium Priority
?
1,134 Views
Last Modified: 2012-11-05
Is there a database template out there that will show me Purchase Order
details and track the invoices and payments until the PO is spent? I would
like the capability to indicate alterations to the PO amount. I am hoping to
find a template.
0
Comment
Question by:mmously
  • 3
  • 2
6 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 375 total points
ID: 37837186
mmously,
you can not find a template tailored fit for your requirement.

see this link

http://office.microsoft.com/en-us/templates/CT010142603.aspx?av=ZAC

* Order management, time and billing, expense etc...

hth
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 1125 total points
ID: 37837650
Also note that this functionality is available in most off-the-shelf Purchase order software packages.
With an off-the-shelf  there is no development time, there is full support, many are web based.

In other words, with many of these packages being less than 500USD, ...
Why re-invent the wheel here?

I can post a simple "PO payments reconcile" db later if you like...
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 1125 total points
ID: 37838357
See this basic sample for how to reconcile multiple payments against a PO balance due amount
Access-Basic-CalculateOrdersPaym.mdb
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:mmously
ID: 38566402
I've requested that this question be deleted for the following reason:

ignored the requested data
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1125 total points
ID: 38566403
Both Experts posts were applicable to your question.
1. Capricorn1 posted a link to the Access templates database site and you would have found this
This would satisfy your requirement of needing a "template"

2. I posted a functioning sample database illustrating how to: "track the invoices and payments until the PO is spent".

So I am confused as to why you are wanting to close this question after 6 months without replying to these applicable posts?

JeffCoachman
0
 

Author Closing Comment

by:mmously
ID: 38567186
thanks for your feeds
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Implementing simple internal controls in the Microsoft Access application.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question