sql-ledger-users — SQL-Ledger users

[SL] Letterhead on every page

[J.M. \Jersey\ M. <je...@ib...>]

Hello,

I am trying to print my letterhead on every page of the invoice.
First thing I tried is to put the invoice's's headers on every page and it
works. Than I put \include{letterhead.tex} and the letterhead is not
printed. \includeonly{letterhead.tex} is present in the preamble.

I would like to know as well what the meaning of variables is in pagebreake.

If I use "65 27 35" the system moves the whole invoice table to the new
page. When I change to "65 20 35" it prints fine (including invoice's
headers) but the letterhead is not printed :(.
**************************************************
<%pagebreak 65 20 35%>
\end{tabularx}

  \rule{\textwidth}{2pt}
  
  \vspace{0.2cm}

  \hfill
  \begin{tabularx}{\textwidth}{Xr@{\hspace{.5cm}}r@{}}
  & Subtotal & <%sumcarriedforward%> \\
  \end{tabularx}

\newpage
\include{letterhead.tex}
\begin{tabularx}{\textwidth}{*{5}{|X}|} \hline
  \textbf{Invoice No} & \textbf{Date} & \textbf{Order No}
  & \textbf{Salesperson} & \textbf{Page} \\ [0.5em]
  \hline
  <%invnumber%> & <%invdate%> & <%ordnumber%> & <%employee%> & 1 \\
  \hline
\end{tabularx}
************************************************
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Lenny
Leblanc
Sent: 30 March 2006 07:38 PM
To: sql...@li...
Subject: Re: [SL] letterhead on every page?

Well it turns out that my request was a little premature as I sort of 
got it figured out.  I still don't fully understand how the pagebreak 
system works with latex as I do get strange results when it comes to 
anything beyond the second page.  I don't think this will be an issue 
for the time being so I'm not too worried about it.

If anyone has any links to good information on this I would appreciate 
receiving them though as I would like to better understand how 
pagebreaks work rather then just hacking away at the latex template 
until I get a decent result. :)

--
Lenny

Lenny Leblanc wrote:
> Hello list,
>
> I'm a little confused about how latex handles pagebreaks.  Is there a 
> way that I can include my letterhead.tex at the top of every page?
>
> Currently the pagebreak works quite well and doesn't cut off any 
> information, but it would be nice to have this displayed again on the 
> second page.  Any ideas?
>
> -- 
> Lenny
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> language
> that extends applications into web and mobile media. Attend the live 
> webcast
> and join the prime developer group breaking into this new coding 
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] sql-ledger virtual appliance available for download

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

Hi,

A VMware based virtual appliance/machine for sql-ledger is available for download. 

Visit http://wiki.ledger123.com/index.php?n=Local.Virtual

No registration required.

Regards


Armaghan

-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/

Free trial available.
-- 

Re: [SL] Byte sequence error - restoration

[Rolf S. (tokon) <in...@to...>]

David Boyle schrieb:
> ERROR:  invalid byte sequence for encoding "UTF8": 0x8b

It seems your database's encoding is UTF-8, and your backup's is not. If 
you created the target DB manually and didn't specify the charset, it's 
  in UTF-8.
EITHER try to insert

	set client_encoding to sql_ascii;

at the beginning of your backup file if you're in USA, or

	set client_encoding to latin1;

if you're in Europe.
OR create a DB with the charset you need with

	ceatedb -E <charset> <db-name>

 > SQL-Ledger 2.6.22 with Postgresql 8.1
 >
 > Moving to
 > SQL-Ledger 2.8.14 with Postgresql 8.3

I hope you don't try to restore a 2.6.22 backup into a 2.8.14 installation?

Rolf

[SL] Byte sequence error - restoration

[David B. <dav...@sb...>]

I am behind :)
Current
SQL-Ledger 2.6.22 with Postgresql 8.1
        
Moving to
SQL-Ledger 2.8.14 with Postgresql 8.3
        
I created the backup through the SL gui, but when attempting to restore
with psql -U etc I get a recurring error until it drops
        
ERROR:  invalid byte sequence for encoding "UTF8": 0x8b
HINT:  This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
        
Through SL Admin, the datasets are assigned the default encoding.  Can
someone shed some light on this?

Thanks,
David Boyle

[SL] Minor HTML bug?

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

We're running 2.8.8 and get HTML code in the item descriptions when a  
sales order is generated from a timecard.  Specifically, the line  
breaks in the tech's notes come through to the sales order as actual  
"<BR>".  Anybody know if this is fixed in newer versions?


Thanks!

Michael


On Mar 6, 2008, at 9:01 AM, Dieter Simader wrote:
> On Thu, 6 Mar 2008, Joseph A. Maffia wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> I made changes to the balance sheet  html template and wanted to  
>> know if
>> changes can be made  specifically to one company? If not what is the
>> best way to make changes to titles of account groupings in a  
>> financial
>> statement. For example, i have the books for both a non-profit and  
>> a for
>> profit entity and want to use "net assets" and " Partnership Capital"
>> respectively  to describe the equity section on the balance sheet. I
>> have made changes to the chart of accounts but on the balance sheet
>> report is says total equity etc. When I make changes to one  
>> entities it
>> is also made on the other.
>>
>> I am a user and accountant not a programmer.
>
> use the language interface to create different versions.
>
> DS
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] does sql-ledger support these features ?

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

On Thu, 3 Apr 2008, Sandeep Chayapathi wrote:

> Thanks. I did look @ SQL-Ledger's feature list. The feature list is a
> link to screenshot, hence I wasn't sure if it supported the features I
> was looking for.

Sandeep,

>>> Double Entry Accounting

   First sentence on home page: "SQL-Ledger ERP is a double-entry
accounting/ERP system."

>>> Need to be able to send out invoices via email

   Third paragraph on home page: "Invoices, Packing Lists, Income Statement,
Balance Sheet, Sales, Work and Purchase Orders, Statements, Receipts and
Checks are generated from templates and can be changed to suit your needs.
Templates come in html, tex and text format. The tex templates are processed
with latex to produce postscript and PDF documents. Documents can be sent to
a printer, file or fax, emailed or displayed on screen."

   I'm confident the rest of the information is there, too.

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] does sql-ledger support these features ?

[Sandeep C. <sa...@ws...>]

Thanks. I did look @ SQL-Ledger's feature list. The feature list is a  
link to screenshot, hence I wasn't sure if it supported the features I  
was looking for.

- Sandeep

On Apr 3, 2008, at 2:40 PM, Rich Shepard wrote:

> On Thu, 3 Apr 2008, Sandeep Chayapathi wrote:
>
>> Im researching on using a billing software for my company. We are
>> looking for these features:
>
>   Did you look at the SQL-Ledger web site?
>
>> Soft Dollar Billing with multiple Parent Child relationships
>
>   Have no idea what this is.
>
>> Deferred Revenue Recognition/Accrual Accounting
>
>   Yes.
>
>> Double Entry Accounting
>
>   D'oh! Yes.
>
>> Need to be able to send out invoices via email
>
>   Yes.
>
>> Be able to add users to an account on any given month and maintain
>
>   Yes.
>
>> previous deferred billing
>
>   Whatever this is, probably yes.
>
>> Any help in this is very much appreciated.
>
>   Read the pages on the web site.
>
> -- 
> 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
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] does sql-ledger support these features ?

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

On Thu, 3 Apr 2008, Sandeep Chayapathi wrote:

>  Im researching on using a billing software for my company. We are
> looking for these features:

   Did you look at the SQL-Ledger web site?

> Soft Dollar Billing with multiple Parent Child relationships

   Have no idea what this is.

> Deferred Revenue Recognition/Accrual Accounting

   Yes.

> Double Entry Accounting

   D'oh! Yes.

> Need to be able to send out invoices via email

   Yes.

> Be able to add users to an account on any given month and maintain

   Yes.

> previous deferred billing

   Whatever this is, probably yes.

> Any help in this is very much appreciated.

   Read the pages on the web site.

-- 
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] does sql-ledger support these features ?

[Sandeep C. <sa...@ws...>]

Greetings,

  Im researching on using a billing software for my company. We are  
looking for these features:

Soft Dollar Billing with multiple Parent Child relationships
Deferred Revenue Recognition/Accrual Accounting
Double Entry Accounting
Need to be able to send out invoices via email
Be able to add users to an account on any given month and maintain  
previous deferred billing

Any help in this is very much appreciated. Thanks.

- Sandeep

Re: [SL] 2 problems

[Bob G. <bo...@rc...>]

Those are good ideas. You could do the test again and flush the browser
cache in between. On Firefox it is Tools->Clear Private Data  Try just
checking off the Cache.

If you still see the problem (even after trying a different browser), my
best guess is that you could use an upgrade.  If you have a spare
machine around, you could copy over your existing system and data, do
the tests to see that you still have the problem, and then upgrade.

It will take some time, but it is a low risk endeavor as you still have
your production system running. You can also test the hell out of the
upgraded system so your confidence in a cutover increases.

Good luck - Bob G

On Sun, 2008-03-16 at 07:32 +0100, Paul Tammes wrote:
> Ah, that is very strange indeed.
> Just an idea, maybe you have cache and temp file set to ON in your browser
> somehow, and the problem is not with SL but with the browser? I mean. if you
> do an update after every single field (telling the SQL database which fields
> are supposed to be filled with what values) would it STILL change lines /
> fields? Would be troublesome but still a workaround till the real fix comes
> along.
> 
> However I have been running SQL ledger since 1.8x and have not yet seen
> anything like this, either on Internet Explorer, or on Firefox or Konqueror,
> so either I do my data entry different, or have been very lucky.  That being
> said, I do use the ENTER key a lot, I am a keyboard oriented person.
> 
> 
> 2008/3/15, Stuart Luppescu <sl...@cc...>:
> >
> > On 火, 2008-03-11 at 20:29 +0100, "Rolf Stöckli (tokon)" wrote:
> >
> > > Dirk Enrique Seiffert schrieb:
> > > > I have the same problem here: After entering a value in AP
> > > transaction and
> > > > hitting update the first line gets switched to the first available
> > > AP account, no matter what accout was selcted before.
> > >
> > > This looks much like a problem with HTML form data handling. But with
> > > 2.8.13, neither on Windows (Firefox, IE), nor on Linux (Firefox,
> > > Konqueror) I'm able to reproduce this error.
> >
> >
> > I've posted screen captures of this happening on flickr. The file
> > before.png[1] is the screen before I hit update; after.png[2] is after
> > updating.
> >
> > [1] http://flickr.com/photos/16511126@N00/2336037966/
> > [2] http://flickr.com/photos/16511126@N00/2336038086/
> >
> > --
> > Stuart Luppescu -=- s-luppescu .at. uchicago.edu
> >
> > University of Chicago (^_^)/ CCSR
> > 才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
> >
> > A university is what a college becomes when the
> >   faculty loses interest in students.   -- John
> >   Ciardi
> >
> >
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] 2 problems

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

Ah, that is very strange indeed.
Just an idea, maybe you have cache and temp file set to ON in your browser
somehow, and the problem is not with SL but with the browser? I mean. if you
do an update after every single field (telling the SQL database which fields
are supposed to be filled with what values) would it STILL change lines /
fields? Would be troublesome but still a workaround till the real fix comes
along.

However I have been running SQL ledger since 1.8x and have not yet seen
anything like this, either on Internet Explorer, or on Firefox or Konqueror,
so either I do my data entry different, or have been very lucky.  That being
said, I do use the ENTER key a lot, I am a keyboard oriented person.


2008/3/15, Stuart Luppescu <sl...@cc...>:
>
> On 火, 2008-03-11 at 20:29 +0100, "Rolf Stöckli (tokon)" wrote:
>
> > Dirk Enrique Seiffert schrieb:
> > > I have the same problem here: After entering a value in AP
> > transaction and
> > > hitting update the first line gets switched to the first available
> > AP account, no matter what accout was selcted before.
> >
> > This looks much like a problem with HTML form data handling. But with
> > 2.8.13, neither on Windows (Firefox, IE), nor on Linux (Firefox,
> > Konqueror) I'm able to reproduce this error.
>
>
> I've posted screen captures of this happening on flickr. The file
> before.png[1] is the screen before I hit update; after.png[2] is after
> updating.
>
> [1] http://flickr.com/photos/16511126@N00/2336037966/
> [2] http://flickr.com/photos/16511126@N00/2336038086/
>
> --
> Stuart Luppescu -=- s-luppescu .at. uchicago.edu
>
> University of Chicago (^_^)/ CCSR
> 才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
>
> A university is what a college becomes when the
>   faculty loses interest in students.   -- John
>   Ciardi
>
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Net and gross weight

[davidc <da...@mo...>]

I also have this requirement for the export service, where we also 
require volume , and packaging 9 number of cartons ) , in addition to 
the N W and G W , there 4 fields are all in the sale order and invoice 
but I just can not find out how to print them out , so they sum up at 
the end of the column.

if you look at shipping / ship  all these are list out nicely in the 
entering screen, but the packing list do not print out with these 4 fields

allant


Rolf Stöckli (tokon) wrote:
> (SQL-Ledger version 2.8.13)
>
> One of my customer, an industrial bakery, needs on his export invoices 
> information about net and gross weight of the delivered items.
> Actually, we have in SQLL the following (please correct me if I 
> misunderstand):
> - Articles have a single field for weight
> - In sales invoices we have for every line a field grossweight (G.W.), 
> identical with the weight of a single article, and a field netweight 
> (N.W.), consisting of G.W. multiplied by the quantity
> - In sales invoices, we additionally have global fields for the total 
> sums of these grossweights and netweights.
>
> Now what my customer needs, according to customs regulation, is the 
> following:
> - Net and gross weight for every product (because the intrinsic weight 
> of the product and the weight of the packaging are always the same)
> - Net and gross weight for every line of the invoice, consisting of the 
> first two fields multiplied by the quantity
> - Total fields for net and gross weight for all the items on the invoice
>
> My question: Are there other users who have the same needs, so I could 
> contact Dieter about this subject?
>
> Greetings
> Rolf
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] 2 problems

[Stuart L. <sl...@cc...>]

On 火, 2008-03-11 at 20:29 +0100, "Rolf Stöckli (tokon)" wrote:
> Dirk Enrique Seiffert schrieb:
> > I have the same problem here: After entering a value in AP
> transaction and
> > hitting update the first line gets switched to the first available
> AP account, no matter what accout was selcted before.
> 
> This looks much like a problem with HTML form data handling. But with 
> 2.8.13, neither on Windows (Firefox, IE), nor on Linux (Firefox, 
> Konqueror) I'm able to reproduce this error.

I've posted screen captures of this happening on flickr. The file
before.png[1] is the screen before I hit update; after.png[2] is after
updating.

[1] http://flickr.com/photos/16511126@N00/2336037966/
[2] http://flickr.com/photos/16511126@N00/2336038086/

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
A university is what a college becomes when the
 faculty loses interest in students.   -- John
 Ciardi 
 
 

Re: [SL] currency changeover

[Bob G. <bo...@rc...>]

Of course. Software can do anything..

It just takes time and talent to create it.

Bob G

On Tue, 2008-02-26 at 18:38 +0100, Vitaly Popovich wrote:
> So do you think it is possible to convert all items into another
> currency using some sort of automated tool?
> 
> Vitaly
> 
> On 2/26/08, Bob Gustafson <bo...@rc...> wrote:
> > Not necessarily a nightmare: You have the dates of all the transactions,
> > and the exchange rates can be downloaded for each day (even after the
> > day - historically). In fact SL has support for a script that
> > automatically downloads new exchange rates every day.
> >
> > It would also be nice to just 'view' past transactions in another
> > currency, but SL doesn't have that code. SL must add and subtract
> > 'corrections' for each currency translation :-(
> >
> > Bob G
> >
> > On Mon, 2008-02-25 at 20:44 +0100, Vitaly Popovich wrote:
> > > Hi,
> > > I would like to multiply all transactions by the same exchange factor.
> > > It would be a nightmare to convert them using exchange rate at that
> > > date.
> > >
> > > Vitaly
> > >
> > > On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> > > > Do you want to leave all your original transactions in dollars and just
> > > > 'view' them in euros?
> > > >
> > > > Or do you want to multiply all of the past transactions by the currency
> > > > exchange factor?
> > > >
> > > > If the later, do you want to use the currency exchange factor which
> > > > existed on the date of the transaction, or do you wish to just use one
> > > > currency exchange factor for all of the transactions?
> > > >
> > > > It is not a simple thing..
> > > >
> > > > On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > > > > Hello everyone,
> > > > >
> > > > > I am using sql-ledger as a simple accounting system.
> > > > > I was wondering whether there is a way how to change base currency and
> > > > > change all past transactions to be in new currency (euro)?
> > > > > For example, i used USD for transactions and now i need to change all
> > > > > transaction to be in Euro.
> > > > > Is there an automated way or built in function in sql-ledger?
> > > > >
> > > > >
> > > > > Regards,
> > > > > Vitaly
> > > > >
> > > > > -------------------------------------------------------------------------
> > > > > This SF.net email is sponsored by: Microsoft
> > > > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > > > _______________________________________________
> > > > > sql-ledger-users mailing list
> > > > > sql...@li...
> > > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > >
> > > > -------------------------------------------------------------------------
> > > > This SF.net email is sponsored by: Microsoft
> > > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > > _______________________________________________
> > > > sql-ledger-users mailing list
> > > > sql...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > >
> > >
> > > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Microsoft
> > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] 2 problems

[Rolf S. (tokon) <in...@to...>]

Stuart Luppescu schrieb:
> If I lose the server, I have to close
> the business.

I understand your fear. But on the other hand: If there is still a bug 
in the software and Dieter fixes it in 2.8.14, how do you get the patch 
if you don't update?

Rolf

Re: [SL] 2 problems

[Stuart L. <sl...@cc...>]

On 火, 2008-03-11 at 20:29 +0100, "Rolf Stöckli (tokon)" wrote:
> Dirk Enrique Seiffert schrieb:
> > I have the same problem here: After entering a value in AP transaction and
> > hitting update the first line gets switched to the first available AP
> > account, no matter what accout was selcted before.
> 
> This looks much like a problem with HTML form data handling. But with 
> 2.8.13, neither on Windows (Firefox, IE), nor on Linux (Firefox, 
> Konqueror) I'm able to reproduce this error. 

Well, this doesn't happen all the time. Maybe 10% to 20% of the payroll
records are affected. 

> So... what speaks against 
> updating to the actual version?

You mean updating to 2.8.13? Fear. If I lose the server, I have to close
the business. I may update on a backup server first, and then switch
over if it goes ok.
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r8                
Help!  I'm trapped in a Chinese computer factory! 
 
 
 
 

Re: [SL] 2 problems

[Rolf S. (tokon) <in...@to...>]

Dirk Enrique Seiffert schrieb:
> I have the same problem here: After entering a value in AP transaction and
> hitting update the first line gets switched to the first available AP
> account, no matter what accout was selcted before.

This looks much like a problem with HTML form data handling. But with 
2.8.13, neither on Windows (Firefox, IE), nor on Linux (Firefox, 
Konqueror) I'm able to reproduce this error. So... what speaks against 
updating to the actual version?

Rolf

Re: [SL] 2 problems

[Dirk E. S. <ds...@ca...>]

>
> The problem is that after I enter a couple of lines and click update,
> the accounts on the original entries get switched. Maybe I need to
> include screenshots....

I have the same problem here: After entering a value in AP transaction and
hitting update the first line gets switched to the first available AP
account, no matter what accout was selcted before. Only workaround I found
is NOT hitting the update button anymore. This is on SL 2.8.8

Enrique

Cartagena - Colombia
http://www.sipcolombia.com

Re: [SL] 2 problems

[Stuart L. <sl...@cc...>]

On 月, 2008-03-10 at 06:53 +0100, Paul Tammes wrote:
> 1) every sale is a sales invoice, only difference is the payment
> method (cash versus credit). So i guess anyone with permission to use
> cash register can do a cash sale.

Everyone has permission to do POS sales, but not sales invoices.
Usually, after you enter a POS sale and then go to AR -> Reports ->
Transactions and click on the invoice number, an Edit POS Invoice screen
comes up. Occasionally, the employee gets an Edit Sales Invoice screen.
That's the problem.

> 2) Behaviour of ledgers is defined in the CoA (chart of acounts).
> If e.g. you say there the  accrued income tax is an asset, any
> positive number entered in your payroll journal entry will be seen as
> a debit, not a credit. Either fix chart of accounts, or enter negative
> for payable, positive for withhold. Should both work.

The problem is that after I enter a couple of lines and click update,
the accounts on the original entries get switched. Maybe I need to
include screenshots....
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r8                
"In my opinion, Richard Stallman wouldn't recognise
 terrorism if it came up and bit him on his
 Internet." -- Ross M. Greenberg 
 
 

Re: [SL] 2 problems

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

1) every sale is a sales invoice, only difference is the payment method
(cash versus credit).
So i guess anyone with permission to use cash register can do a cash sale.
2) Behaviour of ledgers is defined in the CoA (chart of acounts).
If e.g. you say there the  accrued income tax is an asset, any positive
number entered in your payroll journal entry will be seen as a debit, not a
credit. Either fix chart of accounts, or enter negative for payable,
positive for withhold.
Should both work.

hth
Paul

2008/3/9, Stuart Luppescu <sl...@cc...>:
>
> I've been having two problems that have popped up recently.
> 1) A user enters a POS transaction, but it ends up going in as a Sales
> Invoice. What's really weird is that that user does not have permissions
> to enter a Sales Invoice.
> 2) When I enter payroll records, I typically enter the gross pay in
> account 5410 -- Wages and Salaries, and then the deductions in 2110 --
> Accrued Income Tax - Federal and 2120 -- Accrued Income Tax - State.
> After I enter a couple of lines I hit Update, and after that the
> accounts and amounts are switched. For example, the gross pay amount
> might be assigned to account 2120, or the other way around.
>
> Does anyone know what's going on? I'm using version 2.6.22. Could these
> problems be fixed if I upgraded?
>
> TIA.
> --
> Stuart Luppescu -=- s-luppescu .at. uchicago.edu
> University of Chicago (^_^)/ CCSR
> 才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
> Modern art is what happens when painters stop
>   looking at girls and persuade themselves that they
>   have a better idea.   -- John Ciardi
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] 2 problems

[Stuart L. <sl...@cc...>]

I've been having two problems that have popped up recently.
1) A user enters a POS transaction, but it ends up going in as a Sales
Invoice. What's really weird is that that user does not have permissions
to enter a Sales Invoice. 
2) When I enter payroll records, I typically enter the gross pay in
account 5410 -- Wages and Salaries, and then the deductions in 2110 --
Accrued Income Tax - Federal and 2120 -- Accrued Income Tax - State.
After I enter a couple of lines I hit Update, and after that the
accounts and amounts are switched. For example, the gross pay amount
might be assigned to account 2120, or the other way around.

Does anyone know what's going on? I'm using version 2.6.22. Could these
problems be fixed if I upgraded?

TIA.
-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
Modern art is what happens when painters stop
 looking at girls and persuade themselves that they
 have a better idea.   -- John Ciardi 
 
 

[SL] Net and gross weight

[Rolf S. (tokon) <in...@to...>]

(SQL-Ledger version 2.8.13)

One of my customer, an industrial bakery, needs on his export invoices 
information about net and gross weight of the delivered items.
Actually, we have in SQLL the following (please correct me if I 
misunderstand):
- Articles have a single field for weight
- In sales invoices we have for every line a field grossweight (G.W.), 
identical with the weight of a single article, and a field netweight 
(N.W.), consisting of G.W. multiplied by the quantity
- In sales invoices, we additionally have global fields for the total 
sums of these grossweights and netweights.

Now what my customer needs, according to customs regulation, is the 
following:
- Net and gross weight for every product (because the intrinsic weight 
of the product and the weight of the packaging are always the same)
- Net and gross weight for every line of the invoice, consisting of the 
first two fields multiplied by the quantity
- Total fields for net and gross weight for all the items on the invoice

My question: Are there other users who have the same needs, so I could 
contact Dieter about this subject?

Greetings
Rolf

Re: [SL] html templates

[Dieter S. <dsi...@sq...>]

On Thu, 6 Mar 2008, Joseph A. Maffia wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company? If not what is the
> best way to make changes to titles of account groupings in a financial
> statement. For example, i have the books for both a non-profit and a for
> profit entity and want to use "net assets" and " Partnership Capital"
> respectively  to describe the equity section on the balance sheet. I
> have made changes to the chart of accounts but on the balance sheet
> report is says total equity etc. When I make changes to one entities it
> is also made on the other.
>
> I am a user and accountant not a programmer.

use the language interface to create different versions.

DS

Re: [SL] html templates

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Paul,
 In non profit world for U.S. Gaap purposes equity is called net assets
with no reference to "owners" equity. Same with partnership accounting
they have different tiles for equity accounts.
Joe

www.joemaffia.com



Paul Tammes wrote:
> Sorry, but to me equity is equity, and result previous year is result
> previous year.
> Weather that result is created by donations, gifts, or trade, it is a
> result.
>
> Why rename common used items thus creating unclear set of annual reports?
> The naming of the ledgers themselve should be enough separation to clarify
> any doubts I take it.
>
> So the standard header Equity might show (with or without account nrs, tick
> the box if wanted) Partnership Capital in one report, and Share Capital in
> another report.
>
> Just like assets may be machines in a factory environment, and cars in a
> lease company.
> You would not want to rename those as well i take it?
>
>
> 2008/3/6, Joseph A. Maffia <ja...@jo...>:
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company? If not what is the
> best way to make changes to titles of account groupings in a financial
> statement. For example, i have the books for both a non-profit and a for
> profit entity and want to use "net assets" and " Partnership Capital"
> respectively  to describe the equity section on the balance sheet. I
> have made changes to the chart of accounts but on the balance sheet
> report is says total equity etc. When I make changes to one entities it
> is also made on the other.
>
> I am a user and accountant not a programmer.
>
> Thanks for your help.
>
> Joe
>
> www.joemaffia.com
>
>
>
> Yves Lavoie wrote:
> >>> No, 2 separate problems.
> >>> 1- DB was created, tables also but weren't accessible, relation already
> >>> exist was true, but couldn't be modified.
> >>> 2- existing datasets weren't displayed because the defaults table
wasn't
> >>> owned by sql-ledger, thus making it impossible to delete datasets
> through
> >>> the menu.
> >>>
> >>> Yves
> >>>
> >>> 2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
> >>>> Yves Lavoie schrieb:
> >>>>
> >>>>> It worked for me, fixed the creation errors and solved the empty
> >>>> database
> >>>>> list upon removal, because list is produced by acheck for
ownership on
> >>>>> defaults by sql-ledger.
> >>>> Thanks. So the "relation 'id' already exists" error was caused not
> >>>> because SQL-Ledger was unable to create the DB, but because the
already
> >>>> existing DB didn't appear on the "existing datasets" list?
> >>>>
> -------------------------------------------------------------------------
> >>> This SF.net email is sponsored by: Microsoft
> >>> Defy all challenges. Microsoft(R) Visual Studio 2008.
> >>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
- -------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFHz+011Zo2InkR90QRAn3MAJ9FNpn/1fEAOjp9TaJDr84IztxH2QCgk0qL
PJGcezXt6KZYYGigDrfPZ0o=
=sDnj
-----END PGP SIGNATURE-----

Re: [SL] html templates

[Rolf S. (tokon) <in...@to...>]

Joseph A. Maffia schrieb:
> I made changes to the balance sheet  html template and wanted to know if
> changes can be made  specifically to one company?

In the admin interface, you can create a different set of templates for 
each user account. They will be stored in separate subfolders of 
.../templates/

Rolf