sql-ledger-users — SQL-Ledger users

Re: [SL] Trouble entering unicode characters

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

Stuart Luppescu schrieb:
> Where does this directory go?

The paths are:
	/usr/local/sql-ledger/locale/
for the language folders and
	/usr/local/sql-ledger/templates/<name of your folder>/
for your templates.

> Also, do I need to restart services after I do this?

No, you don't have to.

Re: [SL] Trouble entering unicode characters

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

Bernd Plagge schrieb:
> First, your system must be set to Unicode...

Thanks to Bernd. His infos should solve your input problems (and helped 
me a lot, too).
In detail, do this:
- Create a directory "en_utf"
- Copy from ca_en the file "all", "LANGUAGE" and "locales.pl"
- LANGUAGE: replace "English/Canada" with "English (UTF-8)"
- all: Insert the line "$self{charset} = 'UTF-8';" and save it as 
unicode file
- run "perl locales.pl"
- in the admin interface, change the language of your user to "English 
(UTF-8)"

Now about printing:
Make a backup copy of your templates. Edit them and replace the line
	"\usepackage[latin1]{inputenc}"
with
	"\usepackage[utf8]{inputenc}"
Save them in unicode format. As long as the templates consist only of 
standard ASCII characters, you shouldn't have to edit anything else.
Like this I was able to enter French (é à è), German (ä ö ü) and 
Hungarian characters (ű ő ó í) and print them in the same document; so 
unicode really works with the correct set up. :)

Re: [SL] Trouble entering unicode characters

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

On 金, 2008-02-15 at 17:49 +0900, Bernd Plagge wrote:
> First, your system must be set to Unicode.
> Seems that you're in the US. So, you need a directory called
> 'locale/en_utf' containing at least a file called 'all'. At the top of
> the file place a line like:
> 
>   $self{charset} = 'UTF-8';

Where does this directory go? I have a /usr/lib/locale/en_US.utf8
directory with all the LC_* files in it. Do I put it there?

Also, do I need to restart services after I do this?

Thanks.
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r3                
<Mongoose> knghtbrd: and the meek shall inherit
 k-mart 
 
 
 

[SL] Trouble entering unicode characters

[Bernd P. <bp...@ch...>]

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

On Thu, 14 Feb 2008 23:57:13 -0800
sql...@li... wrote:

> Message: 8
> Date: Thu, 07 Feb 2008 13:19:12 -0600
> From: Stuart Luppescu <sl...@cc...>
> Subject: [SL] Trouble entering unicode characters
> To: sql...@li...
> Message-ID: <120...@mu...>
> Content-Type: text/plain; charset=UTF-8
> 
> Hello, We have customers with accented characters such as ? in their
> names, but when I try to enter them as, for example, u+00e9 I get this
> error message:
> 
> DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding
> "UNICODE": 0xe9272c
> 
> I'm running SQL Ledger 2.6.22 on Linux with Postgres 8.0.13. Thanks in
> advance for any help.
> -- 
> Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
> University of Chicago -=- CCSR 
> ???????? -=-    Kernel 2.6.23-gentoo-r3                
> The wise man seeks everything in himself; the
>  ignorant man tries to get everything from somebody
>  else. 
>  
>  

First, your system must be set to Unicode.
Seems that you're in the US. So, you need a directory called
'locale/en_utf' containing at least a file called 'all'. At the top of
the file place a line like:

  $self{charset} = 'UTF-8';

This should enable you to enter Unicode characters.
Then for printing the fonts you installed must include any special
character you might want to use.
There shouldn't be a problem for French characters though.

Regards,
Bernd



- -- 
プラゲ ベェアント - Bernd Plagge
ファースト・チョイス・インターネット(有)
First Choice Internet Ltd., Tokyo
Tel. 03-4500-7799
Fax. 03-4400-3723
mail: bp...@ch...
url: http://www.choicenet.ne.jp
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHtVIOpYU8M8PbPV4RAuK0AJ4uhY9B49psdcFqMYHWufhrf0aLNwCfbGp8
t8dJkwouFsP2Ijl7YDzLjUQ=
=6gvD
-----END PGP SIGNATURE-----

Re: [SL] BOM

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

Thnx guys :)

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Paul
Tammes
Sent: 14 February 2008 09:49 AM
To: sql...@li...
Subject: Re: [SL] BOM

Sure, then later use articles - stock treport to see how much is in stock.
You may even disassemble assemblies back to spare parts if you should want
to ;-)

2008/2/13, Michael Hasse <mh...@it...>:
>
> I believe Paul's reply below (the [Ontopic] section) contains the
> answer.  Haven't tried it myself but it sounds good!
>     Set up your parts to have all those details then use Assemblies
> to group the parts as you please and a Sales Order with the Assembly
> to get the actual output.
>
>
> Thanks,
>
>
> Michael
>
>
>
> On Feb 13, 2008, at 6:04 AM, J.M. Jersey Miszczyk wrote:
>
> > Sorry guys... misunderstanding. Imagine:
> > I get the order, multiple instances of the various assemblies. Now
> > I want to
> > make (for myself only) a list of all the parts including
> > quantities, last
> > prices and suppliers. Is it possible?
> >
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On Behalf
> > Of Michael
> > Hasse
> > Sent: 13 February 2008 09:09 AM
> > To: sql...@li...
> > Subject: Re: [SL] BOM
> >
> > Re [Off Topic] I don't know about NL and ZA but in the US most
> > distributors won't sell to "end users".  Also, (continuing to play
> > Devil's advocate :), in the US some classified military contracts
> > require the complete supply chain to be detailed.  Not to mention I
> > could see where a detailed BOM might be handy just for training
> > purposes...
> >
> >
> > Thanks,
> >
> > Michael
> >
> >
> > On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote:
> >
> >> [Off Topic]
> >>
> >> Why would you want to do that? So the customer can order parts and
> >> assemble
> >> himself next time?
> >> Use supplier name, so the customer can cut you out as middleman?
> >> Seems not
> >> the brightest of plans..
> >>
> >> [On Topic}
> >>
> >> Use make parts, use all name, article number and supplier info you
> >> like in
> >> part name.
> >> Then use make assembly and make a sales order for the assembly.
> >>
> >> Alternatively, it., if we are talking consultancy, make one article
> >> assembly
> >> with 5000 lines of text info related to it.
> >>
> >>
> >> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
> >>>
> >>> Hi all,
> >>>
> >>> How would one go about creating Bill of Materials from a sales
> >>> order. When
> >>> you want to invoice out assemblies and get detailed list of
> >>> components
> >>> with
> >>> suppliers names.
> >>>
> >>> Best regards
> >>> "Jersey"
> >>>
> >>>
> >>> --------------------------------------------------------------------
> >>> -
> >>> ----
> >>> 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
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date:
> > 2/12/2008
> > 3:20 PM
> >
> >
> >
> > ----------------------------------------------------------------------
> > ---
> > 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


-- 
No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.20.4/1277 - Release Date: 2/13/2008
8:00 PM

Re: [SL] Trouble entering unicode characters

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

Stuart Luppescu schrieb:
> I would, but I don't know how to enter such characters. I can use my
> input method editor (scim) to input unicode directly, but I don't know
> how to enter Latin1.

I hope I understand correctly that you work on a Linux client and use 
Scim to enter text into the web browser. So maybe the HTTP request isn't 
sent in the correct charset to the server. I'm not sure about that, but 
I got similar error messages when I tried to restore a Latin1 backup 
into a Unicode database. I hope an SQL-Ledger insider knows more.
(Me, I've installed SQL-Ledger on OpenSUSE, but work on a Windows 
client. Because I live in Switzerland, I'm lucky to have the French 
characters on my keyboard. For other languages I just switch the 
keyboard definition, on Linux too, and never had troubles with that. If 
you switch to Swiss-French layout, press ";" for "é", "'" for "à" and 
"[" for "è".)

The other problem to consider is how you can print unicode characters to 
PDF and postscript. That's a LaTeX problem that I was not yet able to 
solve. Because of that I created a Latin1 database after a few tests 
with unicode.
At your place I would connect a Windows client, enter some French words 
and check if your templates work properly, before you use too many time 
in editing your database.

Re: [SL] Trouble entering unicode characters

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

On 木, 2008-02-14 at 20:00 +0100, "Rolf Stöckli (tokon)" wrote:
> 1. Are you sure your database supports unicode? Log in with pqsl to your 
> db and type "show client_encoding;".

Here's what I get:

show client_encoding;
 client_encoding 
-----------------
 UNICODE
(1 row)


> 2. I made some tests with an UTF database and wasn't able to create 
> correct PDF outputs. I'm not completely sure, but it seems to me that 
> you have much less trouble if you use the Latin1 charset if you need 
> French characters.

I would, but I don't know how to enter such characters. I can use my
input method editor (scim) to input unicode directly, but I don't know
how to enter Latin1.
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r3                
[It is] best to confuse only one issue at a time.  
 -- K&R 
 
 
 

Re: [SL] Trouble entering unicode characters

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

1. Are you sure your database supports unicode? Log in with pqsl to your 
db and type "show client_encoding;".
2. I made some tests with an UTF database and wasn't able to create 
correct PDF outputs. I'm not completely sure, but it seems to me that 
you have much less trouble if you use the Latin1 charset if you need 
French characters.

Greetings
Rolf

Stuart Luppescu schrieb:
> Hello, We have customers with accented characters such as é in their
> names, but when I try to enter them as, for example, u+00e9 I get this
> error message:
> 
> DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding
> "UNICODE": 0xe9272c
> 
> I'm running SQL Ledger 2.6.22 on Linux with Postgres 8.0.13. Thanks in
> advance for any help.

Re: [SL] BOM

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

Sure, then later use articles - stock treport to see how much is in stock.
You may even disassemble assemblies back to spare parts if you should want
to ;-)

2008/2/13, Michael Hasse <mh...@it...>:
>
> I believe Paul's reply below (the [Ontopic] section) contains the
> answer.  Haven't tried it myself but it sounds good!
>     Set up your parts to have all those details then use Assemblies
> to group the parts as you please and a Sales Order with the Assembly
> to get the actual output.
>
>
> Thanks,
>
>
> Michael
>
>
>
> On Feb 13, 2008, at 6:04 AM, J.M. Jersey Miszczyk wrote:
>
> > Sorry guys... misunderstanding. Imagine:
> > I get the order, multiple instances of the various assemblies. Now
> > I want to
> > make (for myself only) a list of all the parts including
> > quantities, last
> > prices and suppliers. Is it possible?
> >
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On Behalf
> > Of Michael
> > Hasse
> > Sent: 13 February 2008 09:09 AM
> > To: sql...@li...
> > Subject: Re: [SL] BOM
> >
> > Re [Off Topic] I don't know about NL and ZA but in the US most
> > distributors won't sell to "end users".  Also, (continuing to play
> > Devil's advocate :), in the US some classified military contracts
> > require the complete supply chain to be detailed.  Not to mention I
> > could see where a detailed BOM might be handy just for training
> > purposes...
> >
> >
> > Thanks,
> >
> > Michael
> >
> >
> > On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote:
> >
> >> [Off Topic]
> >>
> >> Why would you want to do that? So the customer can order parts and
> >> assemble
> >> himself next time?
> >> Use supplier name, so the customer can cut you out as middleman?
> >> Seems not
> >> the brightest of plans..
> >>
> >> [On Topic}
> >>
> >> Use make parts, use all name, article number and supplier info you
> >> like in
> >> part name.
> >> Then use make assembly and make a sales order for the assembly.
> >>
> >> Alternatively, it., if we are talking consultancy, make one article
> >> assembly
> >> with 5000 lines of text info related to it.
> >>
> >>
> >> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
> >>>
> >>> Hi all,
> >>>
> >>> How would one go about creating Bill of Materials from a sales
> >>> order. When
> >>> you want to invoice out assemblies and get detailed list of
> >>> components
> >>> with
> >>> suppliers names.
> >>>
> >>> Best regards
> >>> "Jersey"
> >>>
> >>>
> >>> --------------------------------------------------------------------
> >>> -
> >>> ----
> >>> 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
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date:
> > 2/12/2008
> > 3:20 PM
> >
> >
> >
> > ----------------------------------------------------------------------
> > ---
> > 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] BOM

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

J.M. "Jersey" Miszczyk wrote:
> Sorry guys... misunderstanding. Imagine:
> I get the order, multiple instances of the various assemblies. Now I want to
> make (for myself only) a list of all the parts including quantities, last
> prices and suppliers. Is it possible?
>
>   
"Goods & Services--Reports--Requirements" is something close to your 
requirements though it does not give you supplier name and last cost.

Armaghan

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

Free trial available.
-- 

Re: [SL] BOM

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

I believe Paul's reply below (the [Ontopic] section) contains the  
answer.  Haven't tried it myself but it sounds good!
    Set up your parts to have all those details then use Assemblies  
to group the parts as you please and a Sales Order with the Assembly  
to get the actual output.


Thanks,

Michael


On Feb 13, 2008, at 6:04 AM, J.M. Jersey Miszczyk wrote:

> Sorry guys... misunderstanding. Imagine:
> I get the order, multiple instances of the various assemblies. Now  
> I want to
> make (for myself only) a list of all the parts including  
> quantities, last
> prices and suppliers. Is it possible?
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf  
> Of Michael
> Hasse
> Sent: 13 February 2008 09:09 AM
> To: sql...@li...
> Subject: Re: [SL] BOM
>
> Re [Off Topic] I don't know about NL and ZA but in the US most
> distributors won't sell to "end users".  Also, (continuing to play
> Devil's advocate :), in the US some classified military contracts
> require the complete supply chain to be detailed.  Not to mention I
> could see where a detailed BOM might be handy just for training
> purposes...
>
>
> Thanks,
>
> Michael
>
>
> On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote:
>
>> [Off Topic]
>>
>> Why would you want to do that? So the customer can order parts and
>> assemble
>> himself next time?
>> Use supplier name, so the customer can cut you out as middleman?
>> Seems not
>> the brightest of plans..
>>
>> [On Topic}
>>
>> Use make parts, use all name, article number and supplier info you
>> like in
>> part name.
>> Then use make assembly and make a sales order for the assembly.
>>
>> Alternatively, it., if we are talking consultancy, make one article
>> assembly
>> with 5000 lines of text info related to it.
>>
>>
>> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
>>>
>>> Hi all,
>>>
>>> How would one go about creating Bill of Materials from a sales
>>> order. When
>>> you want to invoice out assemblies and get detailed list of
>>> components
>>> with
>>> suppliers names.
>>>
>>> Best regards
>>> "Jersey"
>>>
>>>
>>> -------------------------------------------------------------------- 
>>> -
>>> ----
>>> 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
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date:  
> 2/12/2008
> 3:20 PM
>
>
>
> ---------------------------------------------------------------------- 
> ---
> 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] BOM

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

Sorry guys... misunderstanding. Imagine:
I get the order, multiple instances of the various assemblies. Now I want to
make (for myself only) a list of all the parts including quantities, last
prices and suppliers. Is it possible?

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Michael
Hasse
Sent: 13 February 2008 09:09 AM
To: sql...@li...
Subject: Re: [SL] BOM

Re [Off Topic] I don't know about NL and ZA but in the US most  
distributors won't sell to "end users".  Also, (continuing to play  
Devil's advocate :), in the US some classified military contracts  
require the complete supply chain to be detailed.  Not to mention I  
could see where a detailed BOM might be handy just for training  
purposes...


Thanks,

Michael


On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote:

> [Off Topic]
>
> Why would you want to do that? So the customer can order parts and  
> assemble
> himself next time?
> Use supplier name, so the customer can cut you out as middleman?  
> Seems not
> the brightest of plans..
>
> [On Topic}
>
> Use make parts, use all name, article number and supplier info you  
> like in
> part name.
> Then use make assembly and make a sales order for the assembly.
>
> Alternatively, it., if we are talking consultancy, make one article  
> assembly
> with 5000 lines of text info related to it.
>
>
> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
>>
>> Hi all,
>>
>> How would one go about creating Bill of Materials from a sales  
>> order. When
>> you want to invoice out assemblies and get detailed list of  
>> components
>> with
>> suppliers names.
>>
>> Best regards
>> "Jersey"
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> 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


-- 
No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date: 2/12/2008
3:20 PM

Re: [SL] BOM

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

Re [Off Topic] I don't know about NL and ZA but in the US most  
distributors won't sell to "end users".  Also, (continuing to play  
Devil's advocate :), in the US some classified military contracts  
require the complete supply chain to be detailed.  Not to mention I  
could see where a detailed BOM might be handy just for training  
purposes...


Thanks,

Michael


On Feb 12, 2008, at 10:24 PM, Paul Tammes wrote:

> [Off Topic]
>
> Why would you want to do that? So the customer can order parts and  
> assemble
> himself next time?
> Use supplier name, so the customer can cut you out as middleman?  
> Seems not
> the brightest of plans..
>
> [On Topic}
>
> Use make parts, use all name, article number and supplier info you  
> like in
> part name.
> Then use make assembly and make a sales order for the assembly.
>
> Alternatively, it., if we are talking consultancy, make one article  
> assembly
> with 5000 lines of text info related to it.
>
>
> 2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
>>
>> Hi all,
>>
>> How would one go about creating Bill of Materials from a sales  
>> order. When
>> you want to invoice out assemblies and get detailed list of  
>> components
>> with
>> suppliers names.
>>
>> Best regards
>> "Jersey"
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> 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] BOM

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

[Off Topic]

Why would you want to do that? So the customer can order parts and assemble
himself next time?
Use supplier name, so the customer can cut you out as middleman? Seems not
the brightest of plans..

[On Topic}

Use make parts, use all name, article number and supplier info you like in
part name.
Then use make assembly and make a sales order for the assembly.

Alternatively, it., if we are talking consultancy, make one article assembly
with 5000 lines of text info related to it.


2008/2/13, J.M. Jersey Miszczyk <je...@ib...>:
>
> Hi all,
>
> How would one go about creating Bill of Materials from a sales order. When
> you want to invoice out assemblies and get detailed list of components
> with
> suppliers names.
>
> Best regards
> "Jersey"
>
>
> -------------------------------------------------------------------------
> 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] BOM

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

Hi all,

How would one go about creating Bill of Materials from a sales order. When
you want to invoice out assemblies and get detailed list of components with
suppliers names.

Best regards
"Jersey"

Re: [SL] Projects and goods allocation

[Jersey <je...@ib...>]

Thnx  :),

Sounds easy, but... I am using SQL_Ledger 2.8.12... and I am not really an 
accountant. How do I "invoice" the project. Or how do I "assign" a lump sum 
to the project?
Some items will be invoiced to the client. How can I allocate the invoices 
to the project? Some "consumables", time etc will not be invoiced but they 
still should be allocated to the cost of the project.
I am checking the manual... maybe I'll get a vision :)

----- Original Message ----- 
From: "Paul Tammes" <pt...@wa...>
To: <sql...@li...>
Sent: Friday, February 08, 2008 3:13 PM
Subject: Re: [SL] Projects and goods allocation


> Make a project code, use that for both revenue lump sum and for costs
> invoices and hours, do a project report and be prepare to be amazed?
>
> 2008/2/8, J.M. Jersey Miszczyk <je...@ib...>:
>>
>> Hi All,
>>
>> Following scenario:
>> The Customer is invoiced lump sum for the project. This involves time,
>> goods, accommodation and so on.
>>
>> How can I allocate expenses to the project without issuing invoices?
>>
>> Best regards
>> "Jersey"
>>
>>
>> -------------------------------------------------------------------------
>> 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
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.20/1261 - Release Date: 2/5/2008 
> 8:57 PM
>
> 

Re: [SL] Projects and goods allocation

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

Make a project code, use that for both revenue lump sum and for costs
invoices and hours, do a project report and be prepare to be amazed?

2008/2/8, J.M. Jersey Miszczyk <je...@ib...>:
>
> Hi All,
>
> Following scenario:
> The Customer is invoiced lump sum for the project. This involves time,
> goods, accommodation and so on.
>
> How can I allocate expenses to the project without issuing invoices?
>
> Best regards
> "Jersey"
>
>
> -------------------------------------------------------------------------
> 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] Projects and goods allocation

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

Hi All,

Following scenario:
The Customer is invoiced lump sum for the project. This involves time,
goods, accommodation and so on.

How can I allocate expenses to the project without issuing invoices?

Best regards
"Jersey" 

Re: [SL] Associate the Login Name to Sales Person and Warehouse in POS

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

> I'm doing a branch operation so I want sales from a branch to deduct
> inventory levels at the warehouse for that branch.  There can be more
> than one sales persons at that branch and all of them need to be
> associated with that warehouse.

BTW, my website contains a warehouse patch which will allow you to
correctly view your stock at warehouses using 'All Items' report. Try
that.

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

Free trial available.
--

Re: [SL] Associate the Login Name to Sales Person and Warehouse in POS

[Jerome J. A. <jer...@bo...>]

Armaghan Saqib wrote:

>On 2/8/08, Jerome J. Auza <jer...@bo...> wrote:
>  
>
>>Hi,
>>
>>Is there a way to force a user name to be the same person as the Sales
>>Person in the POS?
>>    
>>
>
>It is the default behavior. Logged in user comes as default on invoices and POS.
>
>Make sure you have not specified any particular salesperson as default
>for customers in Add Customer. Otherwise that will show up as default.
>
>  
>
Ah, thanks for this.  The customer had a default Sales Person... and it 
was the first name on the pull-down selection.

>>Also need to associate that person to a certain
>>warehouse all the time.
>>    
>>
>
>It is not possible currently as per my knowledge.
>
>Let me know if it is clear.
>  
>
I'm doing a branch operation so I want sales from a branch to deduct 
inventory levels at the warehouse for that branch.  There can be more 
than one sales persons at that branch and all of them need to be 
associated with that warehouse.

Re: [SL] Associate the Login Name to Sales Person and Warehouse in POS

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

On 2/8/08, Jerome J. Auza <jer...@bo...> wrote:
> Hi,
>
> Is there a way to force a user name to be the same person as the Sales
> Person in the POS?

It is the default behavior. Logged in user comes as default on invoices and POS.

Make sure you have not specified any particular salesperson as default
for customers in Add Customer. Otherwise that will show up as default.

> Also need to associate that person to a certain
> warehouse all the time.

It is not possible currently as per my knowledge.

Let me know if it is clear.
-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/

Free trial available.
--

[SL] Associate the Login Name to Sales Person and Warehouse in POS

[Jerome J. A. <jer...@bo...>]

Hi,

Is there a way to force a user name to be the same person as the Sales 
Person in the POS?  Also need to associate that person to a certain 
warehouse all the time.


jerome

-- 
http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol

[SL] Trouble entering unicode characters

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

Hello, We have customers with accented characters such as é in their
names, but when I try to enter them as, for example, u+00e9 I get this
error message:

DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding
"UNICODE": 0xe9272c

I'm running SQL Ledger 2.6.22 on Linux with Postgres 8.0.13. Thanks in
advance for any help.
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.23-gentoo-r3                
The wise man seeks everything in himself; the
 ignorant man tries to get everything from somebody
 else. 
 
 

Re: [SL] upgrade issues...

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

> come on, Armaghan, what a crock.
>
> The upgrade can be done for any version from 1.2.7 onward without an
> incremental upgrade.

This is theory, practice is different. I just upgraded an install that has
25 companies from 2.6-something to 2.8.11. Besides of the lock-unlock
workaround desribe in the upgrade docs I had lots of trouble. - Half of
the companies worked just fien after loggong in, locking, unlocking and
loggin in agian. The rest just were impossiblle to upgrade. Problems start
with:

Error!

alter table semaphore add expires varchar(10)
ERROR: ya existe la columna «expires» en la relación «semaphore»

and

Actulaizando a versión 2.8.11 ...
Error!

create table curr (rn int, curr char(3) primary key, precision int2)

..you never make it until the end.  - The funny part is: Other companies
(databases) upgrade like a charm, same install, same versions. The
diffenrece you fin in the user configuration: Some of my users didn't have
configured their defualt currency, not even the company name; - obviously
bad, but this shouldn't brake the upgrades. It took me the whole night for
an upgrade that should take not more than one our.

1) Login to each company. If they were fine they complained once, you just
had to go to admin, lock, unlock, login again.

2) For companies that complained about semaphore I had to edit and run
manually the Pg-upgrade-2.8.6-2.8.7.sql by hand, do the upgrade after.

Logging into 25 companies for 4-5 times, checking etc. is a pain.
Definitely something is wrong with the upgrade scripts. - Finally I made
it, all companies are up and working fine. Thats the only good news on
upgrading to 2.8.11, jumping some versions. If you do continous upgrading
your life is easier!

Best wishes

Enrique




-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] upgrade issues...

[Roy W P. <arc...@mt...>]

On February 6, 2008, Michael Hasse wrote:
>  > It's mailing list threads like this that make me start to question...
> ----------------------------------
> At first blush I would agree, but this isn't really normal for  
> Dieter.  He may be a bit brief at times but Dieter usually comes  
> across as a regular guy running a small business and treating his  
> paying customers right.  These few posts sound more like the  
> stereotypical programmer-curmudgeon growling at the rest of humanity.
>     However, this is the flip side of the great advantage of only  
> having to deal with one person, you only have one person to deal  
> with!  If they are stressed out in some other part of their life one  
> gets the spillover without any context.
>     So let's give Dieter the benefit of the doubt and wish him the best.
> 
> 
> Thanks,
> 
> Michael

Hey Michael.

I identify with that whole situation. 
I know what it's like to have stress from one source and to, without any intent, have that stress come out with other tasks.
To make matters worse, email and chat can lead to confusion of intent. There's a reason why you can make a profession of writing.

I really should have made that comment part of my post in private to Dieter. 
I'm running on little sleep trying to get the new owner and staff up to speed.
Listees: Please don't turn this into an off topic thread.
Have any constructive ideas on documentation suggestions ?  good. 
Comments about DWS Systems.... that's better dealt with offlist


Roy

P.S.  As for howling at humanity...  i do that all the time.