Re: [Ledger-smb-users] upgrades and database integrity.

On Mon, 11 Jan 2010, Stroller wrote: > Ok, using the workflow I described before, the select box is unticked > by default. Right. Enter a customer, hit update. One or more invoices appear, with their boxes unticked. > I guess I started out with LedgerSMB (or SQL-Ledger) by choosing a > cus

Re: [Ledger-smb-users] upgrades and database integrity.

On 11 Jan 2010, at 21:50, Luke wrote: >> ... >> It's very easy in this step to accidentally post a new invoice (to >> the >> same customer) with a negative amount, leaving the original open and >> unpaid. I think this comes from having amounts filled in but the >> select box unticked. > > How wo

Re: [Ledger-smb-users] upgrades and database integrity.

On Mon, 11 Jan 2010, Stroller wrote: > > Here is where our methods differ: if you only check the box(es), > > and then > > select "update", the program should fill in the proper amounts. > > > > You may then update further to your heart's content, and finally > > select > > post. > > > > Only

Re: [Ledger-smb-users] upgrades and database integrity.

On 11 Jan 2010, at 06:48, Luke wrote: > ... > Of course I agree that this is what he should be doing, but I have a > different approach to yours, and I am uncertain why you do it as you > describe... > ... >> Enter the amount in BOTH amount fields, and THIS IS VERY IMPORTANT, >> DO >> NOT SKIP T

Re: [Ledger-smb-users] upgrades and database integrity.

Stroller On Sun, 10 Jan 2010, Stroller wrote: > You need to go to "Cash" in the menu on the left hand side of the > screen, then select "Receipt" in the sub-menu. [.] Of course I agree that this is what he should be doing, but I have a different approach to yours, and I am uncertain why you d

Re: [Ledger-smb-users] upgrades and database integrity.

On 10 Jan 2010, at 21:42, Alvin Starr wrote: > ... > I may be doing something stupid that worked in previous versions. > When we have a payment on an existing invoice we apply the payment and > update as necessary and then post the transaction. > This triggers the "posting an existing transaction"

Re: [Ledger-smb-users] upgrades and database integrity.

Chris Travers wrote: > > > On Fri, Jan 8, 2010 at 12:52 PM, Alvin Starr > wrote: > > > > > > > > > > Ok, let's start by explaining the problem. The short version is > that > > if the problem description doesn't provide for you enough > informat

Re: [Ledger-smb-users] upgrades and database integrity.

Hi John; I had a slightly different approach but conceptually similar. On Fri, Jan 8, 2010 at 2:31 PM, John Locke wrote: > > I'm with Alvin on the upgrade--upgrading in place gives me the > willies... would prefer to migrate my data into a clean install. > What I am thinking is ALTER SCHEMA PU

Re: [Ledger-smb-users] upgrades and database integrity.

Hi, --- Original Message Subject: Re: [Ledger-smb-users] upgrades and database integrity. From: Chris Travers To: ledger-smb-users@lists.sourceforge.net Date: Fri 08 Jan 2010 01:30:23 PM PST > > > On Fri, Jan 8, 2010 at 12:52 PM, Alvin Starr <mailto:al...@iplink

Re: [Ledger-smb-users] upgrades and database integrity.

On Fri, Jan 8, 2010 at 12:52 PM, Alvin Starr wrote: > > > > > > > > > Ok, let's start by explaining the problem. The short version is that > > if the problem description doesn't provide for you enough information > > for you to solve it you would probably be best off with professional > > tech s

Re: [Ledger-smb-users] upgrades and database integrity.

Chris Travers wrote: > > > On Thu, Jan 7, 2010 at 4:35 PM, Alvin Starr > wrote: > > > I started using sql-ledger about 5 years ago and my last upgrade > was 2.6.19 > This was partly due to the fact that I was going to move to ledger-smb > one of these days.

Re: [Ledger-smb-users] upgrades and database integrity.

On Thu, Jan 7, 2010 at 4:35 PM, Alvin Starr wrote: > > I started using sql-ledger about 5 years ago and my last upgrade was 2.6.19 > This was partly due to the fact that I was going to move to ledger-smb > one of these days. > Well the day came and I upgraded through to ledgersmb 1.2.18. > Everyt

Re: [Ledger-smb-users] upgrades and database integrity.

> "Alvin" == Alvin Starr writes: Alvin> I started using sql-ledger about 5 years ago and my last Alvin> upgrade was 2.6.19 This was partly due to the fact that I was Alvin> going to move to ledger-smb one of these days. Well the day Alvin> came and I upgraded through to ledge

Re: [Ledger-smb-users] upgrades and database integrity.

Welcome to the sql-ledger-h...@lists.ledgersmb.org mailing list! I got there through the wiki http://www.ledgersmb.org/node/32 last list item. Looking at it a bit more carefully now I can see the sql-ledger and not ledger-smb thing but this is confusing to say the least. In either case the poi

Re: [Ledger-smb-users] upgrades and database integrity.

On Thu, 7 Jan 2010, Alvin Starr wrote: > I signed up to the help mail list and it seems to be broken. Which list would that be? -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Veriz