sql-ledger-users — SQL-Ledger users

Re: [SL] SL: Cash Reconcilation showing past reconciled items

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

I do not (yet) have problems, but I would prefer the main program to be
fixed.
Beats  loose patches that have to be re-applied, although a working patch is
better than nothing.

2009/5/14 John Saunders <jo...@sc...>

> Hi Paul,
>
> I am not sure I understand your question. From what I can deduct, Armaghan
> is involved with a fork/branch based on SL and, as suggested by Hamish, one
> needs to re-patch each time you upgrade SL.
>
> Why a fix is not forthcoming I could not say as Armaghan mentioned in a
> previous post that he had submitted the patch to Dieter.
>
> Cheers,
>
> John
>
> ----- Original Message -----
> From: "Paul Tammes" <pt...@wa...>
> To: <sql...@li...>
> Sent: Thursday, May 14, 2009 5:58 AM
> Subject: Re: [SL] SL: Cash Reconcilation showing past reconciled items
>
>
> > Just curious, is that patch in the main line as well, or just an insider
> > knowledge item/
> >
> > 2009/5/13 John Saunders <jo...@sc...>
> >
> >> Hi Jeff,
> >>
> >> I had the same problem and this was solved by a patch supplied by
> >> Armaghan
> >> at sa...@le...
> >>
> >> Regards,
> >>
> >> John
> >>
> >> ----- Original Message -----
> >> From: <je...@ix...>
> >> To: <sql...@li...>
> >> Sent: Wednesday, May 13, 2009 12:30 AM
> >> Subject: [SL] SL: Cash Reconcilation showing past reconciled items
> >>
> >>
> >> >
> >> >
> >> > I do bank reconcilations every month and for 6yrs I've never had an
> >> > issue. This month I pull up the reconcilation screen, and its showing
> >> > items that are reconciled. I try to limit the date range... 04/01/09
> >> > to 04/30/09, and I have items that are reconciled showing up from Feb
> >> > and Mar, they even have the check mark in the reconcilation column. My
> >> > beginning balance is not the amount that I reconciled to in the
> >> > previous month, and when I put in the previous months ending balance
> >> > and hit update, it shows 0.00 difference. I hit done. I've closed the
> >> > system, got back in and.... its stilll showing me everything thats
> >> > been reconciled.
> >> > Is there something in the system that I need to change? preferences
> >> > or something? I've never had this come up before. We did upgrade from
> >> > 2.61 to 2.8.23 early last month.
> >> > Thanks
> >> > Jeff
> >> >
> >> > General Accounting Manager
> >> >
> >> > IX Systems
> >> >
> >>
> ------------------------------------------------------------------------------
> >> > The NEW KODAK i700 Series Scanners deliver under ANY circumstances!
> >> > Your
> >> > production scanning environment may not be a perfect world - but
> thanks
> >> to
> >> > Kodak, there's a perfect scanner to get the job done! With the NEW
> >> > KODAK
> >> > i700
> >> > Series Scanner you'll get full speed at 300 dpi even with all image
> >> > processing features enabled. http://p.sf.net/sfu/kodak-com
> >> > _______________________________________________
> >> > sql-ledger-users mailing list
> >> > sql...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> >> production scanning environment may not be a perfect world - but thanks
> >> to
> >> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> >> i700
> >> Series Scanner you'll get full speed at 300 dpi even with all image
> >> processing features enabled. http://p.sf.net/sfu/kodak-com
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >
> ------------------------------------------------------------------------------
> > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> > production scanning environment may not be a perfect world - but thanks
> to
> > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> > i700
> > Series Scanner you'll get full speed at 300 dpi even with all image
> > processing features enabled. http://p.sf.net/sfu/kodak-com
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] SL: Cash Reconcilation showing past reconciled items

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

This patch is now available on ledger123.com's git repository at
http://github.com/ledger123. Kindly test it and let me know any
issues. I shall be happy to immediately correct any other issue. The
repository version has been synced with sql-ledger-2.8.24.

If you are not comfortable with git, email me offline and I shall send
you the patched files.

Regards
-- 
- sql-ledger hosting, custom development and documentation.
- http://ledger123.com

Re: [SL] SL: Cash Reconcilation showing past reconciled items

[<la...@cl...>]

Yikes...I notice that too and I just deal with it like with COGS, sales,
and inventory getting all messed up if you ever reverse an invoice because
of returns...Tim


>>> ----- Original Message -----
>>> From: <je...@ix...>
>>> To: <sql...@li...>
>>> Sent: Wednesday, May 13, 2009 12:30 AM
>>> Subject: [SL] SL: Cash Reconcilation showing past reconciled items
>>>
>>>
>>> >
>>> >
>>> > I do bank reconcilations every month and for 6yrs I've never had an
>>> > issue. This month I pull up the reconcilation screen, and its showing
>>> > items that are reconciled. I try to limit the date range... 04/01/09
>>> > to 04/30/09, and I have items that are reconciled showing up from Feb
>>> > and Mar, they even have the check mark in the reconcilation column.
>>> My
>>> > beginning balance is not the amount that I reconciled to in the
>>> > previous month, and when I put in the previous months ending balance
>>> > and hit update, it shows 0.00 difference. I hit done. I've closed the
>>> > system, got back in and.... its stilll showing me everything thats
>>> > been reconciled.
>>> > Is there something in the system that I need to change? preferences
>>> > or something? I've never had this come up before. We did upgrade from
>>> > 2.61 to 2.8.23 early last month.
>>> > Thanks
>>> > Jeff
>>> >
>>> > General Accounting Manager
>>> >
>>> > IX Systems
>>> >
>>> ------------------------------------------------------------------------------
>>> > The NEW KODAK i700 Series Scanners deliver under ANY circumstances!
>>> > Your
>>> > production scanning environment may not be a perfect world - but
>>> thanks
>>> to
>>> > Kodak, there's a perfect scanner to get the job done! With the NEW
>>> > KODAK
>>> > i700
>>> > Series Scanner you'll get full speed at 300 dpi even with all image
>>> > processing features enabled. http://p.sf.net/sfu/kodak-com
>>> > _______________________________________________
>>> > sql-ledger-users mailing list
>>> > sql...@li...
>>> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances!
>>> Your
>>> production scanning environment may not be a perfect world - but thanks
>>> to
>>> Kodak, there's a perfect scanner to get the job done! With the NEW
>>> KODAK
>>> i700
>>> Series Scanner you'll get full speed at 300 dpi even with all image
>>> processing features enabled. http://p.sf.net/sfu/kodak-com
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>> ------------------------------------------------------------------------------
>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>> production scanning environment may not be a perfect world - but thanks
>> to
>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
>> i700
>> Series Scanner you'll get full speed at 300 dpi even with all image
>> processing features enabled. http://p.sf.net/sfu/kodak-com
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] SL: Cash Reconcilation showing past reconciled items

[John S. <jo...@sc...>]

Hi Paul,

I am not sure I understand your question. From what I can deduct, Armaghan 
is involved with a fork/branch based on SL and, as suggested by Hamish, one 
needs to re-patch each time you upgrade SL.

Why a fix is not forthcoming I could not say as Armaghan mentioned in a 
previous post that he had submitted the patch to Dieter.

Cheers,

John

----- Original Message ----- 
From: "Paul Tammes" <pt...@wa...>
To: <sql...@li...>
Sent: Thursday, May 14, 2009 5:58 AM
Subject: Re: [SL] SL: Cash Reconcilation showing past reconciled items


> Just curious, is that patch in the main line as well, or just an insider
> knowledge item/
>
> 2009/5/13 John Saunders <jo...@sc...>
>
>> Hi Jeff,
>>
>> I had the same problem and this was solved by a patch supplied by 
>> Armaghan
>> at sa...@le...
>>
>> Regards,
>>
>> John
>>
>> ----- Original Message -----
>> From: <je...@ix...>
>> To: <sql...@li...>
>> Sent: Wednesday, May 13, 2009 12:30 AM
>> Subject: [SL] SL: Cash Reconcilation showing past reconciled items
>>
>>
>> >
>> >
>> > I do bank reconcilations every month and for 6yrs I've never had an
>> > issue. This month I pull up the reconcilation screen, and its showing
>> > items that are reconciled. I try to limit the date range... 04/01/09
>> > to 04/30/09, and I have items that are reconciled showing up from Feb
>> > and Mar, they even have the check mark in the reconcilation column. My
>> > beginning balance is not the amount that I reconciled to in the
>> > previous month, and when I put in the previous months ending balance
>> > and hit update, it shows 0.00 difference. I hit done. I've closed the
>> > system, got back in and.... its stilll showing me everything thats
>> > been reconciled.
>> > Is there something in the system that I need to change? preferences
>> > or something? I've never had this come up before. We did upgrade from
>> > 2.61 to 2.8.23 early last month.
>> > Thanks
>> > Jeff
>> >
>> > General Accounting Manager
>> >
>> > IX Systems
>> >
>> ------------------------------------------------------------------------------
>> > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! 
>> > Your
>> > production scanning environment may not be a perfect world - but thanks
>> to
>> > Kodak, there's a perfect scanner to get the job done! With the NEW 
>> > KODAK
>> > i700
>> > Series Scanner you'll get full speed at 300 dpi even with all image
>> > processing features enabled. http://p.sf.net/sfu/kodak-com
>> > _______________________________________________
>> > sql-ledger-users mailing list
>> > sql...@li...
>> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>
>> ------------------------------------------------------------------------------
>> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
>> production scanning environment may not be a perfect world - but thanks 
>> to
>> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
>> i700
>> Series Scanner you'll get full speed at 300 dpi even with all image
>> processing features enabled. http://p.sf.net/sfu/kodak-com
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK 
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users 

Re: [SL] SL: Cash Reconcilation showing past reconciled items

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

Just curious, is that patch in the main line as well, or just an insider
knowledge item/

2009/5/13 John Saunders <jo...@sc...>

> Hi Jeff,
>
> I had the same problem and this was solved by a patch supplied by Armaghan
> at sa...@le...
>
> Regards,
>
> John
>
> ----- Original Message -----
> From: <je...@ix...>
> To: <sql...@li...>
> Sent: Wednesday, May 13, 2009 12:30 AM
> Subject: [SL] SL: Cash Reconcilation showing past reconciled items
>
>
> >
> >
> > I do bank reconcilations every month and for 6yrs I've never had an
> > issue. This month I pull up the reconcilation screen, and its showing
> > items that are reconciled. I try to limit the date range... 04/01/09
> > to 04/30/09, and I have items that are reconciled showing up from Feb
> > and Mar, they even have the check mark in the reconcilation column. My
> > beginning balance is not the amount that I reconciled to in the
> > previous month, and when I put in the previous months ending balance
> > and hit update, it shows 0.00 difference. I hit done. I've closed the
> > system, got back in and.... its stilll showing me everything thats
> > been reconciled.
> > Is there something in the system that I need to change? preferences
> > or something? I've never had this come up before. We did upgrade from
> > 2.61 to 2.8.23 early last month.
> > Thanks
> > Jeff
> >
> > General Accounting Manager
> >
> > IX Systems
> >
> ------------------------------------------------------------------------------
> > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> > production scanning environment may not be a perfect world - but thanks
> to
> > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> > i700
> > Series Scanner you'll get full speed at 300 dpi even with all image
> > processing features enabled. http://p.sf.net/sfu/kodak-com
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] SL: Cash Reconcilation showing past reconciled items

[Hamish B. <hw...@be...>]

On Thu, 14 May 2009, John Saunders wrote:
> I had the same problem and this was solved by a patch supplied by Armaghan
> at sa...@le...

> ----- Original Message -----
> From: <je...@ix...>
> To: <sql...@li...>
> Sent: Wednesday, May 13, 2009 12:30 AM
> Subject: [SL] SL: Cash Reconcilation showing past reconciled items
>
> > I do bank reconcilations every month and for 6yrs I've never had an
> > issue. This month I pull up the reconcilation screen, and its showing
> > items that are reconciled. I try to limit the date range... 04/01/09
> > to 04/30/09, and I have items that are reconciled showing up from Feb
> > and Mar, they even have the check mark in the reconcilation column. My
> > beginning balance is not the amount that I reconciled to in the
> > previous month, and when I put in the previous months ending balance
> > and hit update, it shows 0.00 difference. I hit done. I've closed the
> > system, got back in and.... its stilll showing me everything thats
> > been reconciled.

Same problem here.  I posted to the official SQL-Ledger forum at least two 
weeks ago (I pay for the Manual every year) and have received no response 
from either Dieter or a subscriber.

I also solved the problem earlier with Armaghan's patch, for which I am very 
grateful - but of course whenever I upgrade I have to re-patch. 

Hamish

  
-- 
Sent via KMail 1.9.7, Gentoo 1.12.11.1, Linux-2.6.22-gentoo-r8

Re: [SL] Edit shipping data

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

In a literal sense, yes, since the database on the back end can  
always be accessed directly.  But that might not be the most  
convenient solution.  What's the scenario - can you describe an  
example case where this is being needed?


Thanks,

Michael


On May 12, 2009, at 3:25 PM, R. Quansah wrote:

Hi,

is it possible to edit and correct shipping data?

regards
Robert

------------------------------------------------------------------------ 
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but  
thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW  
KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] SL: Cash Reconcilation showing past reconciled items

[John S. <jo...@sc...>]

Hi Jeff,

I had the same problem and this was solved by a patch supplied by Armaghan 
at sa...@le...

Regards,

John

----- Original Message ----- 
From: <je...@ix...>
To: <sql...@li...>
Sent: Wednesday, May 13, 2009 12:30 AM
Subject: [SL] SL: Cash Reconcilation showing past reconciled items


>
>
> I do bank reconcilations every month and for 6yrs I've never had an
> issue. This month I pull up the reconcilation screen, and its showing
> items that are reconciled. I try to limit the date range... 04/01/09
> to 04/30/09, and I have items that are reconciled showing up from Feb
> and Mar, they even have the check mark in the reconcilation column. My
> beginning balance is not the amount that I reconciled to in the
> previous month, and when I put in the previous months ending balance
> and hit update, it shows 0.00 difference. I hit done. I've closed the
> system, got back in and.... its stilll showing me everything thats
> been reconciled.
> Is there something in the system that I need to change? preferences
> or something? I've never had this come up before. We did upgrade from
> 2.61 to 2.8.23 early last month.
> Thanks
> Jeff
>
> General Accounting Manager
>
> IX Systems
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK 
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users 

[SL] SL: Cash Reconcilation showing past reconciled items

[<je...@ix...>]

 I do bank reconcilations every month and for 6yrs I've never had an
issue. This month I pull up the reconcilation screen, and its showing
items that are reconciled. I try to limit the date range... 04/01/09
to 04/30/09, and I have items that are reconciled showing up from Feb
and Mar, they even have the check mark in the reconcilation column. My
beginning balance is not the amount that I reconciled to in the
previous month, and when I put in the previous months ending balance
and hit update, it shows 0.00 difference. I hit done. I've closed the
system, got back in and.... its stilll showing me everything thats
been reconciled.   
 Is there something in the system that I need to change? preferences
or something? I've never had this come up before. We did upgrade from
2.61 to 2.8.23 early last month.  
 Thanks  
 Jeff  

 General Accounting Manager  

 IX Systems  

[SL] Edit shipping data

[R. Q. <rq...@gm...>]

Hi,

is it possible to edit and correct shipping data?

regards
Robert

Re: [SL] Tax applied to Customer or service/goods

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

Alan Murrell wrote:
> ----- "Paul Tammes" <pt...@wa...> wrote:
>
>   
>> Now for a customer to be able to buy all *three *sorts of goods and
>> services
>> for the respective tax %,  *all* available boxes (0%, tax low 6% and
>> tax
>> high 20%) should be ticked. On invoicing  everything should work out.
>>     
>
> So if I understand you correctly, what you are saying is this:
>
>   - A Customer should always have all the available tax boxes checked
>   - When defining a product/service, only check the tax boxes that apply for that product (e.g., 20% VAT for whatever, 6% VAT for another product, etc.)
>   - When an item is added to an invoice, SQL-Ledger will apply the appropriate taxe(s) based on the product/service and what taxes apply to them
>   

The point is that only the intersection of all options apply

So if you have 4 taxes (a, b, c, d) then if your customer had a and b 
selected, and the product had b and c selected, then the invoice would 
use only tax b (the intersection)

To solve the problem I sometimes duplicate my customer as vattable and 
non vattable, but more often I duplicate the product and make that 
vattable or non vattable.  eg you could use two consultancy items, 
"Consultancy with deliverable" and "Consultancy work only" and that 
would give you control over whether or not to bill tax

Good luck

Ed W

Re: [SL] Tax applied to Customer or service/goods

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

Customers, like goods, should only have those taxes selected which  
apply to them.  SL will automatically apply only those taxes which  
are selected in both areas.
    Where it gets tricky is when there's "tax on tax" as is done in  
some countries.  If you don't have to deal with that though then it's  
pretty straightforward.


Thanks,

Michael


On May 12, 2009, at 8:15 AM, Alan Murrell wrote:


----- "Paul Tammes" <pt...@wa...> wrote:

> Now for a customer to be able to buy all *three *sorts of goods and
> services
> for the respective tax %,  *all* available boxes (0%, tax low 6% and
> tax
> high 20%) should be ticked. On invoicing  everything should work out.

So if I understand you correctly, what you are saying is this:

   - A Customer should always have all the available tax boxes checked
   - When defining a product/service, only check the tax boxes that  
apply for that product (e.g., 20% VAT for whatever, 6% VAT for  
another product, etc.)
   - When an item is added to an invoice, SQL-Ledger will apply the  
appropriate taxe(s) based on the product/service and what taxes apply  
to them

-Alan

------------------------------------------------------------------------ 
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but  
thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW  
KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Help configuration POS file pos.con.pl

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

ledgersmb <> sql-ledger

2009/5/12 Walter López <wal...@ya...>

>
> Hello i been setup ledgersmb 1.2.18 on ubuntu 9.04 i need use a Pos system,
> i am using a single till-based account, i been setup ledgersmb on local
> machine with local ip 192.168.0.1 and i created account named 1300.1 on
> Chart of Accounts, but how changes i need to make on pos.conf.pl file
>
> # Define your till accno scheme here.  Current supported values are
> 'terminal'
> # and 'cashier'
>
> $pos_config{'till_type'} = 'cashier';
>
> # FLAGS: 1 = projects, 2 = departments
> $pos_config{'disable_tables'} = 3;
>
> # HTML for the appropriate currency symbol for your tills
> $pos_config{'curren'} = '$';
>
> # Number format to use
> $pos_config{'numberformat'} = '1,000.00';
>
> # Units of currency to use in the till closing cash breakdown relative to
> # your base unit of currency, formatted in your chosen format
> @{ $pos_config{'breakdown'} } =
>  ( '100', '50', '20', '10', '5', '2', '1', '0.25', '0.10', '0.05', '0.01'
> );
>
> # Stop Editing Here
>
> In that lines I must introduce changes, and which it they must be? to start
> using the pos system, please helpe i am newbie
>
> Best Regards
>
> Walter
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Tax applied to Customer or service/goods

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

Yes, i seem to recall I did something like that.
But DO TEST as I suggested, test-invoice should show up as you expected, if
not: I may have remembered wrongly.

2009/5/12 Alan Murrell <li...@mu...>

>
> ----- "Paul Tammes" <pt...@wa...> wrote:
>
> > Now for a customer to be able to buy all *three *sorts of goods and
> > services
> > for the respective tax %,  *all* available boxes (0%, tax low 6% and
> > tax
> > high 20%) should be ticked. On invoicing  everything should work out.
>
> So if I understand you correctly, what you are saying is this:
>
>  - A Customer should always have all the available tax boxes checked
>  - When defining a product/service, only check the tax boxes that apply for
> that product (e.g., 20% VAT for whatever, 6% VAT for another product, etc.)
>  - When an item is added to an invoice, SQL-Ledger will apply the
> appropriate taxe(s) based on the product/service and what taxes apply to
> them
>
> -Alan
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Help configuration POS file pos.con.pl

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

Hello i been setup ledgersmb 1.2.18 on ubuntu 9.04 i need use a Pos system, i am using a single till-based account, i been setup ledgersmb on local machine with local ip 192.168.0.1 and i created account named 1300.1 on Chart of Accounts, but how changes i need to make on pos.conf.pl file 

# Define your till accno scheme here.  Current supported values are 'terminal'
# and 'cashier'

$pos_config{'till_type'} = 'cashier';

# FLAGS: 1 = projects, 2 = departments
$pos_config{'disable_tables'} = 3;

# HTML for the appropriate currency symbol for your tills
$pos_config{'curren'} = '$';

# Number format to use
$pos_config{'numberformat'} = '1,000.00';

# Units of currency to use in the till closing cash breakdown relative to
# your base unit of currency, formatted in your chosen format
@{ $pos_config{'breakdown'} } =
  ( '100', '50', '20', '10', '5', '2', '1', '0.25', '0.10', '0.05', '0.01' );

# Stop Editing Here

In that lines I must introduce changes, and which it they must be? to start using the pos system, please helpe i am newbie

Best Regards

Walter

Re: [SL] Tax applied to Customer or service/goods

[Alan M. <li...@mu...>]

----- "Paul Tammes" <pt...@wa...> wrote:

> Now for a customer to be able to buy all *three *sorts of goods and
> services
> for the respective tax %,  *all* available boxes (0%, tax low 6% and
> tax
> high 20%) should be ticked. On invoicing  everything should work out.

So if I understand you correctly, what you are saying is this:

  - A Customer should always have all the available tax boxes checked
  - When defining a product/service, only check the tax boxes that apply for that product (e.g., 20% VAT for whatever, 6% VAT for another product, etc.)
  - When an item is added to an invoice, SQL-Ledger will apply the appropriate taxe(s) based on the product/service and what taxes apply to them

-Alan

[SL] server error

[Adrian <adr...@ie...>]

I forgot to add:

the error is when printing to screen or a valid printer

Adrian

-- 
Adrian Blake
Molonglo Radio Observatory
1152 Hoskinstown Rd
Bungendore
NSW 2621
ph 02 80042212

[SL] Tax applied to Customer or service/goods

[James S. <jst...@si...>]

Greetings everyone,

My question is around When TAX is applied to a Sales Invoice.

We are a small IT consulting company and 80% of the time our billable
hours (To the client) are not taxed. However the other 20% we do tax for
other reasons.

We notice you can set a TAX that will apply AT THE CUSTOMER
DEFINITION... Is this the only place to do that meaning it will always
apply on Sales Invoices to that customer?

We also notice you can define it WITHIN the service/goods which makes us
think NOT to apply it at the customer level and it would apply to those
services/goods included on the Sales Invoice however, What is the
customer sub-sevtion at the bottom of the 'Edit Service' form?

The objective here is to charge Tax on consulting hours when a product
is produced as the outcome, the rest of the time NOT charge Tax.

Sorry if this has been covered already...

James Stevens A+, N+, CCNA
Jam...@si...
   www.sislink.net  



-- 
This message has been scanned for viruses and 
dangerous content by SISLINK.NET. Come join us!

[SL] Sales tax paid on purchases

[KevinC at AutoDFW.c. <ke...@au...>]

I'm probably not the only one to have this issue, so I'll ask for some  
ideas.

There are times when I have to make purchases that should be tax- 
exempt, but end up paying tax due to not having my tax certificate  
with me or encountering a cashier who has no clue how to do a tax  
exempt transaction, or whatever reason.

Has anyone figured out a way to flag transactions like this, or at  
least a way to make them easier to separate from legitimately taxed  
transactions in SQLledger? It would sure make it easier to sort  
through everything come quarterly Sales and Use Tax filing time.

Thanks,
Kevin

Re: [SL] Error encountered when attempting to create .pdf - panic bug

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

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

Hello,

I was hit by this bug as well.
Yesterday I worked on this issue but I couldn't solve it (I'm not a Perl guru).
However, there is a quick workaround which is (at least for me) acceptable.

Look at your invoice.tex Latex file.
The line printing the line items should start like:

<%runningnumber%> ...

The problem is as far as I can see caused by corruption in the runningnumber field.
I changed the field to:

<%runningnumber1%>

As there is no such field it won't print anything - but it will print the invoice.

Cheers,
Bernd

On Thu, 07 May 2009 04:08:15 +0000
sql...@li... wrote:

> Message: 11
> Date: Mon, 04 May 2009 23:29:55 -0400
> From: "C. Duncan Hudson" <du...@du...>
> Subject: Re: [SL] Error encountered when attempting to create .pdf
> 	invoices
> To: sql...@li...
> Message-ID: <49F...@du...>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> It means that you're running one of the more recent versions of 
> SQL-Ledger, and you have Perl 5.10 installed.  Currently there isn't a 
> fix for the problem, but Dieter is working on solving it.
> 
> Dunc
> 
> Myk Robinson wrote:
> > I got this error message today:
> >
> > panic: attempt to copy freed scalar 987aeb8 to 929a788 at SL/Form.pm
> > line 1007.
> >
> >
> > Not sure what this means, or what I could have done to cause it.
> >
> > Please advise.

- -- 
Bernd Plagge - プラゲ ベェアント 
First Choice Internet Ltd., Tokyo - ファースト・チョイス・インターネット(有)

*****  新電話番号 - 3月16日から New Phone Number from 03/16 ******

                          03 - 6379 2516

mail: bp...@ch... - url: http://www.choicenet.ne.jp
	**************************************************************
			*** Campaign ***
Affordable Web Sites http://choicenet.ne.jp/en/hpcampaign.html
ホームページキャンペーン  http://choicenet.ne.jp/jp/hpcampaign.html
	**************************************************************
FREE Web Assessment: http://choicenet.ne.jp/en/website_assessment.html
Web Design:          http://choicenet.ne.jp/en/webdesign.html
Web Hosting:         http://choicenet.ne.jp/en/hosting.html
Net Support:         http://choicenet.ne.jp/en/netsupport.html
			*******************
無料ウエブサイト評価     http://choicenet.ne.jp/jp/website_assessment.html
ウエブデザイン:          http://choicenet.ne.jp/jp/webdesign.html
ウエブホスティング:      http://choicenet.ne.jp/jp/hosting.html
ネットワークサポート:    http://choicenet.ne.jp/jp/netsupport.html

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkoChxUACgkQpYU8M8PbPV7q3wCeIhIF6ui1OmfGsvZfAeKMdsFK
jWAAni3PTm17PWxEtc3pKp0EsbRXUQac
=k0i7
-----END PGP SIGNATURE-----

Re: [SL] How to account for pre-payments

[Mark P. <mar...@mo...>]

On May 6, 2009, at 8:34 PM, Paul Tammes wrote:

> The only reason I can come up with for NOT sending invoices and yet  
> to ask
> for payment (advance, whatever) is to postpone taxation: once he  
> invoice is
> sent, tax is due. So let us wait as long as possible to send tjhe  
> invoice.
>
> At this point in time, with people and businesses going bankrupt  
> every so
> often, I would be very hesitant to pay with or without an invoice,  
> but not
> having an invoice (or reminder if cash is low) would not prompt me  
> to pay
> anything whatsoever.

Well, that certainly makes sense. In our locale, invoices are not  
taxed when they are created. At least for the moment, we are allowed  
to tally the sum at the end of each quarter or year, then send a tax  
contribution.

I have an associate in Mexico who was very hesitant to send me an  
invoice. Like you, I am hesitant to send money without an invoice or  
similar. His problem was the tax was due at the moment the invoice was  
created. So, my associate would be out of pocket for taxes paid  
whether or not he ever collected on the invoice. It will come as no  
surprise that we made other arrangements so that payment of tax  
demanded coincided with real income.

  -- Mark


Mark Phillips

On the web at www.mophilly.com
On the phone at (619) 444-9210

Re: [SL] How to account for pre-payments

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

I am not against payment of services.
I just suggest the service provider could (and should in my opinion) send an
invoice.

For example, contracters here in Holland start building the house after
receiving payment for the invoiced 20% 'up front' part of the building
contract. Then, after the foundation or some defined part of work is
finished, they invoice the next 10 % and so on, till the house is finished,
all work done is invoiced and off to the next project.

Same for accountants; when they take on a job (say control of anual
accounts), they send an invoice for 20 or 50% at start, rest after the job.

The only reason I can come up with for NOT sending invoices and yet to ask
for payment (advance, whatever) is to postpone taxation: once he invoice is
sent, tax is due. So let us wait as long as possible to send tjhe invoice.

At this point in time, with people and businesses going bankrupt every so
often, I would be very hesitant to pay with or without an invoice, but not
having an invoice (or reminder if cash is low) would not prompt me to pay
anything whatsoever.

2009/5/7 Mark Phillips <mar...@mo...>

>
> On May 6, 2009, at 10:31 AM, Paul Tammes wrote:
> > Why prepay at all? Especially an accountant should see the logic
> > that one
> > has to send an invoice in order to get paid.
>
> I respectfully disagree. It is quite common for many businesses to
> require a retainer or "advance billing deposit". Some will not begin a
> project until funds sufficient to cover the anticipated work are
> deposited, even as much as 100% of the anticipated billing. Some of
> these will produce an invoice based on an estimate or contract, then
> amend if required.
>
> Others do not invoice until the end of a project. In the meantime, the
> estimate serves as the controlling document, with funds advanced and
> charges tracked against the estimate. At the time of invoice, the
> charges and payments are tallied and posted so they appear on the
> invoice and are "booked" in accordance with the accounting policies of
> the client.
>
> FWIW, I have no idea how this fits into SL, so my comments are more
> general in nature. That said, I have created such processes in the
> software applications we maintain and develop for clients. As another
> poster wrote, the point is to make sure the value of the service or
> product is compensated, or more plainly, to make sure you get paid.
>
>
> Mark Phillips
>
> -------------- next part --------------
>
>
> On the web at www.mophilly.com
> On the phone at (619) 444-9210
>
>
>
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] How to account for pre-payments

[Mark P. <mar...@mo...>]

On May 6, 2009, at 10:31 AM, Paul Tammes wrote:
> Why prepay at all? Especially an accountant should see the logic  
> that one
> has to send an invoice in order to get paid.

I respectfully disagree. It is quite common for many businesses to  
require a retainer or "advance billing deposit". Some will not begin a  
project until funds sufficient to cover the anticipated work are  
deposited, even as much as 100% of the anticipated billing. Some of  
these will produce an invoice based on an estimate or contract, then  
amend if required.

Others do not invoice until the end of a project. In the meantime, the  
estimate serves as the controlling document, with funds advanced and  
charges tracked against the estimate. At the time of invoice, the  
charges and payments are tallied and posted so they appear on the  
invoice and are "booked" in accordance with the accounting policies of  
the client.

FWIW, I have no idea how this fits into SL, so my comments are more  
general in nature. That said, I have created such processes in the  
software applications we maintain and develop for clients. As another  
poster wrote, the point is to make sure the value of the service or  
product is compensated, or more plainly, to make sure you get paid.


Mark Phillips

-------------- next part --------------


On the web at www.mophilly.com
On the phone at (619) 444-9210

Re: [SL] How to account for pre-payments

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

Some places give discounts for prepayment, (e.g. prepaid blocks of  
time for service).  If regular customer has a return they may just  
ask for credit rather than cash back.  It could be a year-end rebate  
based on volume of business, a coupon, even just a discount after the  
sale.  Probably many more, this is just off the top of my head...


Thanks,

Michael


On May 6, 2009, at 10:31 AM, Paul Tammes wrote:

Why prepay at all? Especially an accountant should see the logic that  
one
has to send an invoice in order to get paid.

Just my two cents..

2009/5/5 Michael Hasse <mh...@it...>

> Good question!
>    And if you search the archives you'll see that while there are
> several ways to handle it there are no "best" or "right" ways to do  
> it.
>    Or, to put it more plainly, SL does not really have a "credit"
> account per customer out of the box.  You can do it yourself, (a
> laborious process if you already have a lot of customers in the
> system).  Or you can do an equally laborious negative invoice and
> deletion as you've already described.
>    There are some other possible ways but they all pretty much come
> down to the same thing - SL doesn't have a good credit tracking
> mechanism.  (Actually, I should say the tracking is fine, it's the
> application of the credit that's awkward).
>
>
> Thanks,
>
> Michael
>
> On May 5, 2009, at 2:08 PM, Kevin Bailey wrote:
>
> Hi,
>
> What is a good way to handle pre-payments?  I.e. we make payments  
> to our
> accountant to pre-pay towards an invoice which is then raised at  
> the end
> of the year.
>
> Currently, I assign them to a suspense account - and then reallocate
> them.  But this is a bit of a pain as I have to delete these
> transactions later, add as a receipt and then reconsolidate the bank
> statements.
>
>
> I suppose I could prepay to a debtors account - but how would I  
> remember
> to pay this against the outstanding to stop our bookkeeper from paying
> the invoice twice!
>
> Cheers,
>
> Kevin
>
> ---------------------------------------------------------------------- 
> --
> ------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances!  
> Your
> production scanning environment may not be a perfect world - but
> thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW
> KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> ---------------------------------------------------------------------- 
> --------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances!  
> Your
> production scanning environment may not be a perfect world - but  
> thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW  
> KODAK
> i700
> Series Scanner you'll get full speed at 300 dpi even with all image
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
------------------------------------------------------------------------ 
------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but  
thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW  
KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] How to account for pre-payments

[William M. <wi...@kn...>]

On Wed, 2009-05-06 at 19:31 +0200, Paul Tammes wrote:
> 
> Why prepay at all? Especially an accountant should see the logic that
>  one has to send an invoice in order to get paid.

For service delivery, pre-payment is a great way not to get left holding
the bill after delivering the work. 

We create an invoice with just the payment which is used for tracking
the credit. Then as work is invoiced, we use apply a negative amount to
this tracking invoice (I think this is handled via the Cash Payments
screen but I don't have to do the book-keeping anymore these days :).


HTH,
William

-- 
Knowmad Technologies - Open Source Web Solutions
W: http://www.knowmad.com | E: wi...@kn... | P: 704.343.9330