sql-ledger-users — SQL-Ledger users

Re: [SL] Reminder Needed: Changing Linking Account

[Paul T. <pt...@wa...>]

Looks wrong to me. Two basic checks:

1) Are you sure 2100 is not a totals or subtotals account? If so, including
the 2110 account would explain the 'double entry / double showup.

I remeber I had some troubles in my scheme and removed all sunbtotal
acounts. That fixed it for me.

2) You menu entry via A/P does not make sense to me. What happens to the
PHYSICAL money you pay the A/P invoces with ,and how is that entered in the
system?

If all else fails, send me your scheme or a backup and I can do some remote
checks and fiddling to see what is happeniong.

2009/2/26 Rich Shepard <rsh...@ap...>

> On Thu, 26 Feb 2009, Paul Tammes wrote:
>
> > How do you enter payments? If via a suspense account, there might be some
> > set offs not automaticaly going trough. Let me explain:
>
> Paul
>
>   Via the A/P menu's 'enter transaction' item.
>
> > I use a ledger for A/P (#1600) when entering invoices. When paid from the
> > bank I debit A/P invoices paid suspense account (#1605). Then the A/P
> dept
> > can apply the amounts in #1605 to settle the paid invoices. Quicker on
> bank
> > account entry, leaving A/P dept with the hassle. But then, they now the
> > suppliers better than I do ;-)
>
>    In my system Current Liabilities is a/c #2100 and A/P is #2110. When an
> invoice comes in I enter an A/P transaction. When I pay them via the Cash
> ->
> Payments page, and post after checking successful printing, I don't expect
> to see them in the 2110 account any longer. But, they're still there. And,
> I
> see them in 2100, the Current Liabilities account.
>
> > What I mean to say is, there might very well be some payments not
> > allocated to the A/P (sub) ledger, which will result in a huge total on
> > A/P. Search for your equivalent of #1605!
>
>    I have no such suspense account.
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.               |  Integrity            Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Reminder Needed: Changing Linking Account

[Rich S. <rsh...@ap...>]

On Thu, 26 Feb 2009, Paul Tammes wrote:

> How do you enter payments? If via a suspense account, there might be some
> set offs not automaticaly going trough. Let me explain:

Paul

   Via the A/P menu's 'enter transaction' item.

> I use a ledger for A/P (#1600) when entering invoices. When paid from the
> bank I debit A/P invoices paid suspense account (#1605). Then the A/P dept
> can apply the amounts in #1605 to settle the paid invoices. Quicker on bank
> account entry, leaving A/P dept with the hassle. But then, they now the
> suppliers better than I do ;-)

   In my system Current Liabilities is a/c #2100 and A/P is #2110. When an
invoice comes in I enter an A/P transaction. When I pay them via the Cash ->
Payments page, and post after checking successful printing, I don't expect
to see them in the 2110 account any longer. But, they're still there. And, I
see them in 2100, the Current Liabilities account.

> What I mean to say is, there might very well be some payments not
> allocated to the A/P (sub) ledger, which will result in a huge total on
> A/P. Search for your equivalent of #1605!

   I have no such suspense account.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Reminder Needed: Changing Linking Account

[Paul T. <pt...@wa...>]

How do you enter payments? If via a suspense account, there might be some
set offs not automaticaly going trough. Let me explain:

I use a ledger for A/P (#1600) when entering invoices. When paid from the
bank I debit A/P invoices paid suspense account (#1605). Then the A/P dept
can apply the amounts in #1605 to settle the paid invoices. Quicker on bank
account entry, leaving A/P dept with the hassle. But then, they now the
suppliers better than I do ;-)

However, the overall balance sheet looks right, even when not settled:
Current Liailities for A/P minus A/P suspense account (1600 and 1605
combined via GIFI code 1600) gives me the correct and  actual Liabilities
amount. Life is good ;-)

What I mean to say is, there might very well be some payments not allocated
to the A/P (sub) ledger, which will result in a huge total on A/P. Search
for your equivalent of #1605!

Hth,
Paul

2009/2/26 Rich Shepard <rsh...@ap...>

>   When I prepare an Accounts Payable transaction it's apparently entered
> both in A/P and Current Liabilities. The latter is the default under the
> specific expense account widget. It's been so long that I have forgotten
> where to change that default to A/P so it's cleared when paid, and not
> accumulated as a current liability.
>
> TIA,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.               |  Integrity            Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Multiple Entries for Same Transaction

[Rich S. <rsh...@ap...>]

On Mon, 9 Feb 2009, Rich Shepard wrote:

> When I look at the trial balance's account for interest and bank charges I
> find 4 entries of the same amount from way back in 2003 until June of last
> year. I'm running version 2.8.20 if that matters.

   Well, I upgraded to 2.8.23, but that's not important.

   As I clean up these multiple entries by deleting and recreating them I
find them added to Accounts Payable, even though there's a balancing payment
against the invoice. This doesn't make sense to me.

   Why does the A/P account show a history of invoices paid, even if the
balance is zero? Shouldn't both A/P and Current Liabilities be empty of
transactions is there are currently no unpaid invoices or the current
portion of a long-term liability?

   I need to understand this so I can get the software back in balance with
my bank statement and have it accurately reflect both what happened (which
will be in the various expense accounts so they don't need to be repeated in
the payables account, too) and where I am.

   While I'm not an accountant, I'm familiar enough with the bookkeeping and
have used business accounting software for about 2 decades now. I'd really
like to know what SL is doing.

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Reminder Needed: Changing Linking Account

[Rich S. <rsh...@ap...>]

   When I prepare an Accounts Payable transaction it's apparently entered
both in A/P and Current Liabilities. The latter is the default under the
specific expense account widget. It's been so long that I have forgotten
where to change that default to A/P so it's cleared when paid, and not
accumulated as a current liability.

TIA,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Sometimes can't print Sales Orders or Invoices

[Nicholas T. O. <brn...@os...>]

Hello,

Sometimes when I try to print Sales Orders or Invoices I get the following 
error:

panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm line 1007

I have tried searching for a solution in the forums and I have found a similar 
problem a number of versions ago. I haven't actually found a solution. I am 
using SQL-Ledger Version 2.8.23 and I believe that is the most recent. Some 
inovices print just fine. I read that it is when an invoice has more than 4 
lines and the invoice I'm having trouble with right now has 8. I tried 
deleting all the lines except for 3 but I still have the problem.

openSuse 11.0
perl 5.10.0-37.6
SQL-Ledger 2.8.23

Any help is appreciated.

Br. Nicholas

-- 
________________________

Nicholas Thirkettle, OSB

Saint Joseph's Monastery
Natchez, MS 39120

www.osbms.org
________________________

Re: [SL] Non-taxed parts in a taxed assembly getting taxed

[Michael H. <mh...@it...>]

Functionally, yes, there's half a dozen ways we can screw around and  
make it work, we're just trying to avoid the hassle!  :)
    I suppose this could even be considered a bug, though if it  
doesn't affect anybody else I wouldn't exactly expect Dieter to put  
it on the radar.


Thanks,

Michael


On Feb 16, 2009, at 1:06 PM, Rich Shepard wrote:

On Mon, 16 Feb 2009, Michael Hasse wrote:

> That's exactly how we have been doing it historically.  Problem is  
> we are
>   working with a new leasing company now and they want each hardware
>   component to have the cost of the associated labor wrapped up into a
>   single line item. So I'm assuming from the responses nobody's  
> actually
>   dealt with this before?  Ugh.

Michael,

    Perhaps others have worked with more modern leasing companies. :-)

    Can't you itemize as appropriate for tax purposes yet provide the  
leasing
company with a single, summary value?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity             
Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:  
503-667-8863

------------------------------------------------------------------------ 
------
Open Source Business Conference (OSBC), March 24-25, 2009, San  
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the  
Enterprise
-Strategies to boost innovation and cut costs with open source  
participation
-Receive a $600 discount off the registration fee with the source  
code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Non-taxed parts in a taxed assembly getting taxed

[Rich S. <rsh...@ap...>]

On Mon, 16 Feb 2009, Michael Hasse wrote:

> That's exactly how we have been doing it historically.  Problem is we are
>   working with a new leasing company now and they want each hardware
>   component to have the cost of the associated labor wrapped up into a
>   single line item. So I'm assuming from the responses nobody's actually
>   dealt with this before?  Ugh.

Michael,

   Perhaps others have worked with more modern leasing companies. :-)

   Can't you itemize as appropriate for tax purposes yet provide the leasing
company with a single, summary value?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Non-taxed parts in a taxed assembly getting taxed

[Michael H. <mh...@it...>]

That's exactly how we have been doing it historically.  Problem is we are working with a new leasing company now and they want each hardware component to have the cost of the associated labor wrapped up into a single line item.
   So I'm assuming from the responses nobody's actually dealt with this before?  Ugh.


Thanks,

Michael


----- Original Message -----
From: "Rich Shepard" <rsh...@ap...>
To: sql...@li...
Sent: Monday, February 16, 2009 11:54:36 AM GMT -08:00 US/Canada Pacific
Subject: Re: [SL] Non-taxed parts in a taxed assembly getting taxed

On Mon, 16 Feb 2009, Michael Hasse wrote:

>    In our neck of the woods certain specific types of labor spent doing
> things like programming are tax exempt.  Other types of labor, and
> components, are taxed.
>    Our assemblies in this case include a fair amount of custom programming
> time which should not be taxed, and with that being the bulk of the total,
> I can assure you our customers notice if they're getting taxed on the
> whole amount!

Michael,

   IANAA. However, in my naivety I see the programming efforts (labor) as
separate from the individual physical components and labor that combines
them into a single assembly. Why not have the coding be a separate line item
on the invoice (and as a separate inventory item)?

   A former neighbor had a nice business of designing and building sawmill
controllers as well as writing the custom software to run them. Before the
timber industry out here virtually collapsed under court challenge (that's a
discussion for another time and place), sawmills that were constructed to
saw large, old growth Douglas fir logs had to be retrofitted to cut smaller
trees and of different species. Hence, his business.

   Considering that his custom saw controllers (which his wife built in the
garage) could be programmed for different size logs and different species,
the coding was separate from the physical controller assembly.

   I assume that in your case, a customer could have you later write
different software that would work with the same physical assembly you sold
them. Hence, separating the two is easily justified and resolves the tax
issue.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Non-taxed parts in a taxed assembly getting taxed

[Rich S. <rsh...@ap...>]

On Mon, 16 Feb 2009, Michael Hasse wrote:

>    In our neck of the woods certain specific types of labor spent doing
> things like programming are tax exempt.  Other types of labor, and
> components, are taxed.
>    Our assemblies in this case include a fair amount of custom programming
> time which should not be taxed, and with that being the bulk of the total,
> I can assure you our customers notice if they're getting taxed on the
> whole amount!

Michael,

   IANAA. However, in my naivety I see the programming efforts (labor) as
separate from the individual physical components and labor that combines
them into a single assembly. Why not have the coding be a separate line item
on the invoice (and as a separate inventory item)?

   A former neighbor had a nice business of designing and building sawmill
controllers as well as writing the custom software to run them. Before the
timber industry out here virtually collapsed under court challenge (that's a
discussion for another time and place), sawmills that were constructed to
saw large, old growth Douglas fir logs had to be retrofitted to cut smaller
trees and of different species. Hence, his business.

   Considering that his custom saw controllers (which his wife built in the
garage) could be programmed for different size logs and different species,
the coding was separate from the physical controller assembly.

   I assume that in your case, a customer could have you later write
different software that would work with the same physical assembly you sold
them. Hence, separating the two is easily justified and resolves the tax
issue.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Non-taxed parts in a taxed assembly getting taxed

[Michael H. <mh...@it...>]

Thank you for the concern Paul, we've been through all this with the  
local tax authorities more than once.  :)
    In our neck of the woods certain specific types of labor spent  
doing things like programming are tax exempt.  Other types of labor,  
and components, are taxed.
    Our assemblies in this case include a fair amount of custom  
programming time which should not be taxed, and with that being the  
bulk of the total, I can assure you our customers notice if they're  
getting taxed on the whole amount!


Thanks,

Michael


On Feb 16, 2009, at 7:13 AM, Paul Tammes wrote:

Are you sure that the although te assembly ultimately is one (new) item,
hence the word assembly, it is still possible to pay tax on only a  
part of
it?
Does not make sense to me at all. Can you be more specific as to what  
items
are assembled and what part it is that should stay tax free?

BTW, I suggest you take it up with the tax authorities before NOT
calculating an dor pay the taxman. Those guys mostly have a very poor  
sense
of humour.

2009/2/16 Michael Hasse <mh...@it...>

> Hi Everybody,
>
>    Hope somebody has run into this before.
>    We have recently started making more use of assemblies and have
> discovered that if an assembly has a mix of taxed and non-taxed
> components tax is getting calculated based on the total of all rather
> than just the taxable portion.
>    Anybody already have a resolution for this issue?
>
>
> Thanks!
>
> Michael
>
> ---------------------------------------------------------------------- 
> --------
> Open Source Business Conference (OSBC), March 24-25, 2009, San  
> Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source  
> code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
------------------------------------------------------------------------ 
------
Open Source Business Conference (OSBC), March 24-25, 2009, San  
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the  
Enterprise
-Strategies to boost innovation and cut costs with open source  
participation
-Receive a $600 discount off the registration fee with the source  
code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Non-taxed parts in a taxed assembly getting taxed

[Paul T. <pt...@wa...>]

Are you sure that the although te assembly ultimately is one (new) item,
hence the word assembly, it is still possible to pay tax on only a part of
it?
Does not make sense to me at all. Can you be more specific as to what items
are assembled and what part it is that should stay tax free?

BTW, I suggest you take it up with the tax authorities before NOT
calculating an dor pay the taxman. Those guys mostly have a very poor sense
of humour.

2009/2/16 Michael Hasse <mh...@it...>

> Hi Everybody,
>
>    Hope somebody has run into this before.
>    We have recently started making more use of assemblies and have
> discovered that if an assembly has a mix of taxed and non-taxed
> components tax is getting calculated based on the total of all rather
> than just the taxable portion.
>    Anybody already have a resolution for this issue?
>
>
> Thanks!
>
> Michael
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Non-taxed parts in a taxed assembly getting taxed

[Michael H. <mh...@it...>]

Hi Everybody,

    Hope somebody has run into this before.
    We have recently started making more use of assemblies and have  
discovered that if an assembly has a mix of taxed and non-taxed  
components tax is getting calculated based on the total of all rather  
than just the taxable portion.
    Anybody already have a resolution for this issue?


Thanks!

Michael

Re: [SL] (no subject)

[Wallace R. C. <wrc...@gm...>]

On Fri, Feb 13, 2009 at 10:24 AM, Michael Hasse <mh...@it...> wrote:
> Perhaps what appears to be the original poster's tagline, advertising
> an OpenSource conference, was actually the body of the message.

With no input from the OP, we can only conjecture. :-)

-- 
Best Regards,
Wallace

Re: [SL] (no subject)

[Michael H. <mh...@it...>]

Perhaps what appears to be the original poster's tagline, advertising  
an OpenSource conference, was actually the body of the message.


On Feb 13, 2009, at 9:13 AM, Rich Shepard wrote:

On Fri, 13 Feb 2009, Wallace Roberts Consulting wrote:

> On Fri, Feb 13, 2009 at 6:58 AM, fahriaydin <fah...@gm...>  
> wrote:
>>
>>
>
> Eh?

    Obviously, the original poster believes in the adage that if you  
have
nothing to say, don't say it.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity             
Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:  
503-667-8863

------------------------------------------------------------------------ 
------
Open Source Business Conference (OSBC), March 24-25, 2009, San  
Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the  
Enterprise
-Strategies to boost innovation and cut costs with open source  
participation
-Receive a $600 discount off the registration fee with the source  
code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] (no subject)

[Rich S. <rsh...@ap...>]

On Fri, 13 Feb 2009, Wallace Roberts Consulting wrote:

> On Fri, Feb 13, 2009 at 6:58 AM, fahriaydin <fah...@gm...> wrote:
>>
>>
>
> Eh?

   Obviously, the original poster believes in the adage that if you have
nothing to say, don't say it.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] (no subject)

[Wallace R. C. <wrc...@gm...>]

On Fri, Feb 13, 2009 at 6:58 AM, fahriaydin <fah...@gm...> wrote:
>
>

Eh?

-- 
Best Regards,
Wallace

Re: [SL] Re-generating Year End For Prior Years

[Armaghan S. <sa...@le...>]

On Thu, Feb 12, 2009 at 7:06 PM, Rich Shepard <rsh...@ap...> wrote:
> On Thu, 12 Feb 2009, Armaghan Saqib wrote:
>> Duplication in chart can be confirmed using the following query.
>>
>>                SELECT id, 'chart' AS table, COUNT(*) AS count
>>                FROM chart
>>                GROUP BY 1,2
>>                HAVING COUNT(*) > 1
>
> Armaghan,
>
>   The above script returns 0 rows. Where do I learn what function is
> provided by the chart table?

'chart' table is used for the chart of accounts.

1. Could you confirm that year end transactions are not duplicated in
the database (acc_trans). You could search for these by using query
like:

SELECT * FROM acc_trans WHERE trans_id = closing_entry_id;

closing_entry_id can be found on "general ledger-reports". click the
'ID' checkbox before clicking the continue button.

2. Also make sure there is no duplicate account number.  Following
query should help.

                SELECT accno, COUNT(*) AS count
                FROM chart
                GROUP BY 1
                HAVING COUNT(*) > 1

Regards
-- 
http://www.ledger123.com/

- Free SQL-Ledger Hosting
- Documentation wiki
- Virtual appliances
--

Re: [SL] Re-generating Year End For Prior Years

[Rich S. <rsh...@ap...>]

On Thu, 12 Feb 2009, Armaghan Saqib wrote:

> Duplication in chart can be confirmed using the following query.
>
>                SELECT id, 'chart' AS table, COUNT(*) AS count
>                FROM chart
>                GROUP BY 1,2
>                HAVING COUNT(*) > 1

Armaghan,

   The above script returns 0 rows. Where do I learn what function is
provided by the chart table?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Re-generating Year End For Prior Years

[Armaghan S. <sa...@le...>]

On 2/12/09, Rich Shepard <rsh...@ap...> wrote:
>    I thought so. They're duplicated, too, so the entire system is a mess and
> I have to quickly straighten it all out.

Look into the database tables directly and let us know if these
transactions are duplicated in the database too.

I think there is a duplicate id in chart (or somewhere else). This
will be confirmed if the transaction is not duplicated in table
(acc_trans) and only appears so in sql-ledger.

Duplication in chart can be confirmed using the following query.

                SELECT id, 'chart' AS table, COUNT(*) AS count
                FROM chart
                GROUP BY 1,2
                HAVING COUNT(*) > 1

I have a small script (LedgerDoctor) which does a number of health
checks (actually sql queries) on your database. It does not correct
any issue but you can do that yourself once you know where the problem
is. (All queries in the source are documented so you can run these one
by one yourself if you like)

I am sending you this script off-list. (Anyone else interested, let me
know. It is free for the list.)

Regards

-- 
http://www.ledger123.com/

- Free SQL-Ledger Hosting
- Documentation wiki
- Virtual appliances
--

Re: [SL] assistance with LaTeX template - items cut off page

[Michael H. <mh...@it...>]

Yes, definitely just play with it a bit.  If you try to go understand  
Tex syntax from a manual or HowTo it'll just make your head spin!  :)


Thanks,

Michael

On Feb 11, 2009, at 7:37 PM, Jeff Roberts wrote:

Hello

I went through this as well, my suggestion is to get into the server and
copy the invoice template so you have a backup and then return to the
browser and just play with it. You can do all of the editing from within
SQL so you don't even have to leave the menu system, make a change and
print another copy and compare, etc. After a short time you'll start to
see what controls what. I think in less than an hour I had fixed my
length problem and tuned up a few other details while I was in there, it
wasn't hard to understand.

Jeff


Myk Robinson wrote:
> Thanks for the reply. Is anyone able to give me some pointers on  
> this? I
> don't really understand TeX. This is currently the standard
> out-of-the-box TeX template, with the exception of the customized
> letterhead. Since this is a common problem, I am hoping that  
> someone can
> tell me what is safe for me to remove. Granted, I could do some trial
> and error, but looking at the TeX language, I am not sure what is safe
> to delete.
>
> Thanks in advance,
>
> On Sat, 2009-01-31 at 10:06 -0800, Michael Hasse wrote:
>
>
>> This is a common problem.  Even though the page may be defined as
>> 8.5x11 in the template, what actually gets printed out is the total
>> length of "stuff" defined within the template.
>>     I.e. you need to go through it line by line and add up the total
>> length of the content and then start fiddling with it and seeing
>> where you can maybe combine or eliminate lines of text & carriage-
>> returns, shrink margins, reduce font & image sizes etc to get the
>> aggregate back down to 11in.
>>
>>
>> Thanks,
>>
>> Michael
>>
>>
>> On Jan 31, 2009, at 9:48 AM, Myk Robinson wrote:
>>
>> I have my TeX template set up for invoices by modifying slightly  
>> the US
>> Letter Size default template. I have changed only the letterhead to
>> include my company logo and moved the address information around a  
>> bit.
>>
>> When I print an invoice, if the client has made payments, the
>> information is cut off at the bottom of the page. Seems as though
>> something is out of whack with the template, but again, I have only
>> adjusted the letterhead.
>>
>> I need some help formatting this so that the document properly  
>> fits a US
>> letter sized document, 8.5 inches by 11 inches.
>>
>> Here is my TeX template:
>>
>> http://pastebin.ca/1323694
>>
>> And a sample invoice:
>>
>> http://www.sendspace.com/file/4ovnd4
>>
>>
>> Thanks in advance to anyone who can help.
>>
>> --
>> Myk Robinson
>> Computer Support Specialist
>> Kingdom Computer Solutions
>> http://www.kingdomcomputer.info
>> myk...@ki...
>> (731) 616.5030
>> --------------------------------------------------------------------- 
>> ---
>> ------
>> This SF.net email is sponsored by:
>> SourcForge Community
>> SourceForge wants to tell your story.
>> http://p.sf.net/sfu/sf-spreadtheword
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> --------------------------------------------------------------------- 
>> ---------
>> This SF.net email is sponsored by:
>> SourcForge Community
>> SourceForge wants to tell your story.
>> http://p.sf.net/sfu/sf-spreadtheword
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
> ---------------------------------------------------------------------- 
> --------
> Create and Deploy Rich Internet Apps outside the browser with Adobe 
> (R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills  
> and code to
> build responsive, highly engaging applications that combine the  
> power of local
> resources and data with the reach of the web. Download the Adobe  
> AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/ 
> adobe-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>

------------------------------------------------------------------------ 
------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R) 
AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and  
code to
build responsive, highly engaging applications that combine the power  
of local
resources and data with the reach of the web. Download the Adobe AIR  
SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/ 
adobe-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] assistance with LaTeX template - items cut off page

[Jeff R. <je...@jr...>]

Hello

I went through this as well, my suggestion is to get into the server and 
copy the invoice template so you have a backup and then return to the 
browser and just play with it. You can do all of the editing from within 
SQL so you don't even have to leave the menu system, make a change and 
print another copy and compare, etc. After a short time you'll start to 
see what controls what. I think in less than an hour I had fixed my 
length problem and tuned up a few other details while I was in there, it 
wasn't hard to understand.

Jeff


Myk Robinson wrote:
> Thanks for the reply. Is anyone able to give me some pointers on this? I
> don't really understand TeX. This is currently the standard
> out-of-the-box TeX template, with the exception of the customized
> letterhead. Since this is a common problem, I am hoping that someone can
> tell me what is safe for me to remove. Granted, I could do some trial
> and error, but looking at the TeX language, I am not sure what is safe
> to delete.
>
> Thanks in advance,
>
> On Sat, 2009-01-31 at 10:06 -0800, Michael Hasse wrote:
>
>   
>> This is a common problem.  Even though the page may be defined as  
>> 8.5x11 in the template, what actually gets printed out is the total  
>> length of "stuff" defined within the template.
>>     I.e. you need to go through it line by line and add up the total  
>> length of the content and then start fiddling with it and seeing  
>> where you can maybe combine or eliminate lines of text & carriage- 
>> returns, shrink margins, reduce font & image sizes etc to get the  
>> aggregate back down to 11in.
>>
>>
>> Thanks,
>>
>> Michael
>>
>>
>> On Jan 31, 2009, at 9:48 AM, Myk Robinson wrote:
>>
>> I have my TeX template set up for invoices by modifying slightly the US
>> Letter Size default template. I have changed only the letterhead to
>> include my company logo and moved the address information around a bit.
>>
>> When I print an invoice, if the client has made payments, the
>> information is cut off at the bottom of the page. Seems as though
>> something is out of whack with the template, but again, I have only
>> adjusted the letterhead.
>>
>> I need some help formatting this so that the document properly fits a US
>> letter sized document, 8.5 inches by 11 inches.
>>
>> Here is my TeX template:
>>
>> http://pastebin.ca/1323694
>>
>> And a sample invoice:
>>
>> http://www.sendspace.com/file/4ovnd4
>>
>>
>> Thanks in advance to anyone who can help.
>>
>> --
>> Myk Robinson
>> Computer Support Specialist
>> Kingdom Computer Solutions
>> http://www.kingdomcomputer.info
>> myk...@ki...
>> (731) 616.5030
>> ------------------------------------------------------------------------ 
>> ------
>> This SF.net email is sponsored by:
>> SourcForge Community
>> SourceForge wants to tell your story.
>> http://p.sf.net/sfu/sf-spreadtheword
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.net email is sponsored by:
>> SourcForge Community
>> SourceForge wants to tell your story.
>> http://p.sf.net/sfu/sf-spreadtheword
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code to
> build responsive, highly engaging applications that combine the power of local
> resources and data with the reach of the web. Download the Adobe AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

Re: [SL] assistance with LaTeX template - items cut off page

[Myk R. <myk...@gm...>]

Thanks for the reply. Is anyone able to give me some pointers on this? I
don't really understand TeX. This is currently the standard
out-of-the-box TeX template, with the exception of the customized
letterhead. Since this is a common problem, I am hoping that someone can
tell me what is safe for me to remove. Granted, I could do some trial
and error, but looking at the TeX language, I am not sure what is safe
to delete.

Thanks in advance,

On Sat, 2009-01-31 at 10:06 -0800, Michael Hasse wrote:

> This is a common problem.  Even though the page may be defined as  
> 8.5x11 in the template, what actually gets printed out is the total  
> length of "stuff" defined within the template.
>     I.e. you need to go through it line by line and add up the total  
> length of the content and then start fiddling with it and seeing  
> where you can maybe combine or eliminate lines of text & carriage- 
> returns, shrink margins, reduce font & image sizes etc to get the  
> aggregate back down to 11in.
> 
> 
> Thanks,
> 
> Michael
> 
> 
> On Jan 31, 2009, at 9:48 AM, Myk Robinson wrote:
> 
> I have my TeX template set up for invoices by modifying slightly the US
> Letter Size default template. I have changed only the letterhead to
> include my company logo and moved the address information around a bit.
> 
> When I print an invoice, if the client has made payments, the
> information is cut off at the bottom of the page. Seems as though
> something is out of whack with the template, but again, I have only
> adjusted the letterhead.
> 
> I need some help formatting this so that the document properly fits a US
> letter sized document, 8.5 inches by 11 inches.
> 
> Here is my TeX template:
> 
> http://pastebin.ca/1323694
> 
> And a sample invoice:
> 
> http://www.sendspace.com/file/4ovnd4
> 
> 
> Thanks in advance to anyone who can help.
> 
> --
> Myk Robinson
> Computer Support Specialist
> Kingdom Computer Solutions
> http://www.kingdomcomputer.info
> myk...@ki...
> (731) 616.5030
> ------------------------------------------------------------------------ 
> ------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Re-generating Year End For Prior Years

[Rich S. <rsh...@ap...>]

On Thu, 12 Feb 2009, Armaghan Saqib wrote:

> In sql-ledger, yearend  process posts a normal gl transaction which
> posts the net diffierence of revenue/expenses accounts to earnings
> accounts.

Armaghan,

   Yes, I've seen this each year.

> Yes, you can re-run the year end for all the past years one by one.
> Before doing this you should delete the existing year-end journal
> entries. You can list them using 'General Ledger -- Reports' menu
> option.

   I thought so. They're duplicated, too, so the entire system is a mess and
I have to quickly straighten it all out.

> I hope this is clear. If not let me know.

   Much appreciated.

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Re-generating Year End For Prior Years

[Armaghan S. <sa...@le...>]

On 2/12/09, Rich Shepard <rsh...@ap...> wrote:
> I have to manually clean up all the duplicate entries that go back 61months.
> Can I re-run the year end closing for these years (2004-2007) on the corrected data?

In sql-ledger, yearend  process posts a normal gl transaction which
posts the net diffierence of revenue/expenses accounts to earnings
accounts.

Yes, you can re-run the year end for all the past years one by one.
Before doing this you should delete the existing year-end journal
entries. You can list them using 'General Ledger -- Reports' menu
option.

If you have forgotten the dates of previous year ends, you can look
into the yearend table which contains the ID and date of the year end
journal entries. When you delete the yearend journals, rows from
yearend table will be removed too.

I hope this is clear. If not let me know.

Regards
-- 
http://www.ledger123.com/

- Free SQL-Ledger Hosting
- Documentation wiki
- Virtual appliances
--