sql-ledger-users — SQL-Ledger users

Re: [SL] unique ID's

[C. D. H. <Du...@Du...>]

arc...@mt... wrote:
>> From: "C. Duncan Hudson" <Du...@Du...>
>> Date: 2007/02/07 Wed AM 11:23:06 CST
>> To: sql...@li...
>> Subject: Re: [SL] unique ID's
>>
>> Our accountants just about stroked out when they discovered duplicate
>> invoice numbers in SQL-Ledger.  The official response on this list was
>> "don't let your users make duplicaes".  Which, I think was a little
>> poor.  Our users weren't doing it on purpose, but the Post As New
>> buttons duplicate invoices, quotes, POs, etc verbatim - including the
>> ID.  I can't imagine why anyone who wasn't cooking their books would
>> want duplicate invoice numbers, so I added logic to force a new invoice,
>> quote and PO number assignment if a duplicate existed.
>>
>> Dunc
>>     
>
> The only reason I've had to use duplicate invoice numbers, was in cases where a vendor's software would not match SL Ledger due to differences on if the tax was calculated on the subtotal or each line item.
>
> I would:
> 1) create an AP transaction (with just the tax difference) using the same number as the vendor invoice in SL.
> 2) Put a comment in the notes field, about why the transaction existed.
>
> By using the same invoice number, a report would group them together.
>
>
> Since then, a kind list member, George Osvald gave me a alternative.
> http://sourceforge.net/mailarchive/message.php?msg_id=9106581
> (ignore my misguided reply in the archive.. i misunderstood what he meant)
>
>
> I wish that:
>
> 1) Administrator users could override the tax on vendor invoices
> 2) That SL allowed you to force unique invoice numbers. A toggle like that of enforce transaction reversal would be good.
>   
I have no logic to prevent duplicate vendor invoices - with hundreds of 
vendors I have to allow for the fact that there will be dups on that 
side of the house. But with my company's documents there can be no 
duplicates - I believe that is basic GAAP. As for tax... Ugh - I wish 
you could override tax throughout the entire application. SQL-Ledger's 
tax logic is the biggest thorn in my side.

Dunc

Re: [SL] unique ID's

[<arc...@mt...>]

> 
> From: "C. Duncan Hudson" <Du...@Du...>
> Date: 2007/02/07 Wed AM 11:23:06 CST
> To: sql...@li...
> Subject: Re: [SL] unique ID's
> 
> Our accountants just about stroked out when they discovered duplicate
> invoice numbers in SQL-Ledger.  The official response on this list was
> "don't let your users make duplicaes".  Which, I think was a little
> poor.  Our users weren't doing it on purpose, but the Post As New
> buttons duplicate invoices, quotes, POs, etc verbatim - including the
> ID.  I can't imagine why anyone who wasn't cooking their books would
> want duplicate invoice numbers, so I added logic to force a new invoice,
> quote and PO number assignment if a duplicate existed.
> 
> Dunc

The only reason I've had to use duplicate invoice numbers, was in cases where a vendor's software would not match SL Ledger due to differences on if the tax was calculated on the subtotal or each line item.

I would:
1) create an AP transaction (with just the tax difference) using the same number as the vendor invoice in SL.
2) Put a comment in the notes field, about why the transaction existed.

By using the same invoice number, a report would group them together.


Since then, a kind list member, George Osvald gave me a alternative.
http://sourceforge.net/mailarchive/message.php?msg_id=9106581
(ignore my misguided reply in the archive.. i misunderstood what he meant)


I wish that:

1) Administrator users could override the tax on vendor invoices
2) That SL allowed you to force unique invoice numbers. A toggle like that of enforce transaction reversal would be good.

Cheers
Roy

Re: [SL] unique ID's

[C. D. H. <Du...@Du...>]

Our accountants just about stroked out when they discovered duplicate
invoice numbers in SQL-Ledger.  The official response on this list was
"don't let your users make duplicaes".  Which, I think was a little
poor.  Our users weren't doing it on purpose, but the Post As New
buttons duplicate invoices, quotes, POs, etc verbatim - including the
ID.  I can't imagine why anyone who wasn't cooking their books would
want duplicate invoice numbers, so I added logic to force a new invoice,
quote and PO number assignment if a duplicate existed.

Dunc

ma ga wrote:
> Dear All,
>   While working on SL I noticed that numbers are not unique in different areas like Item no., invoice no, RFQ no., .... etc.    I wonder, if this was made on purpose and why .... I am considering putting some validation to guarantee the uniqueness of these feilds .... I appreciate your feedback?
>
> Regards,
> -Mahmoud
>
>
>  
> ____________________________________________________________________________________
> The fish are biting. 
> Get more visitors on your site using Yahoo! Search Marketing.
> http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

[SL] recurring transaction

[Kevin B. <kb...@fr...>]

Hi,

The recurring transaction has been really neatly added and is a real 
plus to the system.

However I have a query.

In the manual it says that there is a difference between scheduling a 
new transaction and scheduling an existing transaction. But I can't get 
this difference to work.

When I open the transaction page I then add in the details and click 
update. I can now click the schedule button now and fill in details for 
the schedule - however this schedule is not saved and does not appear in 
the list of recurring transactions.

I have to post the transaction first, then relist the transactions, find 
the transaction and then create the schedule - but this is the same as 
scheduling as existing transaction.

What I'd like to do is to create a scheduled which starts on say the 1st 
July 2007 - so when I log in after the 1st July I am prompted to add 
this transaction and it gets emails out.

What I think I have to do currently is to create the transaction for 1st 
July 2007. Then create a schedule for the subsequent transactions. I'll 
then have to manually remember to email out the invoice on the 1st July 
- but the next transactions will be prompted for which will be great.

BTW - I say transactions but I am using sales invoices (which are a 
transaction as far as I know!)

Cheers,

Kevin

Re: [SL] Cash reports not adding up

[Ed W <li...@wi...>]

Michael Hasse wrote:
> We just found the same thing in the tax reports.  We had to specify =20
> "detail" to get the right (we hope!) numbers.  :/
>  =20

Yes, the summary report seems often to be buggy.

I have found other worrying things such as the amount on the invoice=20
screen is =A30.01 different to the amount on the "Cash Payment" screen fo=
r=20
the same invoice... (Clearly a duplicated calculation which happens to=20
round differently)

Also I have now got several transactions which can't be found by=20
"Searching" for them by serial number, but appear if you list all the=20
transactions and click into the relevant transaction...

Regards

Ed W

[SL] unique ID's

[ma ga <ma_...@ya...>]

Dear All,=0A  While working on SL I noticed that numbers are not unique in =
different areas like Item no., invoice no, RFQ no., .... etc.    I wonder, =
if this was made on purpose and why .... I am considering putting some vali=
dation to guarantee the uniqueness of these feilds .... I appreciate your f=
eedback?=0A=0ARegards,=0A-Mahmoud=0A=0A=0A =0A_____________________________=
_______________________________________________________=0AThe fish are biti=
ng. =0AGet more visitors on your site using Yahoo! Search Marketing.=0Ahttp=
://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php

Re: [SL] PDF report ??

[syahrianto <sya...@ci...>]

Jeff Roberts wrote:

>Hello Rian
>
>Add new reports under your login name directory 
>/usr/local/sql-ledger/templates/Rian. There are html and latex reports, 
>if you edit the latex report then both pdf and postscript will be changed.
>
>To preview the new report print it as a pdf report to "screen" then 
>Acrobat or whatever you are using for .pdf should open and display what 
>you've chosen.
>
>Jeff
>
>
>  
>
Thanks ........ :-)

but I've try to print as pdf to "screen", and save result to my 
computer. I'm using pdf reader  7.0
But can't display result.The error message "File damaged could not be 
repaired" ...

Thanks Jeff

Rian

Re: [SL] PDF report ??

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

Hello Rian

Add new reports under your login name directory 
/usr/local/sql-ledger/templates/Rian. There are html and latex reports, 
if you edit the latex report then both pdf and postscript will be changed.

To preview the new report print it as a pdf report to "screen" then 
Acrobat or whatever you are using for .pdf should open and display what 
you've chosen.

Jeff


syahrianto wrote:
> Jeff Roberts wrote:
>
>   
>> Hello Rian
>>
>> Your question is not clear.
>>
>> Are you having trouble printing a pdf document with latex?
>>
>> Can you print in postscript?
>>
>> Jeff
>>  
>>
>>     
> Sory,  if my question not so clear...
>
> I'm using sql-ledger-269.... I want to add new reports. But I don't know 
> how to prreview report in pdf format.
> I read that latex can be used as template  which can be converted to 
> many format such as pdf, csv, postscript.
>
> I still confuse which module I should use.
> I've read Form.pm, but still confused. It using system("pdflatex 
> --interaction=nonstopmode $self->{tmpfile} > $self->{errfile}");
>
> Help me..
>
> Rian
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

Re: [SL] PDF report ??

[syahrianto <sya...@ci...>]

Jeff Roberts wrote:

>Hello Rian
>
>Your question is not clear.
>
>Are you having trouble printing a pdf document with latex?
>
>Can you print in postscript?
>
>Jeff
>  
>
Sory,  if my question not so clear...

I'm using sql-ledger-269.... I want to add new reports. But I don't know 
how to prreview report in pdf format.
I read that latex can be used as template  which can be converted to 
many format such as pdf, csv, postscript.

I still confuse which module I should use.
I've read Form.pm, but still confused. It using system("pdflatex 
--interaction=nonstopmode $self->{tmpfile} > $self->{errfile}");

Help me..

Rian

Re: [SL] PDF report ??

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

Hello Rian

Your question is not clear.

Are you having trouble printing a pdf document with latex?

Can you print in postscript?

Jeff


syahrianto wrote:
> Salam (Indonesian Greeting's  :-) )
> Dear all,
>
> Sory Friends, if my english not so good.
>
> I'm still confused how to use latex to create pdf report. Any body can 
> help me.... Thanks soo for any suggestions...
>
> latex, n pdf perl already has installed using cpan.
>
> How "perl -> pdf" syntax to create pdf documents: create table, line, 
> alignment ...etc.
>
> Thanks so much....
>
> Rian
>
>
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

[SL] PDF report ??

[syahrianto <sya...@ci...>]

Salam (Indonesian Greeting's  :-) )
Dear all,

Sory Friends, if my english not so good.

I'm still confused how to use latex to create pdf report. Any body can 
help me.... Thanks soo for any suggestions...

latex, n pdf perl already has installed using cpan.

How "perl -> pdf" syntax to create pdf documents: create table, line, 
alignment ...etc.

Thanks so much....

Rian

[SL] Printing checks for transfers?

[John L. <ma...@fr...>]

What's the best way to print a check to make a payment to another account?

I just recently set up check printing for AP and Vendor invoices on
voucher checks, and that much works great. But I'm not seeing how to do
this to pay off my credit card...

What am I missing?

Thanks,

-- 
John Locke
"Open Source Solutions for Small Business Problems"
published by Charles River Media, June 2004
http://www.freelock.com

Re: [SL] =?iso-8859-1?q?How_to_install_2_versions_with_different_data?= =?iso-8859-1?q?sets_on_1=09server_=3F?=

[Roy P <or...@sh...>]

On Monday 05 February 2007 10:10, Roy P wrote:
> On Monday 05 February 2007 09:56, Ashley J Gittins wrote:
> > On Tuesday 06 February 2007 00:42, Roy P wrote:
> > > When I try create a test dataset in 2.7, it tells me that the id
> > > sequence exists. I guess that the id sequence is shared between
> > > datasets ? It there an easy way to have the id sequence be unique to
> > > each dataset ? Or is there something weird with my database
> > > configuration ?
> >
> > Are you using a separate databases for each? That's the setup that works
> > fine for me with two systems.
>
> Thanks Dieter and Ashley..
>
> Hmmm.. ok then it's my config....
>
> I'm using separate datasets and SL login, but the same postgresql user.
> Are you using a different postgresql user for each one ?
>
> I've done this before in the past (using the same postgresql user) and
> never had an error before..  I must have screwed up somewhere.

Looks like i found the problem....
You can tell it's Monday... i'm not fully awake yet...

For some reason, the template1 database had a copy of the SQL-Ledger sequences 
in it. (This must have occured a long time ago on my test box)

For those who don't know why this is a problem.... When you create a new 
database.. the template1 database is automatically used as a... well.... 
template.
Therefore, in this case template1 already contained the sequences and when i 
tried to create a new dataset it failed because they already existed.


Cheers and thanks all.
Roy

Re: [SL] =?iso-8859-1?q?How_to_install_2_versions_with_different_data?= =?iso-8859-1?q?sets=09on=091=09server_=3F?=

[Roy P <or...@sh...>]

On Monday 05 February 2007 10:35, Tony Fraser wrote:
> On Mon, 2007-02-05 at 10:10 -0600, Roy P wrote:
> > I'm using separate datasets and SL login, but the same postgresql
> > user.
> > Are you using a different postgresql user for each one ?
> >
> > I've done this before in the past (using the same postgresql user) and
> > never
> > had an error before..  I must have screwed up somewhere.
>
> Sounds to me like you got an id sequence created in your template1
> database some how.

Exactly... 
Thanks Tony.
I just figured it out when your email arrived.

Cheers !

Re: [SL] How to install 2 versions with different datasets on 1 server ?

[Tony F. <to...@sy...>]

On Mon, 2007-02-05 at 10:10 -0600, Roy P wrote:
> I'm using separate datasets and SL login, but the same postgresql
> user.
> Are you using a different postgresql user for each one ?
> 
> I've done this before in the past (using the same postgresql user) and
> never 
> had an error before..  I must have screwed up somewhere.

Sounds to me like you got an id sequence created in your template1
database some how.

-- 
Tony Fraser
to...@sy...
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398

Re: [SL] =?iso-8859-1?q?How_to_install_2_versions_with_different_data?= =?iso-8859-1?q?sets_on_1=09server_=3F?=

[Roy P <or...@sh...>]

On Monday 05 February 2007 09:56, Ashley J Gittins wrote:
> On Tuesday 06 February 2007 00:42, Roy P wrote:
> > When I try create a test dataset in 2.7, it tells me that the id sequence
> > exists. I guess that the id sequence is shared between datasets ?
> > It there an easy way to have the id sequence be unique to each dataset ?
> > Or is there something weird with my database configuration ?
>
> Are you using a separate databases for each? That's the setup that works
> fine for me with two systems.

Thanks Dieter and Ashley..

Hmmm.. ok then it's my config....

I'm using separate datasets and SL login, but the same postgresql user.
Are you using a different postgresql user for each one ?

I've done this before in the past (using the same postgresql user) and never 
had an error before..  I must have screwed up somewhere.

Cheers,
Roy P

Re: [SL] How to install 2 versions with different datasets on 1 server ?

[Ashley J G. <agi...@pu...>]

On Tuesday 06 February 2007 00:42, Roy P wrote:
> When I try create a test dataset in 2.7, it tells me that the id sequence
> exists. I guess that the id sequence is shared between datasets ?
> It there an easy way to have the id sequence be unique to each dataset ?
> Or is there something weird with my database configuration ?

Are you using a separate databases for each? That's the setup that works fine 
for me with two systems.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] How to install 2 versions with different datasets on 1 server ?

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

The id's are not shared.

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Mon, 5 Feb 2007, Roy P wrote:

> Morning all !
>
> I want to install version 2.7 alongside version 2.6.
> Configuring the 2 installations in different directories with the required
> apache configuration is easy.  But.....
>
> When I try create a test dataset in 2.7, it tells me that the id sequence
> exists. I guess that the id sequence is shared between datasets ?
> It there an easy way to have the id sequence be unique to each dataset ?
> Or is there something weird with my database configuration ?
>
> Cheers,
> Roy P
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] How to install 2 versions with different datasets on 1 server ?

[Roy P <or...@sh...>]

Morning all !

I want to install version 2.7 alongside version 2.6.
Configuring the 2 installations in different directories with the required 
apache configuration is easy.  But.....

When I try create a test dataset in 2.7, it tells me that the id sequence 
exists. I guess that the id sequence is shared between datasets ?
It there an easy way to have the id sequence be unique to each dataset ?
Or is there something weird with my database configuration ?

Cheers,
Roy P

[SL] average and list price?

[Kevin B. <kb...@fr...>]

Hi ya,

This might be obvious to most but I can't see an easy explanation in my 
manual and thought I'd ask the list before sending a dumb question to 
Dieter.

I can see that the sell price is what gets charged to the customer - and 
the cost price is what I paid my supplier - this also gets used when the 
income statement is being put together to figure out the cost of the 
hardware which has been sold.

I also notice that if I buy a part from a new supplier at a different 
price then an average price is calculated and shown. There is also a 
'List Price'.

My question is - what are these prices used for?

Thanks,

Kevin

[SL] UTF8, chinese and the pound sign

[Wan L. <big...@ya...>]

i have problems printing postscript invoices with chinese customer names=0A=
where the UTF code contains a pound sign. for example,=0A=E4=BA=9E=E6=B4=B2=
=E9=87=91=E9=96=A3=0A=0Awhich became=0A=0A=E4=BA=9E=E6=B4=B2=E9=87=91=E9=96=
\pound=0A=0Ahow can i solve this problem?=0A=0Ausing 2.6.22 on windows XP r=
unning apache and postgresql.=0A=0Awan ling=0A=0A=0A=0A=0A=09=09=0A________=
____________________________________________ =0AYahoo! Singapore Answers =
=0AReal people. Real questions. Real answers. Share what you know at http:/=
/answers.yahoo.com.sg

[SL] Recurring invoices being over paid...

[Jason Q. <sql...@ja...>]

Hi All!

I have a bunch of recurring invoices which I process every month. I
have selected include payment for these invoices as they are paid by
direct debit and it's easier to deal with one or two exceptions than
manually enter the payment information by hand for each invoice.

When I click the process transactions button, everything looks like
it's working as expected. However, when I look at the invoice list I
can see that some of the invoices have had a payment ten times larger
than the invoice amount posted. Something is going weird with a
decimal place somewhere. The real puzzler is that this only happens on
about half of the invoices.

Has anybody had any experiences like this?

I am running 2.6.23 on Ubuntu with Postgres 8.1.4.

Many thanks,
Jason.

Re: [SL] Access Denied -- RESOLVED

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

On Fri, 2 Feb 2007, Paul Tammes wrote:

> did you try to use /admin.pl instead of just getting barred? Might be a
> default set to something unpractical after upgrade. Not nice, but it has
> happened before..

Paul,

   No, but I fixed the problem. For reasons I do not know, the ownerships and
permissions were incorrect. I suspected this was the case, but the fact that
I was able to log in to the upgraded system threw me. I suspect that I was
able to do so because firefox cached the information and obfuscated the
ownership/permission changes.

   The other puzzling part is that with all the upgrades I've done over the
past three or four years, this was the first time there were ownership or
permission issues. In the past I untarred the tarball in /usr/local/ and
immediately logged in to check. It always worked.

   Anyway, I will be more aware of changes at the next upgrade.

Thank you,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Access Denied

[Paul B. <pa...@jp...>]

I know it's a silly point but you have made sure that the postgres config
file wasn't over written in the upgrade??

Additionally I have also had SL lock the database after an upgrade so login
as admin and check that the data isnt locked.

Hope it helps 

Paul 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Rich
Shepard
Sent: 02 February 2007 02:25
To: sql...@li...
Subject: [SL] Access Denied

   This has me completely puzzled, and I need to run payables since it's the
beginning of the month.

   When I try to log in to SL-2.6.23 I am denied access. Just about a week
ago -- January 23rd -- I had access problems after a system upgrade and that
was tracked down to a perl module built against an obsolete library. My last
message to the thread reported the problem was solved and that I could once
again log in.

   I've not used the application since then. Nor have I made any changes to
apache, postgres, or anything else.

   /var/log/apache/access_log shows the latest attempt:

127.0.0.1 - - [01/Feb/2007:18:16:21 -0800] "POST /sql-ledger/login.pl
HTTP/1.1" 200 311

   /var/log/apache/error_log reports nothing.

   httpd and postmaster are running processes; I restarted both.

   What have I missed? If there's nothing in the httpd error log I've no
idea why I see the page that shows, "Error! Access denied."

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] salespersons

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

Michael George schreef:
> What determines which users show up in the "salesperson" list on
> invoices and customer records?
>
> I have some users who don't show up in either list, and some who show up
> on the list on invoices but don't showup on the list when
> creating/modifying customers.
>
> Very strange, I thought...
>
>   
Check the HR part, here you can tickif somebody works in say accounting 
or in sales iirc