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 
 
 

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
>

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

[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

[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

[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...>]

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.

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] 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] 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