sql-ledger-users — SQL-Ledger users

Re: [SL] Dataset creation problems

[Yves L. <yve...@gm...>]

Bonjour Rolf,

I found it. I am using Ubuntu and PostgreSQL 8.3
On my setup, the created database was owned by sql-ledger, but the schema
and tables were owned by postgres, the default PGSQL user.
I sent this patch to Dieter for approval:
User.pm, line 360
  $dbh = DBI->connect($form->{dbconnect}, $form->{dbuser},
$form->{dbpasswd}) or $form->dberror;

+  if ($form->{dbdriver} eq 'Pg') {
+    $dbcreate{Pg} = " SET SESSION AUTHORIZATION \"$form->{dbuser}\"";
+    $query = qq|$dbcreate{$form->{dbdriver}}|;
+    $dbh->do($query);
+  }

  # create the tables
  my $dbdriver = ($form->{dbdriver} =~ /Pg/) ? 'Pg' : $form->{dbdriver};

It worked for me, fixed the creation errors and solved the empty database
list upon removal, because list is produced by acheck for ownership on
defaults by sql-ledger.

Yves

2008/3/2, "Rolf Stöckli (tokon)" <in...@to...>:
>
> Bonjour Yves,
> That's really strange. In an empty DB, the relation "id" doesn't exist
> yet, so there should be no such error. If you don't use the name of an
> already existing dataset, don't click 2 times the "Continue" button and
> don't press the browser's reload button even if you think the creation
> takes too much time (and I'm sure you do neither of them), I've no idea
> why such an error occurs. - But I know, my fantasy is a bit restricted.
>
>
> Rolf
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>



-- 
Yves Lavoie ing.
Président
Gestion Automatisée Yves Lavoie inc.
Tel: (450) 746-7521
email: yve...@gm...

Re: [SL] Dataset creation problems

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

Bonjour Yves,
That's really strange. In an empty DB, the relation "id" doesn't exist 
yet, so there should be no such error. If you don't use the name of an 
already existing dataset, don't click 2 times the "Continue" button and 
don't press the browser's reload button even if you think the creation 
takes too much time (and I'm sure you do neither of them), I've no idea 
why such an error occurs. - But I know, my fantasy is a bit restricted.

Rolf

Re: [SL] Dataset creation problems

[Yves L. <yve...@gm...>]

Hi Rolf,

I suspected that, so I dropped the database with PgAdmin, to make sure that
it was gone for good.
Same problem.

Yves

2008/3/1, "Rolf Stöckli (tokon)" <in...@to...>:
>
> Yves Lavoie schrieb:
> >    - During creation, SQL-Ledger reports Error!, CREATE SEQUENCE id
> start
>
> >    10000, ERROR: relation "id" already exists.
>
>
> This means the database or a part of it already exists, maybe because a
> previous creation failed. I had similar errors, when I tried to create a
> DB with a chart of accounts that was not compatible with the charset of
> the DB, pressed the "back" button in the browser and then tried to
> create the same db for a second time. If the DB creation fails, you have
> to drop the DB first before you try again.
>

Re: [SL] Dataset creation problems

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

Yves Lavoie schrieb:
>    - During creation, SQL-Ledger reports Error!, CREATE SEQUENCE id start
>    10000, ERROR: relation "id" already exists.

This means the database or a part of it already exists, maybe because a 
previous creation failed. I had similar errors, when I tried to create a 
DB with a chart of accounts that was not compatible with the charset of 
the DB, pressed the "back" button in the browser and then tried to 
create the same db for a second time. If the DB creation fails, you have 
to drop the DB first before you try again.

Rolf

[SL] Dataset creation problems

[Yves L. <yve...@gm...>]

Hi,

I am having a few problems with the dataset creation menu, using PGSQL.

   - Upon creation, the database is owned by sql-ledger, but tables are
   owned by PGSQL default user postgres. This seems odd, because the proper
   creation method is well documented in the FAQ.
   - During creation, SQL-Ledger reports Error!, CREATE SEQUENCE id start
   10000, ERROR: relation "id" already exists.

Those are easy to prevent by using the alternate creation method documented
in the FAQ. I an just wondering if I am alone with those or if this portion
of the code is still work in progress.

Yves

Re: [SL] Tax Logic

[Yves L. <yve...@gm...>]

Hi Saqib,

Here a a few suggestions.

   - Taxes should be compoundable. Quebec taxes are calculated after
   Canadian taxes are applied. Currently I cheat on the percentages but a
   better solution should be available.
   - Country and Province (state) taxes may change, depending on the
   nature of the service, the product or the customer. Currently we can only
   have one of each.

Regards,

Yves

2008/2/21, Armaghan Saqib <sa...@le...>:
>
> C. Duncan Hudson wrote:
> > Just wondering what the status of the revised tax system is.  The
> > website says "Work Started".   But work was supposed to have started on
> > that back in August of 2004.  Is tax flexibility ever going to become a
> > reality with SQL-Ledger, or is asking just beating a dead horse
> >
>
> Hi Duncan,
>
> What you need in a revised tax system? Other list members, kindly submit
> your requirements too.
>
> I think enhancing/changing functionality in SL is not a simple job. May
> be we can collect the requirements from respected list members and ask
> Dieter for a quote. We could then poll some money to pay the author for
> this enhancement. This will surely get us the enhancement soon.
>
> Regards
>
>
>
> -------------------------------------------------------------------------
> 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
>



-- 
Yves Lavoie ing.
Président
Gestion Automatisée Yves Lavoie inc.
Tel: (450) 746-7521
email: yve...@gm...

Re: [SL] currency changeover

[Vitaly P. <vit...@gm...>]

So do you think it is possible to convert all items into another
currency using some sort of automated tool?

Vitaly

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

Re: [SL] currency changeover

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

Not necessarily a nightmare: You have the dates of all the transactions,
and the exchange rates can be downloaded for each day (even after the
day - historically). In fact SL has support for a script that
automatically downloads new exchange rates every day.

It would also be nice to just 'view' past transactions in another
currency, but SL doesn't have that code. SL must add and subtract
'corrections' for each currency translation :-(

Bob G

On Mon, 2008-02-25 at 20:44 +0100, Vitaly Popovich wrote:
> Hi,
> I would like to multiply all transactions by the same exchange factor.
> It would be a nightmare to convert them using exchange rate at that
> date.
> 
> Vitaly
> 
> On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> > Do you want to leave all your original transactions in dollars and just
> > 'view' them in euros?
> >
> > Or do you want to multiply all of the past transactions by the currency
> > exchange factor?
> >
> > If the later, do you want to use the currency exchange factor which
> > existed on the date of the transaction, or do you wish to just use one
> > currency exchange factor for all of the transactions?
> >
> > It is not a simple thing..
> >
> > On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > > Hello everyone,
> > >
> > > I am using sql-ledger as a simple accounting system.
> > > I was wondering whether there is a way how to change base currency and
> > > change all past transactions to be in new currency (euro)?
> > > For example, i used USD for transactions and now i need to change all
> > > transaction to be in Euro.
> > > Is there an automated way or built in function in sql-ledger?
> > >
> > >
> > > Regards,
> > > Vitaly
> > >
> > > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Microsoft
> > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] currency changeover

[Vitaly P. <vit...@gm...>]

Hi,
I would like to multiply all transactions by the same exchange factor.
It would be a nightmare to convert them using exchange rate at that
date.

Vitaly

On 2/25/08, Bob Gustafson <bo...@rc...> wrote:
> Do you want to leave all your original transactions in dollars and just
> 'view' them in euros?
>
> Or do you want to multiply all of the past transactions by the currency
> exchange factor?
>
> If the later, do you want to use the currency exchange factor which
> existed on the date of the transaction, or do you wish to just use one
> currency exchange factor for all of the transactions?
>
> It is not a simple thing..
>
> On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> > Hello everyone,
> >
> > I am using sql-ledger as a simple accounting system.
> > I was wondering whether there is a way how to change base currency and
> > change all past transactions to be in new currency (euro)?
> > For example, i used USD for transactions and now i need to change all
> > transaction to be in Euro.
> > Is there an automated way or built in function in sql-ledger?
> >
> >
> > Regards,
> > Vitaly
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] currency changeover

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

Do you want to leave all your original transactions in dollars and just
'view' them in euros?

Or do you want to multiply all of the past transactions by the currency
exchange factor?

If the later, do you want to use the currency exchange factor which
existed on the date of the transaction, or do you wish to just use one
currency exchange factor for all of the transactions?

It is not a simple thing..

On Sun, 2008-02-24 at 19:37 +0100, Vitaly Popovich wrote:
> Hello everyone,
> 
> I am using sql-ledger as a simple accounting system.
> I was wondering whether there is a way how to change base currency and
> change all past transactions to be in new currency (euro)?
> For example, i used USD for transactions and now i need to change all
> transaction to be in Euro.
> Is there an automated way or built in function in sql-ledger?
> 
> 
> Regards,
> Vitaly
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] proper way to log a purchase for items for sale

[Wallace R. C. <wrc...@gm...>]

On Mon, Feb 25, 2008 at 5:37 AM, Myk Robinson <myk...@gm...> wrote:
> You're probably right there :)   Thanks though, I will grab some accounting
>  books from the local library to help.

http://www.google.com/search?q=accounting+tutorial

Google is your friend. :-)
-- 
Best Regards,
Wallace

Re: [SL] proper way to log a purchase for items for sale

[Myk R. <myk...@gm...>]

You're probably right there :)   Thanks though, I will grab some accounting 
books from the local library to help.

-myk


On Sunday 24 February 2008 10:45:41 pm David J wrote:
> Purchase of trading stock is not an expense until you sell
> it.
> Between purchase and subsequent sale, its an asset.
> This is prolly a question for Accounting 101, rather than
> the SQL-L mailing list.
>
> > Thank you. perhaps i have my accounts configured
> > incorrectly. I only buy parts  when they are needed, so I
> > dont actually keep any inventory on hand. I want  to find
> > the right way to document when I purchase a part for
> > resale, and have  it shown as an expense and not as an
> > assett.. It looks like when I do the  purchase order, the
> > part is being considered an assett for some reason. Does
> > something different happen once that part is paid for by
> > the customer?
> >
> > Thanks,
> > -myk
> >
> > On Sunday 24 February 2008 11:46:56 am Michael Hasse
> >
> > > wrote: Technically one would create a Purchase Order,
> > > then as items are received, (e.g. in the case of a
> > > multi-item order that arrives in separate shipments)
> > > Vendor Invoice(s) are created from the PO. (Vendors will
> > > sometimes create multiple invoices for a single order if
> >
> > items are shipped separately).  Then the invoices are
> >
> > >     Paid. The two key points are are the Receipt of
> > > goods at the PO, which causes them to be placed into
> > > inventory.  If, however, one skips the PO process, then
> > > the goods will not be placed in inventory until the
> >
> > vendor invoice is (completely?) Paid. >
> >
> > > 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 Feb 24, 2008, at 6:12 AM, Myk Robinson wrote:
> > > > Hi-
> > > >
> > > > Seems that this used to work fine for me, so i want to
> > > > clarify correct procedure... I am ordering a part to
> > > > use in a customer's computer. I have the
> > > > part listed in the "Good and Services" section. To
> > > > document the order and add
> > > > the part to inventory, is the correct method to place
> > >
> > > it under AP-- >
> > >
> > > > >Vendor
> > > >
> > > > Invoice?
> > > >
> > > > I have done this, but it is not showing up as an
> > > > expense/purchase when I check
> > > > under Income Statement.
> > > >
> > > > Please advise..
> > > >
> > > > Thanks,
> > > > -myk robinson
>
> -------------------------------------------------------------------------
> 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] proper way to log a purchase for items for sale

[David J <ja...@in...>]

Purchase of trading stock is not an expense until you sell
it.
Between purchase and subsequent sale, its an asset.
This is prolly a question for Accounting 101, rather than
the SQL-L mailing list.


> Thank you. perhaps i have my accounts configured
> incorrectly. I only buy parts  when they are needed, so I
> dont actually keep any inventory on hand. I want  to find
> the right way to document when I purchase a part for
> resale, and have  it shown as an expense and not as an
> assett.. It looks like when I do the  purchase order, the
> part is being considered an assett for some reason. Does 
> something different happen once that part is paid for by
> the customer?
> 
> Thanks,
> -myk
> 
> On Sunday 24 February 2008 11:46:56 am Michael Hasse
> > wrote: Technically one would create a Purchase Order,
> > then as items are received, (e.g. in the case of a
> > multi-item order that arrives in separate shipments)
> > Vendor Invoice(s) are created from the PO. (Vendors will
> > sometimes create multiple invoices for a single order if
> items are shipped separately).  Then the invoices are
> >     Paid. The two key points are are the Receipt of
> > goods at the PO, which causes them to be placed into
> > inventory.  If, however, one skips the PO process, then
> > the goods will not be placed in inventory until the
> vendor invoice is (completely?) Paid. >
> >
> > 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 Feb 24, 2008, at 6:12 AM, Myk Robinson wrote:
> > > Hi-
> > >
> > > Seems that this used to work fine for me, so i want to
> > > clarify correct procedure... I am ordering a part to
> > > use in a customer's computer. I have the
> > > part listed in the "Good and Services" section. To
> > > document the order and add
> > > the part to inventory, is the correct method to place
> > it under AP-- >
> > > >Vendor
> > >
> > > Invoice?
> > >
> > > I have done this, but it is not showing up as an
> > > expense/purchase when I check
> > > under Income Statement.
> > >
> > > Please advise..
> > >
> > > Thanks,
> > > -myk robinson
> > >
> > >

Re: [SL] proper way to log a purchase for items for sale

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

Michael Hasse wrote:
>     The two key points are are the Receipt of goods at the PO, which  
> causes them to be placed into inventory.  If, however, one skips the  
> PO process, then the goods will not be placed in inventory until the  
> vendor invoice is (completely?) Paid.
>   
Goods are placed in inventory when a purchase invoice is created. This 
is not linked to the payment of that AP  invoice.
Regards

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


--

Re: [SL] proper way to log a purchase for items for sale

[Myk R. <myk...@gm...>]

Thank you. perhaps i have my accounts configured incorrectly. I only buy parts 
when they are needed, so I dont actually keep any inventory on hand. I want 
to find the right way to document when I purchase a part for resale, and have 
it shown as an expense and not as an assett.. It looks like when I do the 
purchase order, the part is being considered an assett for some reason. Does 
something different happen once that part is paid for by the customer?

Thanks,
-myk

On Sunday 24 February 2008 11:46:56 am Michael Hasse wrote:
> Technically one would create a Purchase Order, then as items are
> received, (e.g. in the case of a multi-item order that arrives in
> separate shipments) Vendor Invoice(s) are created from the PO.
> (Vendors will sometimes create multiple invoices for a single order
> if items are shipped separately).  Then the invoices are Paid.
>     The two key points are are the Receipt of goods at the PO, which
> causes them to be placed into inventory.  If, however, one skips the
> PO process, then the goods will not be placed in inventory until the
> vendor invoice is (completely?) Paid.
>
>
> 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 Feb 24, 2008, at 6:12 AM, Myk Robinson wrote:
> > Hi-
> >
> > Seems that this used to work fine for me, so i want to clarify correct
> > procedure... I am ordering a part to use in a customer's computer.
> > I have the
> > part listed in the "Good and Services" section. To document the
> > order and add
> > the part to inventory, is the correct method to place it under AP--
> >
> > >Vendor
> >
> > Invoice?
> >
> > I have done this, but it is not showing up as an expense/purchase
> > when I check
> > under Income Statement.
> >
> > Please advise..
> >
> > Thanks,
> > -myk robinson
> >
> > ----------------------------------------------------------------------
> > ---
> > 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

[SL] currency changeover

[Vitaly P. <vit...@gm...>]

Hello everyone,

I am using sql-ledger as a simple accounting system.
I was wondering whether there is a way how to change base currency and
change all past transactions to be in new currency (euro)?
For example, i used USD for transactions and now i need to change all
transaction to be in Euro.
Is there an automated way or built in function in sql-ledger?


Regards,
Vitaly

Re: [SL] proper way to log a purchase for items for sale

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

Technically one would create a Purchase Order, then as items are  
received, (e.g. in the case of a multi-item order that arrives in  
separate shipments) Vendor Invoice(s) are created from the PO.   
(Vendors will sometimes create multiple invoices for a single order  
if items are shipped separately).  Then the invoices are Paid.
    The two key points are are the Receipt of goods at the PO, which  
causes them to be placed into inventory.  If, however, one skips the  
PO process, then the goods will not be placed in inventory until the  
vendor invoice is (completely?) Paid.


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 Feb 24, 2008, at 6:12 AM, Myk Robinson wrote:

> Hi-
>
> Seems that this used to work fine for me, so i want to clarify correct
> procedure... I am ordering a part to use in a customer's computer.  
> I have the
> part listed in the "Good and Services" section. To document the  
> order and add
> the part to inventory, is the correct method to place it under AP-- 
> >Vendor
> Invoice?
>
> I have done this, but it is not showing up as an expense/purchase  
> when I check
> under Income Statement.
>
> Please advise..
>
> Thanks,
> -myk robinson
>
> ---------------------------------------------------------------------- 
> ---
> 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] proper way to log a purchase for items for sale

[Myk R. <myk...@gm...>]

Hi-

Seems that this used to work fine for me, so i want to clarify correct 
procedure... I am ordering a part to use in a customer's computer. I have the 
part listed in the "Good and Services" section. To document the order and add 
the part to inventory, is the correct method to place it under AP-->Vendor 
Invoice?

I have done this, but it is not showing up as an expense/purchase when I check 
under Income Statement.

Please advise..

Thanks,
-myk robinson

Re: [SL] Tax Logic

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

C. Duncan Hudson wrote:
> Just wondering what the status of the revised tax system is.  The 
> website says "Work Started".   But work was supposed to have started on 
> that back in August of 2004.  Is tax flexibility ever going to become a 
> reality with SQL-Ledger, or is asking just beating a dead horse
>   
Hi Duncan,

What you need in a revised tax system? Other list members, kindly submit 
your requirements too.

I think enhancing/changing functionality in SL is not a simple job. May 
be we can collect the requirements from respected list members and ask 
Dieter for a quote. We could then poll some money to pay the author for 
this enhancement. This will surely get us the enhancement soon.

Regards

[SL] Tax Logic

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

Just wondering what the status of the revised tax system is.  The 
website says "Work Started".   But work was supposed to have started on 
that back in August of 2004.  Is tax flexibility ever going to become a 
reality with SQL-Ledger, or is asking just beating a dead horse?

Dunc

[SL] SQL-Ledger <-> Perl/Tk/Tkx Vesion

[<yb...@gm...>]

Hello

? is there Sql-ledger Perl/Tk/Tkx Version ?

Thanks
yb...@gm...

Re: [SL] Crippled characters in Jpn mail (utf-8 encoding)

[Tom D. <td...@ro...>]

On Wed, 20 Feb 2008, Bernd Plagge wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> there seems to be a bug in sqwebmail where Japanese mail get crippled

Ummm, did I miss something or did you post to the wrong list? This is 
the sql-ledger list not the sqwebmail list.

Regards,

-- 
Tom Diehl		td...@ro...		Spamtrap address mt...@ro...

[SL] Crippled characters in Jpn mail (utf-8 encoding)

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

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

Hello,

there seems to be a bug in sqwebmail where Japanese mail get crippled
i.e. characters get modified and not readable any more.

The problems seems to occur when 'soft breaks' (flowed format) are
inserted into the text. 
The text is encoded in 'quoted-printable' format and according to the
RFC soft-breaks are inserted 'between words'.

The problem with Japanese text is that the normal text flow does not
contain spaces. This necessarily leads to lines exceeding the
predetermined text length.
- From what I can see the program is searching for (single byte) space
characters and then applies soft breaks. However, a single byte space
character is likely to be the first or second byte of a double byte
Japanese character and thus the inserted soft break destroys the
character.

Test (1) with lines of over 50-60 (single byte) chars length show
crippled characters.
Test (2) with very short lines of about 20 (single byte) chars was
transmitted without problems.

Text already got crippled when saved to the 'draft' folder.

I have screen prints to show the problem. If you should require them
please let me know where to upload them to.

Cheers,
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)

iD8DBQFHuvLvpYU8M8PbPV4RAoV1AJwKrWzF271dfzVPP6xCX62HCOVTggCePjsy
K/u5mwRs4yW0s7iHdD9S3go=
=DEYA
-----END PGP SIGNATURE-----

Re: [SL] Cash reconciliation discrepancy

[Michael G. <ge...@mu...>]

Oops, I should have said I just upgraded to 2.8.11...

On Mon, Feb 18, 2008 at 03:13:33PM -0500, Michael George wrote:
> I just upgraded to 2.6.11 (and then to .12) near the first of the year.
> My Cash Reconciliation screen is much different now.  It will list all
> the prior transactions since I started rather than just the "unchecked"
> ones.
> 
> I can overlook that, but I have another issue...
> 
> I have had no problems with cash reconciliation in the past.  When I
> went to reconcile my 12/31/07 statement, however, there is a $736.26
> discrepancy.  When I list the cash account in the chart of accounts, the
> final balance of the cash account matches that in my checkbook.
> However, the final balance on the reconciliation screen is different.
> 
> What I found is that back in July, I have a general ledger entry for:
> Acct.						Debit		Credit
> checking								736.26
> checking								736.26
> Health Ins.				1472.52
> 
> That transaction shows up correctly in my Checking account report.
> 
> However, on the Cash Reconciliation screen, there is only *one* entry
> for 7/31/07 credit of $736.26.  So the reconciliation screen is now off.
> Before upgrading from 2.6.12 to 2.8.11, I didn't have this problem...
> 
> Has anyone else run into this?

-- 
-M

There are 10 kinds of people in this world:
	Those who can count in binary and those who cannot.

[SL] Cash reconciliation discrepancy

[Michael G. <ge...@mu...>]

I just upgraded to 2.6.11 (and then to .12) near the first of the year.
My Cash Reconciliation screen is much different now.  It will list all
the prior transactions since I started rather than just the "unchecked"
ones.

I can overlook that, but I have another issue...

I have had no problems with cash reconciliation in the past.  When I
went to reconcile my 12/31/07 statement, however, there is a $736.26
discrepancy.  When I list the cash account in the chart of accounts, the
final balance of the cash account matches that in my checkbook.
However, the final balance on the reconciliation screen is different.

What I found is that back in July, I have a general ledger entry for:
Acct.						Debit		Credit
checking								736.26
checking								736.26
Health Ins.				1472.52

That transaction shows up correctly in my Checking account report.

However, on the Cash Reconciliation screen, there is only *one* entry
for 7/31/07 credit of $736.26.  So the reconciliation screen is now off.
Before upgrading from 2.6.12 to 2.8.11, I didn't have this problem...

Has anyone else run into this?

-- 
-M

There are 10 kinds of people in this world:
	Those who can count in binary and those who cannot.