Re: Please Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Joe

No offense taken ... and speaking only for myself, the learning curve to get
Access to do accounting stuff is quite a bit steeper than picking up a
QuickBooks, or a Peachtree or a Great Plains package.

For me, it comes down to the question of whether the tool is the best fit
for the job. By all means, congratulations on your successful use of Access
to help in your situation.

--
Regards

Jeff Boyce
<Office/Access MVP>

"Joe Cilinceon" <jfc@xxxxxxxxxxxx> wrote in message
news:uq8CaVJ3FHA.1596@xxxxxxxxxxxxxxxxxxxxxxx
> Jeff Boyce wrote:
> > Joe
> >
> > It sounds like you are trying to use Access to do accounting. If you
> > don't have a lot of time to devote to this effort, consider picking
> > up one of the off-the-shelf accounting packages...
> >
> > (and if this is a "labor of love", been there!)
> >
> > Regards
> >
> > Jeff Boyce
> > <Office/Access MVP>
>
> Actually Jeff I got what I was going for working now. I simply wanted a
> simple method to flag a payment record. Once the record is flagged I can
> then generate NSF letter, a note on the payment screen to not accept check
> from the tenant, roll back the paid thru date if applicable. All of this
is
> done at the time I pull up the transaction and simply change the payment
> method from a Check to a NSF Check. I also implemented it for credit cards
> that might be reversed though rare. I knew how to program it but I wasn't
> sure of how I wanted to implement a flag field for it and was asking for
> some fresh ideas. As it turned out I only added a single field for the
> RevDate to my payment table. Thanks for your response though, it is
> appreciated. g
>
> Now about the doing accounting with access. I almost stopped using these
> groups when I started this project back in Oct 2004. It seems every time I
> mentioned the word payments I got "the off-the-shelf accounting packages"
> pitch. Well after looking at the top 10 dedicated packages for the
> mini-storage business, I came to a couple of conclusions. The first being
> that 8 of the 10 are written in Access and of those all have the
accounting
> using standard Access features. I've been using my little project on line
in
> the real world now since Dec 2004 with no errors in accounting documented
to
> date (about 6000 transactions to date). I also might add that an of the
> shelf accounting package is a bit of over kill and will not handle many of
> the things we need in this business. Please realize that I don't mean to
> come across a jumping on you, I'm just a little curious as to why the off
> the shelf answer so much in these groups. g
>
> --
>
> Joe Cilinceon
>
>
>

.

Relevant Pages

  • Re: Help with criteria on select query
    ... Virtually any accounting system you will encounter for receivables is either ... open item or balance forward. ... set of invoices is definitely open item in nature. ... payment so that various amounts from that payment are "applied" against ...
    (microsoft.public.access.queries)
  • Re: Please Help
    ... It sounds like you are trying to use Access to do accounting. ... have a lot of time to devote to this effort, consider picking up one of the ... > payment as if it never happened for obvious reasons. ... In such a case I would like to flag just the check as the cash ...
    (microsoft.public.access.gettingstarted)
  • Re: Not again, good old eBay
    ... I felt stupidly forced to challenge that unfairness even though the challenge might have cost me a safe job. ... I imagine its an accounting thing. ... They have credited your account with the sum that was on it in order to set you back to zero and their payments software has flagged it as a payment and automatically sent a message thanking you for it. ... My dealings with Ebay have made me believe that they try to do almost everything through automated systems, hence the canned answers and lack of any specific answer almost any query you make of them. ...
    (uk.legal)
  • Re: double-entry bookkeeping unneeded?
    ... with $98 to interest and $2 to principle. ... that instead of a system where a group of transactions taken as a whole ... payment interest 98 ... details of a split just to satisfy an old accounting practice. ...
    (comp.object)
  • Re: Please Help
    ... Jeff Boyce wrote: ... > It sounds like you are trying to use Access to do accounting. ... simple method to flag a payment record. ... Joe Cilinceon ...
    (microsoft.public.access.gettingstarted)