sql-ledger-users — SQL-Ledger users

Re: [SL] HELP DATABASE CREATION PROBLEM WITH MULTIBYTE ECONCODING ASCII ON OPEN SUSE 11

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

Point 1: First install SQL-Ledger, then create the db via admin.pl, using
any encoding you fancy, in your case ascii, THEN quit sql-ledger and do the

psql my_database_name < sql_backup_2.x.x.sql

bit.Not sure about the exact command there, has been a while. It is in the
manual however.

For what it;s worth, I use opensuse 11 myself and had no problems restoring
last time round, a few months ago iirc. Just use standard tetex via yast,
the tetex-extra you mention is not traceble via rpmfind, you sure you use
that?

Point 2:  Although I strongly doubt it has anything to do with the problem,
on SuSe 11 you can install rpm made for Suse 10.3 without a problem, just
add the 10.3 repository. Or you can use the factory (bleeding edge) beta
11.1 repository. Also you could try to install a general package, normally
they are called packet_xyz_0.1.1.noarch.rpm. Just download and instaal with
yast or zypper. Last resort: get a sourrce package and do the slightly more
complex commandline routine of extracting to a subdir and then configure,
make and make install. I yet have to find something I can not install under
Suse, but it os sometimes a bit more then point and click. .

2008/10/8 Walter López <wal...@ya...>

> Hello, rencently  i been setup SL on Opensuse 11 withouth problems, but whe
> i try to create a dataset with miltibyte econding ASCII, y have problems,
> next error are displayed:
>
> Database xxx dont exist
>
> Y try to create the same dataset with utf 8, succesfully, but the utf8, but
> i need to solve the problem because i have a backups made on ascii dataset.
>
> I probe on ubuntu 8.10 the problem are similar to opensuse but i fix it
> installin tetex-extra, but this rpm package dont exist for opensuse 11
>
> Please helpme.
>
> Best regards
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] HELP DATABASE CREATION PROBLEM WITH MULTIBYTE ECONCODING ASCII ON OPEN SUSE 11

[Walter L. <wal...@ya...>]

Hello, rencently  i been setup SL on Opensuse 11 withouth problems, but whe i try to create a dataset with miltibyte econding ASCII, y have problems, next error are displayed:

Database xxx dont exist

Y try to create the same dataset with utf 8, succesfully, but the utf8, but i need to solve the problem because i have a backups made on ascii dataset.

I probe on ubuntu 8.10 the problem are similar to opensuse but i fix it installin tetex-extra, but this rpm package dont exist for opensuse 11

Please helpme.

Best regards

Re: [SL] Assembly : BOM Qty On Hand not updated

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

On Fri, Oct 3, 2008 at 7:20 AM, Akhmad Daniel Sembiring
<da...@vi...> wrote:
> Actually I've done that step before, but the effect was the part's Qty
> on Hand becomes blank.

As Michael pointed out, this means that parts qty became zero as the
result of 'building' the assembly.

Also make sure that you run the 'Stock Assembly' process only once.
One short coming of the build-in stock assembly process is that there
is no log maintained for any stock assembly operation. This might
cause trouble if you inadvertently run 'Stock Assembly' process more
than required number of times.

I have a patch which logs each Stock assembly operation along with a
new report to list the activity. Contact me off-list to get this free
patch.

> For this particular assembly, in the real situation, I do not need to
> stock it, i.e. I will assembly it when there's
> a sale on that assembly.

You have to run the stock assembly process in advance before selling
the assembly. But with a simple API call in invoice post procedure, it
should be possible to run the 'Stock Assembly' process for the
assemblies being sold.

-- 
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/

--

Re: [SL] Assembly : BOM Qty On Hand not updated

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

Blank means zero which, if they are all embedded in assemblies now,  
is correct.


Thanks,

Michael Hasse
Itwerx
206-850-1496
http://www.itwerx.net/

**********************************
If our service is not 100% satisfactory please tell us!
If it is 100% please tell others!
**********************************

On Oct 2, 2008, at 7:20 PM, Akhmad Daniel Sembiring wrote:

> Armaghan Saqib wrote:
>
>>> 1. I added an Assembly which contains 0.1 kg of Part A, and 0.1  
>>> kg of Part B
>>> 2. I purchased 100 kg of Part A and 100 kg of Part B through  
>>> Vendor Invoice
>>>   and the Qty On Hand of both parts are 100 kg
>>>
>>>
>>
>> At this point you need to use the 'Goods & Services--Stock Assembly'
>> menu option to 'build' your assemblies. This option removes  
>> individual
>> components from stock and adds the assemblies which you can sell as
>> you are doing in step 3.
>>
>> This way stock levels for components and assemblies will be correct.
>>
>> Let me know if I am not clear.
>>
>>
>>
> Hi Saqib, it's clear and thanks.
> Actually I've done that step before, but the effect was the part's Qty
> on Hand becomes blank.
> We can see that in the Parts Report page and the Edit Part page.  
> Was it
> a bug ?
>
> For this particular assembly, in the real situation, I do not need to
> stock it, i.e. I will assembly it when there's
> a sale on that assembly.
>
> I've tried the same steps on the SQL ledger online demo as well and  
> the
> result was the same.
>
> Please help and thanks.
>
> -- 
> -Daniel-
> http://www.vitraining.com
> http://akhdaniel.wordpress.com
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Assembly : BOM Qty On Hand not updated

[Akhmad D. S. <da...@vi...>]

Armaghan Saqib wrote:

>>1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg of Part B
>>2. I purchased 100 kg of Part A and 100 kg of Part B through Vendor Invoice
>>   and the Qty On Hand of both parts are 100 kg
>>    
>>
>
>At this point you need to use the 'Goods & Services--Stock Assembly'
>menu option to 'build' your assemblies. This option removes individual
>components from stock and adds the assemblies which you can sell as
>you are doing in step 3.
>
>This way stock levels for components and assemblies will be correct.
>
>Let me know if I am not clear.
>
>  
>
Hi Saqib, it's clear and thanks.
Actually I've done that step before, but the effect was the part's Qty 
on Hand becomes blank.
We can see that in the Parts Report page and the Edit Part page. Was it 
a bug ?

For this particular assembly, in the real situation, I do not need to 
stock it, i.e. I will assembly it when there's
a sale on that assembly.

I've tried the same steps on the SQL ledger online demo as well and the 
result was the same.

Please help and thanks.

-- 
-Daniel-
http://www.vitraining.com  
http://akhdaniel.wordpress.com

Re: [SL] Assembly : BOM Qty On Hand not updated

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

Also check your Precision setting in the System Defaults page.


Thanks,

Michael


On Oct 1, 2008, at 6:32 PM, Armaghan Saqib wrote:

>> 1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg  
>> of Part B
>> 2. I purchased 100 kg of Part A and 100 kg of Part B through  
>> Vendor Invoice
>>    and the Qty On Hand of both parts are 100 kg
>
> At this point you need to use the 'Goods & Services--Stock Assembly'
> menu option to 'build' your assemblies. This option removes individual
> components from stock and adds the assemblies which you can sell as
> you are doing in step 3.
>
> This way stock levels for components and assemblies will be correct.
>
> Let me know if I am not clear.
>
> -- 
> * Purpose-built SQL-Ledger Hosting. Free trial.
> * SQL-Ledger Documentation Wiki
> * SQL-Ledger VMware Appliance. Free download.
> http://www.ledger123.com/
>
> --
>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Assembly : BOM Qty On Hand not updated

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

> 1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg of Part B
> 2. I purchased 100 kg of Part A and 100 kg of Part B through Vendor Invoice
>    and the Qty On Hand of both parts are 100 kg

At this point you need to use the 'Goods & Services--Stock Assembly'
menu option to 'build' your assemblies. This option removes individual
components from stock and adds the assemblies which you can sell as
you are doing in step 3.

This way stock levels for components and assemblies will be correct.

Let me know if I am not clear.

-- 
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/

--

[SL] Assembly : BOM Qty On Hand not updated

[Akhmad D. S. <da...@vi...>]

Hi guys,
I'm using 2.8.17.

1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg of Part B
2. I purchased 100 kg of Part A and 100 kg of Part B through Vendor Invoice
    and the Qty On Hand of both parts are 100 kg
3. I created Sales Invoice for 100 units of the Assembly and posted it
4. Logically the Qty on Hand of Part A will be decreased by 0.1 * 100 = 
10 kg
    and updated to 90 kg, as well as Part B.

But, I did not see any updates in both Part A and Part B Qty On Hand..
Did I miss something here?

Thanks

-- 
-Daniel-
http://www.vitraining.com  
http://akhdaniel.wordpress.com

Re: [SL] Simplest way to move SL from PC to Virtual PC?

[Andrew @ A. L. <atm...@km...>]

> Having just gone through some of that here I can say that 
> VMware is by far the most mature product on the market.  As 
> for migration strategies, that depends a bit on whether you 
> want to take the opportunity to clean things up at the same 
> time or not.

I would be cleaning things up as I go...  I would like to get m0n0wall and
SL on the same box...(Two diff, images as m0n0 is its own little gig)  So
for the SL what Distro should I go with, or should I just grab the VM image
from the 'other guys'  :)

Re: [SL] Simplest way to move SL from PC to Virtual PC?

[Leho K. <le...@da...>]

Armaghan Saqib wrote:

> On Tue, Sep 30, 2008 at 12:09 PM, Leho Kraav <le...@da...> wrote:

>> Don't make a visualization decision without checking out VirtualBox.
> 
> I had a look at Virtualbox when I was building SL virtual appliance. I
> remember I could not access virtual machine with NAT. May be I did not
> spend enough time. I shall give it try again (esp. when 2.0 is out
> with new features)
> 
> On a side note, I am planning to develop a new virtual appliance using
> some Linux flavor (not everybody is comfortable with FreeBSD).
> 
> Which will be the preferred Linux distro on virtual machine for you?


Heh "visualization"... "virtualization" obviously.

Yes, VB NAT has not had a GUI to administer reverse network access, it
(port forwarding) can be done with commandline, instructions are in the
PDF manual. Might be better to use Host Interface Networking until a
decent GUI is done, if security is not a huge issue.

I run Gentoo for all my Linux needs. Portage is a very strong system and
package mgmt implementation, IMHO.

Re: [SL] Simplest way to move SL from PC to Virtual PC?

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

On Tue, Sep 30, 2008 at 12:09 PM, Leho Kraav <le...@da...> wrote:
> Don't make a visualization decision without checking out VirtualBox.

I had a look at Virtualbox when I was building SL virtual appliance. I
remember I could not access virtual machine with NAT. May be I did not
spend enough time. I shall give it try again (esp. when 2.0 is out
with new features)

On a side note, I am planning to develop a new virtual appliance using
some Linux flavor (not everybody is comfortable with FreeBSD).

Which will be the preferred Linux distro on virtual machine for you?

Regards
Armaghan

--
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/
--

Re: [SL] Simplest way to move SL from PC to Virtual PC?

[Leho K. <le...@da...>]

Don't make a virtualization decision without checking out VirtualBox.

Michael Hasse wrote:

> Having just gone through some of that here I can say that VMware is  
> by far the most mature product on the market.  As for migration  
> strategies, that depends a bit on whether you want to take the  
> opportunity to clean things up at the same time or not.
>     We decided to go the cleanup route for most of our servers but we  
> did image a couple directly.  The Windows boxes came across just fine  
> by mirroring them to drive images presented via iSCSI and Ghost  
> worked pretty well for the Linux boxes.
>     Surprisingly, the Windows migrations actually seemed a bit  
> easier.  However, when a Windows image first boots VMware creates a  
> settings file for it and will ask you if it was a copy of another  
> image - be sure to say No!  Otherwise it will "conveniently" strip  
> out your key and you'll have to re-enter the key and re-register w/MS.

Re: [SL] Simplest way to move SL from PC to Virtual PC?

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

Having just gone through some of that here I can say that VMware is  
by far the most mature product on the market.  As for migration  
strategies, that depends a bit on whether you want to take the  
opportunity to clean things up at the same time or not.
    We decided to go the cleanup route for most of our servers but we  
did image a couple directly.  The Windows boxes came across just fine  
by mirroring them to drive images presented via iSCSI and Ghost  
worked pretty well for the Linux boxes.
    Surprisingly, the Windows migrations actually seemed a bit  
easier.  However, when a Windows image first boots VMware creates a  
settings file for it and will ask you if it was a copy of another  
image - be sure to say No!  Otherwise it will "conveniently" strip  
out your key and you'll have to re-enter the key and re-register w/MS.


Good luck!

Michael

On Sep 29, 2008, at 9:38 PM, Andrew @ ATM Logic wrote:

> I am trying to cut back on my servers (Running about 9 hardware  
> servers now,
> and want to get down to about 3 or so)
>
> My SL sits on a box that is also my webserver and does some routing  
> and
> firewall duties (SME Server 7.xx)
>
> I have MS virtual Server/PC and/or VMware and would like to run SL  
> from
> another server that only has backup duties at night (totally open  
> in the
> day)
>
> I also have a SBS server and a Terminal server, Trixbox, m0n0Wall  
> and am
> looking to drop the SME and move to Untangle.
>
> Anyhow, looking for simple and painless move...  What would you  
> recommend?
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Simplest way to move SL from PC to Virtual PC?

[Andrew @ A. L. <atm...@km...>]

I am trying to cut back on my servers (Running about 9 hardware servers now,
and want to get down to about 3 or so)
 
My SL sits on a box that is also my webserver and does some routing and
firewall duties (SME Server 7.xx)
 
I have MS virtual Server/PC and/or VMware and would like to run SL from
another server that only has backup duties at night (totally open in the
day)
 
I also have a SBS server and a Terminal server, Trixbox, m0n0Wall and am
looking to drop the SME and move to Untangle.
 
Anyhow, looking for simple and painless move...  What would you recommend?

[SL] Warning - perl.i386 4:5.8.8-15.el5_2.1 for Centos 5 appears to have a bug

[mark <ma...@in...>]

perl.i386 4:5.8.8-15.el5_2.1

This package seems to cause errors in sql-ledger.

Error!

Not a HASH reference at SL/OE.pm line 1295.
Attempt to free unreferenced scalar: SV 0x8daf9a0, Perl interpreter:
0x85cd008 at SL/OE.pm line 1295.

To debug this we changed the following, printed the invoice/quote etc.
Then downgraded the perl version to perl.i386 4:5.8.8-10.el5_2.3

diff -u b_OE.pm OE.pm
--- b_OE.pm     2008-09-19 14:07:29.000000000 +1200
+++ OE.pm       2008-09-19 14:53:39.000000000 +1200
@@ -928,6 +928,12 @@
sub order_details {
  my ($self, $myconfig, $form) = @_;

+  use Data::Dumper;
+  open(DGB, ">> /tmp/sldbg.log") || die('perl sucks');
+  printf(DGB "***** FORM (LINE=%d):",__LINE__);
+  print DGB Dumper($form);
+  print DGB "\n\n";
+
  # connect to database
  my $dbh = $form->dbconnect($myconfig);
  my $query;
@@ -1096,6 +1102,9 @@
         push(@{ $form->{description} }, $item->[2]);
         for (qw(taxrates runningnumber number sku qty ship unit bin
serialnumber requiredate projectnumber sellprice listprice netprice
discount discountrate linetotal weight itemnotes)) { push(@{ $form->{$_}
}, "") }
         push(@{ $form->{lineitems} }, { amount => 0, tax => 0 });
+  printf(DGB "***** FORM (LINE=%d): ",__LINE__);
+  print DGB Dumper($form);
+  print DGB "\n\n";
       }
      }
    }
@@ -1208,6 +1217,9 @@
      }

      push(@{ $form->{lineitems} }, { amount => $linetotal, tax =>
$form->round_amount($tax, 2) });
+  printf(DGB "***** FORM (LINE=%d): ",__LINE__);
+  print DGB Dumper($form);
+  print DGB "\n\n";
      push(@{ $form->{taxrates} }, join ' ', sort { $a <=> $b } @taxrates);

      if ($form->{"assembly_$i"}) {
@@ -1237,6 +1249,9 @@
           push(@{ $form->{description} },
$form->{groupsubtotaldescription});

           push(@{ $form->{lineitems} }, { amount => 0, tax => 0 });
+  printf(DGB "***** FORM (LINE=%d): ",__LINE__);
+  print DGB Dumper($form);
+  print DGB "\n\n";

           if ($form->{groupsubtotaldescription} ne "") {
             push(@{ $form->{linetotal} },
$form->format_amount($myconfig, $subtotal, 2));
@@ -1264,6 +1279,9 @@
           push(@{ $form->{description} },
$form->{groupsubtotaldescription});
           push(@{ $form->{linetotal} }, $form->format_amount($myconfig,
$subtotal, 2));
           push(@{ $form->{lineitems} }, { amount => 0, tax => 0 });
+  printf(DGB "***** FORM (LINE=%d): ",__LINE__);
+  print DGB Dumper($form);
+  print DGB "\n\n";
         }
       }
      }
@@ -1291,6 +1309,17 @@

  # adjust taxes for lineitems
  my $total = 0;
+
+  print DGB @{ $form->{lineitems} };
+  print DGB "\n";
+  for (@{ $form->{lineitems} }) {
+    print DGB Dumper($_);
+    #if (ref($_) eq 'SCALAR') {
+    #  print DGB "ref: ".ref($_).": $_\n";
+    #}
+  }
+  print DGB "\n\n";
+
  for (@{ $form->{lineitems} }) {
    $total += $_->{tax};
  }


Output:

BAD:

***** FORM (LINE=1220): $VAR1 = bless( {
<snip>
                'runningnumber_1' => '1',
                'lineitems' => [
                                 {
                                   'amount' => '2396.06',
                                   'tax' => '299.51'
                                 }
                               ],
<snip>
***** FORM (LINE=1220): $VAR1 = bless( {
<snip>
                'runningnumber_1' => '1',
                'lineitems' => [
                                 \$VAR1->{'runningnumber'}[1],
                                 {
                                   'amount' => '9040.85',
                                   'tax' => '1130.11'
                                 }
                               ],
<snip>
20/09/08 3:06 PM

CORRECT:

***** FORM (LINE=1220): $VAR1 = bless( {
<snip>
                'runningnumber_1' => '1',
                'lineitems' => [
                                 {
                                   'amount' => '2396.06',
                                   'tax' => '299.51'
                                 }
                               ],
<snip>
***** FORM (LINE=1220): $VAR1 = bless( {
<snip>
                'runningnumber_1' => '1',
                'lineitems' => [
                                 {
                                   'amount' => '2396.06',
                                   'tax' => '299.51'
                                 },
                                 {
                                   'amount' => '9040.85',
                                   'tax' => '1130.11'
                                 }
                               ],
<snip>

Re: [SL] Customer Manager field missing?

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

We are using those currently but I don't think anyone is really  
depending on them so we might be able to repurpose them.  Seems a  
little odd/surprising that SL doesn't have any generic "Custom1,  
Custom2" etc fields.  That's a feature common to most database  
applications that need to track customer info.


Thanks,

Michael


On Sep 14, 2008, at 7:36 AM, Paul Tammes wrote:

> Are you using the project and department fields? May be a nice  
> workaround
> otherwise
>
> 2008/9/13 Michael Hasse <mh...@it...>
>
>> Never mind, helps to read the manual.  The Manager field is set per
>> user, generally for commission purposes.
>>    We have a similar situation but there doesn't seem to be an
>> appropriate field for engineers earning commission.  (Each
>> salesperson works with several engineers and vice-versa, so the top-
>> down Manager method won't work).
>>    Assuming we'll just need to track this in a separate field/table/
>> db - unless someone else has another solution?  There don't seem to
>> be any misc info fields other than the Notes which we already use for
>> other things.
>>
>>
>> Thanks,
>>
>> Michael
>>
>>
>> On Sep 11, 2008, at 11:15 AM, Michael Hasse wrote:
>>
>>> Don't see any checkbox for that in the user settings under admin.pl
>>>     And the user I'm trying to have change this field is an
>>> Administrator with full rights to everything.
>>>
>>>
>>> Thanks,
>>>
>>> Michael
>>>
>>>
>>> On Sep 11, 2008, at 5:44 AM, Paul Tammes wrote:
>>>
>>>> Did you check the boxes for 'is able to' a lot of tasks? In the
>>>> admin login
>>>> iirc.
>>>>  I can imagine some sort of task division is in place. One would
>>>> not want
>>>> the shop personel to be able to asign their own managers, or worse,
>>>> themselves as manager for say relatives and friends, and start  
>>>> giving
>>>> trevates or whatever..
>>>>
>>>> 2008/9/11 Michael Hasse <mh...@it...>
>>>>
>>>>> Hi Everybody,
>>>>>
>>>>>    Was doing a search the other day and noticed there is a Manager
>>>>> field for customers now, (maybe always?).  At any rate, we  
>>>>> could use
>>>>> that right about now as we are starting to need to "assign"
>>>>> engineers
>>>>> in addition to sales people, and that field would work just  
>>>>> fine for
>>>>> that purpose.
>>>>>    Only problem is that when you edit a customer the Manager field
>>>>> isn't visible.  Are we just missing something obvious...?
>>>>>
>>>>>
>>>>> Thanks!
>>>>>
>>>>> Michael
>>>>>
>>>>> ------------------------------------------------------------------ 
>>>>> --
>>>>> -
>>>>> ----
>>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>>>> challenge
>>>>> Build the coolest Linux based applications with Moblin SDK & win
>>>>> great
>>>>> prizes
>>>>> Grand prize is a trip for two to an Open Source event anywhere in
>>>>> the world
>>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>>>> _______________________________________________
>>>>> sql-ledger-users mailing list
>>>>> sql...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>>
>>>>>
>>>> ------------------------------------------------------------------- 
>>>> --
>>>> -
>>>> ---
>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>>> challenge
>>>> Build the coolest Linux based applications with Moblin SDK & win
>>>> great prizes
>>>> Grand prize is a trip for two to an Open Source event anywhere in
>>>> the world
>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>> -------------------------------------------------------------------- 
>>> --
>>> ---
>>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>> challenge
>>> Build the coolest Linux based applications with Moblin SDK & win
>>> great prizes
>>> Grand prize is a trip for two to an Open Source event anywhere in
>>> the world
>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win  
>> great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in  
>> the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Customer Manager field missing?

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

Are you using the project and department fields? May be a nice workaround
otherwise

2008/9/13 Michael Hasse <mh...@it...>

> Never mind, helps to read the manual.  The Manager field is set per
> user, generally for commission purposes.
>    We have a similar situation but there doesn't seem to be an
> appropriate field for engineers earning commission.  (Each
> salesperson works with several engineers and vice-versa, so the top-
> down Manager method won't work).
>    Assuming we'll just need to track this in a separate field/table/
> db - unless someone else has another solution?  There don't seem to
> be any misc info fields other than the Notes which we already use for
> other things.
>
>
> Thanks,
>
> Michael
>
>
> On Sep 11, 2008, at 11:15 AM, Michael Hasse wrote:
>
> > Don't see any checkbox for that in the user settings under admin.pl
> >     And the user I'm trying to have change this field is an
> > Administrator with full rights to everything.
> >
> >
> > Thanks,
> >
> > Michael
> >
> >
> > On Sep 11, 2008, at 5:44 AM, Paul Tammes wrote:
> >
> >> Did you check the boxes for 'is able to' a lot of tasks? In the
> >> admin login
> >> iirc.
> >>  I can imagine some sort of task division is in place. One would
> >> not want
> >> the shop personel to be able to asign their own managers, or worse,
> >> themselves as manager for say relatives and friends, and start giving
> >> trevates or whatever..
> >>
> >> 2008/9/11 Michael Hasse <mh...@it...>
> >>
> >>> Hi Everybody,
> >>>
> >>>    Was doing a search the other day and noticed there is a Manager
> >>> field for customers now, (maybe always?).  At any rate, we could use
> >>> that right about now as we are starting to need to "assign"
> >>> engineers
> >>> in addition to sales people, and that field would work just fine for
> >>> that purpose.
> >>>    Only problem is that when you edit a customer the Manager field
> >>> isn't visible.  Are we just missing something obvious...?
> >>>
> >>>
> >>> Thanks!
> >>>
> >>> Michael
> >>>
> >>> --------------------------------------------------------------------
> >>> -
> >>> ----
> >>> This SF.Net email is sponsored by the Moblin Your Move Developer's
> >>> challenge
> >>> Build the coolest Linux based applications with Moblin SDK & win
> >>> great
> >>> prizes
> >>> Grand prize is a trip for two to an Open Source event anywhere in
> >>> the world
> >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>>
> >>>
> >> ---------------------------------------------------------------------
> >> -
> >> ---
> >> This SF.Net email is sponsored by the Moblin Your Move Developer's
> >> challenge
> >> Build the coolest Linux based applications with Moblin SDK & win
> >> great prizes
> >> Grand prize is a trip for two to an Open Source event anywhere in
> >> the world
> >> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> > ----------------------------------------------------------------------
> > ---
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge
> > Build the coolest Linux based applications with Moblin SDK & win
> > great prizes
> > Grand prize is a trip for two to an Open Source event anywhere in
> > the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

Re: [SL] Customer Manager field missing?

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

Never mind, helps to read the manual.  The Manager field is set per  
user, generally for commission purposes.
    We have a similar situation but there doesn't seem to be an  
appropriate field for engineers earning commission.  (Each  
salesperson works with several engineers and vice-versa, so the top- 
down Manager method won't work).
    Assuming we'll just need to track this in a separate field/table/ 
db - unless someone else has another solution?  There don't seem to  
be any misc info fields other than the Notes which we already use for  
other things.


Thanks,

Michael


On Sep 11, 2008, at 11:15 AM, Michael Hasse wrote:

> Don't see any checkbox for that in the user settings under admin.pl
>     And the user I'm trying to have change this field is an
> Administrator with full rights to everything.
>
>
> Thanks,
>
> Michael
>
>
> On Sep 11, 2008, at 5:44 AM, Paul Tammes wrote:
>
>> Did you check the boxes for 'is able to' a lot of tasks? In the
>> admin login
>> iirc.
>>  I can imagine some sort of task division is in place. One would
>> not want
>> the shop personel to be able to asign their own managers, or worse,
>> themselves as manager for say relatives and friends, and start giving
>> trevates or whatever..
>>
>> 2008/9/11 Michael Hasse <mh...@it...>
>>
>>> Hi Everybody,
>>>
>>>    Was doing a search the other day and noticed there is a Manager
>>> field for customers now, (maybe always?).  At any rate, we could use
>>> that right about now as we are starting to need to "assign"  
>>> engineers
>>> in addition to sales people, and that field would work just fine for
>>> that purpose.
>>>    Only problem is that when you edit a customer the Manager field
>>> isn't visible.  Are we just missing something obvious...?
>>>
>>>
>>> Thanks!
>>>
>>> Michael
>>>
>>> -------------------------------------------------------------------- 
>>> -
>>> ----
>>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>>> challenge
>>> Build the coolest Linux based applications with Moblin SDK & win
>>> great
>>> prizes
>>> Grand prize is a trip for two to an Open Source event anywhere in
>>> the world
>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>> --------------------------------------------------------------------- 
>> -
>> ---
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win
>> great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in
>> the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Customer Manager field missing?

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

Don't see any checkbox for that in the user settings under admin.pl
    And the user I'm trying to have change this field is an  
Administrator with full rights to everything.


Thanks,

Michael


On Sep 11, 2008, at 5:44 AM, Paul Tammes wrote:

> Did you check the boxes for 'is able to' a lot of tasks? In the  
> admin login
> iirc.
>  I can imagine some sort of task division is in place. One would  
> not want
> the shop personel to be able to asign their own managers, or worse,
> themselves as manager for say relatives and friends, and start giving
> trevates or whatever..
>
> 2008/9/11 Michael Hasse <mh...@it...>
>
>> Hi Everybody,
>>
>>    Was doing a search the other day and noticed there is a Manager
>> field for customers now, (maybe always?).  At any rate, we could use
>> that right about now as we are starting to need to "assign" engineers
>> in addition to sales people, and that field would work just fine for
>> that purpose.
>>    Only problem is that when you edit a customer the Manager field
>> isn't visible.  Are we just missing something obvious...?
>>
>>
>> Thanks!
>>
>> Michael
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win  
>> great
>> prizes
>> Grand prize is a trip for two to an Open Source event anywhere in  
>> the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Customer Manager field missing?

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

Did you check the boxes for 'is able to' a lot of tasks? In the admin login
iirc.
 I can imagine some sort of task division is in place. One would not want
the shop personel to be able to asign their own managers, or worse,
themselves as manager for say relatives and friends, and start giving
trevates or whatever..

2008/9/11 Michael Hasse <mh...@it...>

> Hi Everybody,
>
>    Was doing a search the other day and noticed there is a Manager
> field for customers now, (maybe always?).  At any rate, we could use
> that right about now as we are starting to need to "assign" engineers
> in addition to sales people, and that field would work just fine for
> that purpose.
>    Only problem is that when you edit a customer the Manager field
> isn't visible.  Are we just missing something obvious...?
>
>
> Thanks!
>
> Michael
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] Customer Manager field missing?

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

Hi Everybody,

    Was doing a search the other day and noticed there is a Manager  
field for customers now, (maybe always?).  At any rate, we could use  
that right about now as we are starting to need to "assign" engineers  
in addition to sales people, and that field would work just fine for  
that purpose.
    Only problem is that when you edit a customer the Manager field  
isn't visible.  Are we just missing something obvious...?


Thanks!

Michael

[SL] Google Chrome

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

Check out Google Chrome

http://www.google.com/googlebooks/chrome

It is a nice comic-book-style presentation of the difficulties and
solutions offered by browser developers to Web Apps (sql-ledger).

Bob G

Re: [SL] Quirk (Bug?) in 2.8.17

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

On Fri, 29 Aug 2008, Bob Gustafson wrote:

> Did you try to select a printer first?

   Of course! :-) A) there's one there by default (the physical laser
printer) and B) I had just changed that to 'screen.'

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] Quirk (Bug?) in 2.8.17

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

Did you try to select a printer first?

On Wed, 2008-08-27 at 10:33 -0700, Rich Shepard wrote:
> I prepared a sales invoice this morning. I selected 'screen' as the printer
> and, just to try something different, selected 'print and post' rather than
> my usual 'print' selection. An error page displayed telling me to select a
> printer.
> 
>    Printing to screen (actually, to disk as a PostScript file that I then run
> through ps2pdf) followed by posting the transaction worked as it always has
> before, but the one-click/two actions did not work.
> 
>    Thought to pass this on, but it's not a high priority for fixing as far as
> I'm concerned.
> 
> Rich
> 

[SL] Quirk (Bug?) in 2.8.17

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

   I prepared a sales invoice this morning. I selected 'screen' as the printer
and, just to try something different, selected 'print and post' rather than
my usual 'print' selection. An error page displayed telling me to select a
printer.

   Printing to screen (actually, to disk as a PostScript file that I then run
through ps2pdf) followed by posting the transaction worked as it always has
before, but the one-click/two actions did not work.

   Thought to pass this on, but it's not a high priority for fixing as far as
I'm concerned.

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