[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Ugh...deleting a Vendor Invoice



You are not connected to the right database ;-) The prompt below
suggests you omitted the dbname and connected to the "postgres"
database.

psql -U postgres [dbname]

Best Wishes,
Chris Travers

On 3/15/07, Matt Jackson <..hidden..> wrote:
Chris,

Tried it and got:

postgres=# UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
ERROR:  relation "defaults" does not exist

Any idea why?

- Matt



On 3/15/07, Chris Travers <..hidden..> wrote:
>
> In 1.2.0rc4, the problem does not appear to occur.  It may be a but
> with saving the appropriate setting (this part of the software got
> some serious work done on it in 1.2).  If you are using the debian
> package, we expect to have an rc4 package available soon. otherwise,
> you can upgrade and see if the problem goes away.
>
> Otherwise you may try (in psql):
> UPDATE defaults SET value = '0' WHERE setting_key = 'revtrans';
>
> Best Wishes,
> Chris Travers
>
>
> On 3/15/07, Matt Jackson <..hidden..> wrote:
> > Will be interested to see what you find. Everything else seems to work
fine.
> > So frustrating not being able to delete an invoice lol, especially for
> > someone learning. :)
> >
> > Thanks!!
> >
> > - Matt
> >
> >
> >
> >
> >  On 3/15/07, Chris Travers <..hidden..> wrote:
> > >
> > > Ok, testing in 1.2.0rc4
> > >
> > > On 3/15/07, Matt Jackson <..hidden..> wrote:
> > > > Chris,
> > > >
> > > > I am running
> > > > Version 1.2.0 Release Candidate 1
> > > >
> > > > Thanks,
> > > > Matt
> > > >
> > > >
> > > >
> > > > On 3/15/07, Chris Travers < ..hidden..> wrote:
> > > > > Hi Matt;
> > > > > Which version are you running?
> > > > >
> > > > > Best Wishes,
> > > > > Chris Travers
> > > > >
> > > > > On 3/15/07, Matt Jackson <..hidden..> wrote:
> > > > > > Hmmm!
> > > > > >
> > > > > > When I try to set "Enforce Transaction Reversals for all dates"
to
> > "No,"
> > > > it
> > > > > > just pops back to Yes when I check it again...it doesn't stay
set!
> > > > However,
> > > > > > when I switch Activate Audit Trail to Yes or No, those stick!
> > > > > >
> > > > > > lol...that seems to be my problem...any idea on how to fix that?
> > > > > >
> > > > > > - Matt
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 3/15/07, Ashley J Gittins <
> > > > > > ..hidden..> wrote:
> > > > > > > On Thu, 15 Mar 2007, Matt Jackson wrote:
> > > > > > > > All I see on my buttons is "Post as New" which then
duplicates
> > it
> > > > > > modified
> > > > > > > > in the system.
> > > > > > > >
> > > > > > > > Any ideas?
> > > > > > >
> > > > > > > Hi Matt,
> > > > > > >         If you have reversal enforced (system menu I think)
then
> > there
> > > > > > will be
> > > > > > > a "delete" button at the bottom.
> > > > > > >
> > > > > > > To do a reversal, open the original invoice, change the qty's
and
> > > > invoice
> > > > > > > number as described, update (always update if in doubt) then
"post
> > as
> > > > > > new".
> > > > > > >
> > > > > > > --
> > > > > > > Regards,
> > > > > > >         Ashley J Gittins
> > > > > > >         web:
http://www.purple.dropbear.id.au
> > > > > > >         jabber: ..hidden..
> > > > > > >
> > > > > > >
> > > > > >
> > > >
> >
-------------------------------------------------------------------------
> > > > > > > Take Surveys. Earn Cash. Influence the Future of IT
> > > > > > > Join SourceForge.net's Techsay panel and you'll get the chance
to
> > > > share
> > > > > > your
> > > > > > > opinions on IT & business topics through brief surveys-and
earn
> > cash
> > > > > > >
> > > > > >
> > > >
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > > > > >
_______________________________________________
> > > > > > > Ledger-smb-users mailing list
> > > > > > > ..hidden..
> > > > > > >
> > > > > >
> > > >
> >
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Regards,
> > > > > > Matt
> > > > > >
> > > >
> >
-------------------------------------------------------------------------
> > > > > > Take Surveys. Earn Cash. Influence the Future of IT
> > > > > > Join SourceForge.net's Techsay panel and you'll get the chance
to
> > share
> > > > your
> > > > > > opinions on IT & business topics through brief surveys-and earn
cash
> > > > > >
> > > >
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > > > > _______________________________________________
> > > > > > Ledger-smb-users mailing list
> > > > > > ..hidden..
> > > > > >
> > > >
> >
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> >
-------------------------------------------------------------------------
> > > > > Take Surveys. Earn Cash. Influence the Future of IT
> > > > > Join SourceForge.net's Techsay panel and you'll get the chance to
> > share
> > > > your
> > > > > opinions on IT & business topics through brief surveys-and earn
cash
> > > > >
> > > >
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > > > _______________________________________________
> > > > > Ledger-smb-users mailing list
> > > > > ..hidden..
> > > > >
> > > >
> >
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Regards,
> > > > Matt
> > > >
> >
-------------------------------------------------------------------------
> > > > Take Surveys. Earn Cash. Influence the Future of IT
> > > > Join SourceForge.net 's Techsay panel and you'll get the chance to
share
> > your
> > > > opinions on IT & business topics through brief surveys-and earn cash
> > > >
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > > _______________________________________________
> > > > Ledger-smb-users mailing list
> > > > ..hidden..
> > > >
> >
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > > >
> > > >
> > >
> > >
> >
-------------------------------------------------------------------------
> > > Take Surveys. Earn Cash. Influence the Future of IT
> > > Join SourceForge.net's Techsay panel and you'll get the chance to
share
> > your
> > > opinions on IT & business topics through brief surveys-and earn cash
> > >
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > _______________________________________________
> > > Ledger-smb-users mailing list
> > > ..hidden..
> > >
> >
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > >
> >
> >
> >
> > --
> > Regards,
> > Matt
> >
-------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net 's Techsay panel and you'll get the chance to share
your
> > opinions on IT & business topics through brief surveys-and earn cash
> >
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> >
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
>
>
-------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
>
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>



--
Regards,
Matt
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users