Re: 2.6.12 Post Upgrade Issues

Dieter Simader <[email protected]> Fri, 26 May 2006 16:09:46 -0600 (MDT)
Newsgroups gmane.comp.web.sql-ledger.user
Message-ID <[email protected]>
No reason to freak out.

Edit AA.pm

on line 853 add

  my %a = ();

change line 856 to

      if (not exists $a{$ref->{accno}}) {

on line 859 add

        $a{$ref->{accno}} = 1;

so the whole thing is like this

  $form->{taxaccounts} = "";
  my %a = ();
  while ($ref = $sth->fetchrow_hashref(NAME_lc)) {
    if ($tax{$ref->{accno}}) {
      if (not exists $a{$ref->{accno}}) {
        for (qw(rate description taxnumber)) { $form->{"$ref->{accno}_$_"}
= $ref->{$_} }
        $form->{taxaccounts} .= "$ref->{accno} ";
        $a{$ref->{accno}} = 1;
      }
    }
  }
  $sth->finish;
  chop $form->{taxaccounts};


Now enjoy your long weekend.

-- 
Dieter Simader    http://www.sql-ledger.com   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
============ On a clear disk you can seek forever ==========

On Fri, 26 May 2006, David Boyle wrote:

> I hate to be a pest, but this is freaking me out.  Fortunately it is a
> long weekend here in the States.  Maybe the following information will
> be somewhat helpful.  The problem described below seems to be
> triggered/occur when the Sales Order is open and we click on Sales
> Invoice to bill it.  When the screen refreshes to the Sales Invoice
> screen, taxes disappear.  Print and Post from there prints the invoice
> without taxes and digging in the GL shows that the tax accounts were
> indeed not affected.  Strangely enough, though, going into the
> transaction (AR-->Reports-->Transactions), the taxes are there and can
> be printed/e-mailed...but are still not hitting the GL.  Perhaps it
> would be possible to diff a copy of an earlier oe.pl (I think) and see
> if there is something missed or left opened (although I'd assume an
> error message would likely be displayed)?  Any thoughts or insight...or
> even directions on reverting back to prior version as worse case
> scenario would be appreciated.
>
> Thanks,
> David Boyle
> NAPCO
>
> On Fri, 2006-05-26 at 15:04 -0500, David Boyle wrote:
> > On Fri, 2006-05-26 at 15:02 -0500, David Boyle wrote:
> > > I moved from 2.6.4 to 2.6.12 and have experienced a strange tax issue.
> > > Everything tax wise has been working properly and even appears correct
> > > throughout sales order entry.  Can save the order and bring it back
> > > up...taxes still look fine.  However, when I do a sales invoice, print &
> > > post, taxes do not get printed and do not get posted to the GL.  Any
> > > ideas
> > >
> > > Thanks,
> > > David Boyle
> > > NAPCO
> >
> > Sorry...additionally, e-mailing an invoice displays the taxes as they
> > should be.
> > >
> > >
> > >
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> >
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> _______________________________________________
> sql-ledger-users mailing list
> sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



_______________________________________________
sql-ledger-users mailing list
sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users