sql-ledger-users — SQL-Ledger users

Re: [SL] Gift Vouchers

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

On Mon, 23 Apr 2007, Paul Tammes wrote:
> So I see no reason for charging VAT. That would be just as foolish as
> charging VAT when I change my tenner in loose change for the vending
> machine. The VAT transaction is the vending machine, and there the sale
> is VAT included.

I think you'll find that reason has no part to play in applying tax rulings, 
and nobody wins an argument with the tax-man :-) But your argument is sound 
and basically explains why the ruling is as it is (furthermore in Oz 
financial services are (generally speaking) not taxed with the GST, and one 
could argue that a voucher is a financial service since it is really an offer 
of credit).

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

Re: [SL] Gift Vouchers

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

Ashley J Gittins wrote:
> On Mon, 23 Apr 2007, George Osvald wrote:
>   
> The actual ruling on vouchers is here if you need more detailed information:
> http://law.ato.gov.au/atolaw/view.htm?locid='DGS/GST2000D22/NAT/ATO/fpF4'&PiT=99991231235958
>
>   
Apart from legal and accounting issues, I suppose it is safe to say that 
a gift-voucher is (for the customer) as good as cash as for payment 
purposes. Only cash can be spent anywhere, where the gift-voucher is on 
a per ship or per sales-chain basis.
Why anybody would want to limit the choices of the friend receiving the 
gift is beyond me. Rational would be to give cash.

That being said, we humans are social and not rational beings, so 
exchanging a 50 dollar bill for a 50 dollar gift certificate does happen 
in the real world. Economically speaking (GST or VAT) there is NO value 
added in the transaction as I see it.
So I see no reason for charging VAT. That would be just as foolish as 
charging VAT when I change my tenner in loose change for the vending 
machine. The VAT transaction is the vending machine, and there the sale 
is VAT included.

Hopes this clarifies matters.
Paul

Re: [SL] Gift Vouchers

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

On Mon, 23 Apr 2007, George Osvald wrote:
> By law I have to charge GST on all services I provide/sell. With every
> service above $50 I also have to provide tax invoice that states amount of
> GST charged. I can not create service and uncheck taxes. Only ways I can
> see at the moment are really orders or some kind of pre-payments into
> existing accounts. Making a GL transaction at the time of purchase would be
> too complicated.

Hi George,
	As I understand it the ATO requires that you do not account for (charge) GST 
on vouchers (per the link someone provided earlier, they are not to be 
accounted for in your acticity statement).

You only apply a GST component to the actual supply made when the customer 
redeems the voucher. IE, the voucher "sale" should not have any gst on it. 
The sale where they get product/service and pay for it using the voucher 
should include gst - where applicable.

The way I see it, this means that making the voucher a gst-free product makes 
sense, that way the gst is not accounted for at time of voucher sale, but 
processing works normally when the voucher is redeemed, by charging gst on 
the products and services per normal.

Standard disclaimers apply, IANACPA, see your accountant, etc etc :-)

The actual ruling on vouchers is here if you need more detailed information:
http://law.ato.gov.au/atolaw/view.htm?locid='DGS/GST2000D22/NAT/ATO/fpF4'&PiT=99991231235958

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

Re: [SL] Gift Vouchers

[George O. <geo...@ya...>]

On Friday 20 April 2007, Tony Fraser wrote:
> On Fri, 2007-04-20 at 10:30 +1000, George Osvald wrote:
> > On Friday 20 April 2007, Roy Nicholl wrote:
> > > I agree that there is no 'sale' until a voucher is redeemed (which,
> > > from a business standpoint is hopefully never).  However, vouchers,
> > > coupons, options, etc. are liabilities against the business (this is
> > > why they usually come with expiration dates) and should be recorded
> > > as such.
> >
> > So could they be treated as orders then? When a customer purchases a
> > product and redeems a voucher I could make an invoice out of the order. I
> > could also use the order number to track them. It would not be too hard
> > to customize the order template to print different heading for gift
> > voucher receipts.
>
> Here's what I would do:
>
> Create a liability account in you CoA "Outstanding Vouchers" and mark it
> AR_paid and IC_income.
>
> Create a service called "voucher" with the sell price set to te face
> value of the voucher and income account set to "Outstanding
> Vouchers" (the IC_income link should make it show up in the list of
> "Income" accounts even though it is actually a liability account.) and
> uncheck any sales taxes.
>
> If a customer buys a voucher make a sales invoice for a voucher and
> accept payment however you want.

By law I have to charge GST on all services I provide/sell. With every service 
above $50 I also have to provide tax invoice that states amount of GST 
charged. I can not create service and uncheck taxes. Only ways I can see at 
the moment are really orders or some kind of pre-payments into existing 
accounts. Making a GL transaction at the time of purchase would be too 
complicated.


> If you give away a/some voucher(s) make a sales invoice and pay it from
> either an equity account or an expense account like "Promotions
> Expense". This is definitely a question for your accountant to answer.
>
> When a customer redeems a voucher you will be able to accept it as
> payment of a regular sales invoice by choosing the "Outstanding
> Vouchers" account as the payment account. It will be in the list because
> of the AR_paid link.
>
> If you want to know the amount of vouchers you have outstanding you just
> have to look at the balance of the "Outstanding Vouchers" account.
>
> If your vouchers have an expiry once they are expired you can either
> debit "Outstanding Vouchers" and credit "Unused Voucher
> Income" (vouchers that were bought but not used) or debit "Outstanding
> Vouchers" and credit "Promotions Expense" (giveaways).



-- 
George
AUSTRALIA
http://www.okstudio.com.au

Re: [SL] Gift Vouchers

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

On Fri, 2007-04-20 at 10:30 +1000, George Osvald wrote:
> On Friday 20 April 2007, Roy Nicholl wrote:
> > I agree that there is no 'sale' until a voucher is redeemed (which,
> > from a business standpoint is hopefully never).  However, vouchers,
> > coupons, options, etc. are liabilities against the business (this is
> > why they usually come with expiration dates) and should be recorded
> > as such.
> 
> So could they be treated as orders then? When a customer purchases a product 
> and redeems a voucher I could make an invoice out of the order. I could also 
> use the order number to track them. It would not be too hard to customize the 
> order template to print different heading for gift voucher receipts.

Here's what I would do:

Create a liability account in you CoA "Outstanding Vouchers" and mark it
AR_paid and IC_income.

Create a service called "voucher" with the sell price set to te face
value of the voucher and income account set to "Outstanding
Vouchers" (the IC_income link should make it show up in the list of
"Income" accounts even though it is actually a liability account.) and
uncheck any sales taxes.

If a customer buys a voucher make a sales invoice for a voucher and
accept payment however you want.

If you give away a/some voucher(s) make a sales invoice and pay it from
either an equity account or an expense account like "Promotions
Expense". This is definitely a question for your accountant to answer.

When a customer redeems a voucher you will be able to accept it as
payment of a regular sales invoice by choosing the "Outstanding
Vouchers" account as the payment account. It will be in the list because
of the AR_paid link.

If you want to know the amount of vouchers you have outstanding you just
have to look at the balance of the "Outstanding Vouchers" account.

If your vouchers have an expiry once they are expired you can either
debit "Outstanding Vouchers" and credit "Unused Voucher
Income" (vouchers that were bought but not used) or debit "Outstanding
Vouchers" and credit "Promotions Expense" (giveaways).

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

Re: [SL] Gift Vouchers

[George O. <geo...@ya...>]

On Friday 20 April 2007, Roy Nicholl wrote:
> I agree that there is no 'sale' until a voucher is redeemed (which,
> from a business standpoint is hopefully never).  However, vouchers,
> coupons, options, etc. are liabilities against the business (this is
> why they usually come with expiration dates) and should be recorded
> as such.

So could they be treated as orders then? When a customer purchases a product 
and redeems a voucher I could make an invoice out of the order. I could also 
use the order number to track them. It would not be too hard to customize the 
order template to print different heading for gift voucher receipts.


> Roy
>
> On 19-Apr-2007, at 00:30, David J wrote:
> > George
> > You may care to check this ATO document.
> > http://www.ato.gov.au/businesses/content.asp?doc=/content/42952.htm
> > (Sorry I can't hyperlink from this webmail.  Pls cut 'n
> > paste.)
> > Perhaps you don't "sell" vouchers, but rather "issue" them.
> > Perhaps the issue of a voucher should NOT be invoiced at
> > all.
> > Invoice only when voucher redeemed.
> > A voucher is a lot like a promissory note or an IOU, rather
> > than a sale.
> > So the outstanding vouchers are like mini-loans from your
> > customers.
> > GST only when voucher redeemed for goods/services.
> > YMMV in accordance with local conditions.
> > As always, check with your accountant.
> > - David J
> >
> >> On Thursday 19 April 2007, la...@cl... wrote:
> >>> 1. create gift voucher in part.
> >>> 2. create sales invoice to sell a gift voucher to john
> >>> smith (money to your bank).
> >>> 3. create an negative ar transaction (money to your
> >>> credit note or gift voucher account) for john smith.
> >>
> >> What would you do with taxes here?
> >>
> >>> 4. john smith's account should now reflect that he has a
> >>
> >> credit. >
> >>
> >>> the credit note or gift voucher account should help you
> >>> track your gift vouchers.
> >>>
> >>> would this do it?
> >>>
> >>>> Anybody out there selling gift vouchers? If so how do
> >>>> you do it? How do you
> >>>> track them?
> >>>>
> >>>>
> >>>> --
> >>>> George
> >>>> AUSTRALIA
> >>>> http://www.okstudio.com.au
> >>
> >> ----------------------------------------------------------
> >>
> >>>> --------------- This SF.net email is sponsored by DB2
> >>>> Express Download DB2 Express C - the FREE version of
> >>>> DB2 express and take control of your XML. No limits.
> >>>> Just data. Click to get it now.
> >>>> http://sourceforge.net/powerbar/db2/
> >>>> _______________________________________________
> >>>> sql-ledger-users mailing list
> >>>> sql...@li...
> >
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >> ----------------------------------------------------------
> >>
> >>> --------------- This SF.net email is sponsored by DB2
> >>> Express Download DB2 Express C - the FREE version of DB2
> >>> express and take control of your XML. No limits. Just
> >>> data. Click to get it now.
> >>> http://sourceforge.net/powerbar/db2/
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >> --
> >> George
> >> AUSTRALIA
> >> http://www.okstudio.com.au
> >>
> >> ----------------------------------------------------------
> >> --------------- This SF.net email is sponsored by DB2
> >> Express Download DB2 Express C - the FREE version of DB2
> >> express and take control of your XML. No limits. Just
> >> data. Click to get it now.
> >> http://sourceforge.net/powerbar/db2/
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ----------------------------------------------------------------------
> > ---
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users



-- 
George
AUSTRALIA
http://www.okstudio.com.au

Re: [SL] Gift Vouchers

[Roy N. <RNi...@NB...>]

Your accountant may very well tell you that you are not "selling" a  
voucher - a sale only takes place when a good or service is  
contracted or delivered to the customer - but actually accepting a  
pre-payment for a good or service to be sold/delivered at some future  
date.   It's a similar situation to when a borrows money or sells  
bonds (save there are no usage (interest) charges).  You have the  
money in your bank account, but the holder of the debt (gift voucher)  
can redeem it at their will (within the terms of the voucher, bond,  
etc.) ... if is for this reason that you need to record it as a  
liability.

Roy

On 19-Apr-2007, at 13:38, la...@cl... wrote:

> So would creating a sales invoice and instead of having it recorded  
> into
> the AR account but having it recorded into a liability g.v. account be
> more appropriate? So the question is really g.v. should be a liability
> account (a question will probably be confirmed by my accountant)?  
> Which
> make more sense anyway...the part "no 'sale' until a voucher is  
> redeemed"
> should all depends on if you are giving away a gift voucher or have  
> sold a
> gift voucher? My client do both of that in her business...Tim
>
>> I agree that there is no 'sale' until a voucher is redeemed (which,
>> from a business standpoint is hopefully never).  However, vouchers,
>> coupons, options, etc. are liabilities against the business (this is
>> why they usually come with expiration dates) and should be recorded
>> as such.
>>
>> Roy
>>
>> On 19-Apr-2007, at 00:30, David J wrote:
>>
>>> George
>>> You may care to check this ATO document.
>>> http://www.ato.gov.au/businesses/content.asp?doc=/content/42952.htm
>>> (Sorry I can't hyperlink from this webmail.  Pls cut 'n
>>> paste.)
>>> Perhaps you don't "sell" vouchers, but rather "issue" them.
>>> Perhaps the issue of a voucher should NOT be invoiced at
>>> all.
>>> Invoice only when voucher redeemed.
>>> A voucher is a lot like a promissory note or an IOU, rather
>>> than a sale.
>>> So the outstanding vouchers are like mini-loans from your
>>> customers.
>>> GST only when voucher redeemed for goods/services.
>>> YMMV in accordance with local conditions.
>>> As always, check with your accountant.
>>> - David J
>>>
>>>
>>>> On Thursday 19 April 2007, la...@cl... wrote:
>>>>> 1. create gift voucher in part.
>>>>> 2. create sales invoice to sell a gift voucher to john
>>>>> smith (money to your bank).
>>>>> 3. create an negative ar transaction (money to your
>>>>> credit note or gift voucher account) for john smith.
>>>>
>>>> What would you do with taxes here?
>>>>
>>>>> 4. john smith's account should now reflect that he has a
>>>> credit. >
>>>>> the credit note or gift voucher account should help you
>>>>> track your gift vouchers.
>>>>>
>>>>> would this do it?
>>>>
>>>>>> Anybody out there selling gift vouchers? If so how do
>>>>>> you do it? How do you
>>>>>> track them?
>>>>>>
>>>>>>
>>>>>> --
>>>>>> George
>>>>>> AUSTRALIA
>>>>>> http://www.okstudio.com.au
>>>
>>>
>>>>>>
>>>>>>
>>>> ----------------------------------------------------------
>>>>>> --------------- This SF.net email is sponsored by DB2
>>>>>> Express Download DB2 Express C - the FREE version of
>>>>>> DB2 express and take control of your XML. No limits.
>>>>>> Just data. Click to get it now.
>>>>>> http://sourceforge.net/powerbar/db2/
>>>>>> _______________________________________________
>>>>>> sql-ledger-users mailing list
>>>>>> sql...@li...
>>>>
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>>
>>>>>
>>>> ----------------------------------------------------------
>>>>> --------------- This SF.net email is sponsored by DB2
>>>>> Express Download DB2 Express C - the FREE version of DB2
>>>>> express and take control of your XML. No limits. Just
>>>>> data. Click to get it now.
>>>>> http://sourceforge.net/powerbar/db2/
>>>>> _______________________________________________
>>>>> sql-ledger-users mailing list
>>>>> sql...@li...
>>>>
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>
>>>>
>>>>
>>>> --
>>>> George
>>>> AUSTRALIA
>>>> http://www.okstudio.com.au
>>>>
>>>> ----------------------------------------------------------
>>>> --------------- This SF.net email is sponsored by DB2
>>>> Express Download DB2 Express C - the FREE version of DB2
>>>> express and take control of your XML. No limits. Just
>>>> data. Click to get it now.
>>>> http://sourceforge.net/powerbar/db2/
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>>>
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>> -------------------------------------------------------------------- 
>>> --
>>> ---
>>> This SF.net email is sponsored by DB2 Express
>>> Download DB2 Express C - the FREE version of DB2 express and take
>>> control of your XML. No limits. Just data. Click to get it now.
>>> http://sourceforge.net/powerbar/db2/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Gift Vouchers

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

So would creating a sales invoice and instead of having it recorded into
the AR account but having it recorded into a liability g.v. account be
more appropriate? So the question is really g.v. should be a liability
account (a question will probably be confirmed by my accountant)? Which
make more sense anyway...the part "no 'sale' until a voucher is redeemed"
should all depends on if you are giving away a gift voucher or have sold a
gift voucher? My client do both of that in her business...Tim

> I agree that there is no 'sale' until a voucher is redeemed (which,
> from a business standpoint is hopefully never).  However, vouchers,
> coupons, options, etc. are liabilities against the business (this is
> why they usually come with expiration dates) and should be recorded
> as such.
>
> Roy
>
> On 19-Apr-2007, at 00:30, David J wrote:
>
>> George
>> You may care to check this ATO document.
>> http://www.ato.gov.au/businesses/content.asp?doc=/content/42952.htm
>> (Sorry I can't hyperlink from this webmail.  Pls cut 'n
>> paste.)
>> Perhaps you don't "sell" vouchers, but rather "issue" them.
>> Perhaps the issue of a voucher should NOT be invoiced at
>> all.
>> Invoice only when voucher redeemed.
>> A voucher is a lot like a promissory note or an IOU, rather
>> than a sale.
>> So the outstanding vouchers are like mini-loans from your
>> customers.
>> GST only when voucher redeemed for goods/services.
>> YMMV in accordance with local conditions.
>> As always, check with your accountant.
>> - David J
>>
>>
>>> On Thursday 19 April 2007, la...@cl... wrote:
>>>> 1. create gift voucher in part.
>>>> 2. create sales invoice to sell a gift voucher to john
>>>> smith (money to your bank).
>>>> 3. create an negative ar transaction (money to your
>>>> credit note or gift voucher account) for john smith.
>>>
>>> What would you do with taxes here?
>>>
>>>> 4. john smith's account should now reflect that he has a
>>> credit. >
>>>> the credit note or gift voucher account should help you
>>>> track your gift vouchers.
>>>>
>>>> would this do it?
>>>
>>>>> Anybody out there selling gift vouchers? If so how do
>>>>> you do it? How do you
>>>>> track them?
>>>>>
>>>>>
>>>>> --
>>>>> George
>>>>> AUSTRALIA
>>>>> http://www.okstudio.com.au
>>
>>
>>>>>
>>>>>
>>> ----------------------------------------------------------
>>>>> --------------- This SF.net email is sponsored by DB2
>>>>> Express Download DB2 Express C - the FREE version of
>>>>> DB2 express and take control of your XML. No limits.
>>>>> Just data. Click to get it now.
>>>>> http://sourceforge.net/powerbar/db2/
>>>>> _______________________________________________
>>>>> sql-ledger-users mailing list
>>>>> sql...@li...
>>>
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>
>>>>
>>> ----------------------------------------------------------
>>>> --------------- This SF.net email is sponsored by DB2
>>>> Express Download DB2 Express C - the FREE version of DB2
>>>> express and take control of your XML. No limits. Just
>>>> data. Click to get it now.
>>>> http://sourceforge.net/powerbar/db2/
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>>
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>>
>>> --
>>> George
>>> AUSTRALIA
>>> http://www.okstudio.com.au
>>>
>>> ----------------------------------------------------------
>>> --------------- This SF.net email is sponsored by DB2
>>> Express Download DB2 Express C - the FREE version of DB2
>>> express and take control of your XML. No limits. Just
>>> data. Click to get it now.
>>> http://sourceforge.net/powerbar/db2/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>>
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>> ----------------------------------------------------------------------
>> ---
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Gift Vouchers

[Roy N. <RNi...@NB...>]

I agree that there is no 'sale' until a voucher is redeemed (which,  
from a business standpoint is hopefully never).  However, vouchers,  
coupons, options, etc. are liabilities against the business (this is  
why they usually come with expiration dates) and should be recorded  
as such.

Roy

On 19-Apr-2007, at 00:30, David J wrote:

> George
> You may care to check this ATO document.
> http://www.ato.gov.au/businesses/content.asp?doc=/content/42952.htm
> (Sorry I can't hyperlink from this webmail.  Pls cut 'n
> paste.)
> Perhaps you don't "sell" vouchers, but rather "issue" them.
> Perhaps the issue of a voucher should NOT be invoiced at
> all.
> Invoice only when voucher redeemed.
> A voucher is a lot like a promissory note or an IOU, rather
> than a sale.
> So the outstanding vouchers are like mini-loans from your
> customers.
> GST only when voucher redeemed for goods/services.
> YMMV in accordance with local conditions.
> As always, check with your accountant.
> - David J
>
>
>> On Thursday 19 April 2007, la...@cl... wrote:
>>> 1. create gift voucher in part.
>>> 2. create sales invoice to sell a gift voucher to john
>>> smith (money to your bank).
>>> 3. create an negative ar transaction (money to your
>>> credit note or gift voucher account) for john smith.
>>
>> What would you do with taxes here?
>>
>>> 4. john smith's account should now reflect that he has a
>> credit. >
>>> the credit note or gift voucher account should help you
>>> track your gift vouchers.
>>>
>>> would this do it?
>>
>>>> Anybody out there selling gift vouchers? If so how do
>>>> you do it? How do you
>>>> track them?
>>>>
>>>>
>>>> --
>>>> George
>>>> AUSTRALIA
>>>> http://www.okstudio.com.au
>
>
>>>>
>>>>
>> ----------------------------------------------------------
>>>> --------------- This SF.net email is sponsored by DB2
>>>> Express Download DB2 Express C - the FREE version of
>>>> DB2 express and take control of your XML. No limits.
>>>> Just data. Click to get it now.
>>>> http://sourceforge.net/powerbar/db2/
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>> ----------------------------------------------------------
>>> --------------- This SF.net email is sponsored by DB2
>>> Express Download DB2 Express C - the FREE version of DB2
>>> express and take control of your XML. No limits. Just
>>> data. Click to get it now.
>>> http://sourceforge.net/powerbar/db2/
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>
>> -- 
>> George
>> AUSTRALIA
>> http://www.okstudio.com.au
>>
>> ----------------------------------------------------------
>> --------------- This SF.net email is sponsored by DB2
>> Express Download DB2 Express C - the FREE version of DB2
>> express and take control of your XML. No limits. Just
>> data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>>
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] OSS-ERP acceptance Study

[<sal...@ho...>]

Dear SQL-Ledger user,

We are Salvador Bueno and Dolores Gallego, Assistant Professors in Business 
Administration Department in Pablo de Olavide University at Seville, Spain.  
Our research involves an analysis about Open Source Software-Enterprise 
Resource Planning (OSS-ERP) and its impact at organization. We send you this 
mail to invite your participation in our study.

Specifically, our analysis consists on development a Technological 
Acceptance Model of an OSS-ERP.  We consider you are an OSS-ERP user and we 
appreciate the time necessary for answer our questionnaire. The name of the 
participants in this study will remain anonymous.

I would be most grateful if you participate in this survey. You only have to 
answer the questionnaire in the following URL and answer online. You will 
consider for answer the distribution of OSS-ERP you use.

http://aramis.upo.es/general/centros_depart/departamentos/invest/oss/

Please do not hesitate to contact us if you have any queries regarding this 
study.

Best regards,

Salvador Bueno, Ph D.

_________________________________________________________________
Descubre la descarga digital con MSN Music. Más de un millón de canciones. 
http://music.msn.es/

Re: [SL] Gift Vouchers

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

George
You may care to check this ATO document.
http://www.ato.gov.au/businesses/content.asp?doc=/content/42952.htm
(Sorry I can't hyperlink from this webmail.  Pls cut 'n
paste.)
Perhaps you don't "sell" vouchers, but rather "issue" them.
Perhaps the issue of a voucher should NOT be invoiced at
all.
Invoice only when voucher redeemed.
A voucher is a lot like a promissory note or an IOU, rather
than a sale.
So the outstanding vouchers are like mini-loans from your
customers.
GST only when voucher redeemed for goods/services.
YMMV in accordance with local conditions.
As always, check with your accountant.
- David J


> On Thursday 19 April 2007, la...@cl... wrote:
> > 1. create gift voucher in part.
> > 2. create sales invoice to sell a gift voucher to john
> > smith (money to your bank).
> > 3. create an negative ar transaction (money to your
> > credit note or gift voucher account) for john smith.
> 
> What would you do with taxes here?
> 
> > 4. john smith's account should now reflect that he has a
> credit. >
> > the credit note or gift voucher account should help you
> > track your gift vouchers.
> >
> > would this do it?
> 
> > > Anybody out there selling gift vouchers? If so how do
> > > you do it? How do you
> > > track them?
> > >
> > >
> > > --
> > > George
> > > AUSTRALIA
> > > http://www.okstudio.com.au


> > >
> > >
> ----------------------------------------------------------
> > > --------------- This SF.net email is sponsored by DB2
> > > Express Download DB2 Express C - the FREE version of
> > > DB2 express and take control of your XML. No limits.
> > > Just data. Click to get it now.
> > > http://sourceforge.net/powerbar/db2/
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> ----------------------------------------------------------
> > --------------- This SF.net email is sponsored by DB2
> > Express Download DB2 Express C - the FREE version of DB2
> > express and take control of your XML. No limits. Just
> > data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> 
> -- 
> George
> AUSTRALIA
> http://www.okstudio.com.au
> 
> ----------------------------------------------------------
> --------------- This SF.net email is sponsored by DB2
> Express Download DB2 Express C - the FREE version of DB2
> express and take control of your XML. No limits. Just
> data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
>
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] AR balance sheet vs trial balance vs outstanding

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

On Thu, 19 Apr 2007, David J wrote:

> Thankyou Tom
> Yes I'm guilty (as charged) of using an old (and modified)
> version and not yet upgrading.
> Yes, I've made these suggestions before.  Perhaps others
> have too, which is why its now improved.
> Yes, I tried to check these features on the 2.8.1 DWS demo
> system but the System options are blocked (for good reason).
> Yes, I will upgrade soon, for these features.  (Had
> previously read the changes details, but either missed this
> issue, or it's not listed.)
> Sorry if it sounds like whining.  Intending to be helpful
> and constructive.

Good Luck!! At least now you know things are not as bad as they seem. :-)

Things will get even better once Dieter is able to get the manual
updates done. There are still new features in the 2.8 series I do not
understand.

Regards,

Tom

> David J
>
>> I have not been following this thread but so far it
>> appears that you either do not understand how to use the
>> program or you are using an old version and whining about
>> it. Maybe a combination of both who knows. :-)
>>
>> Regards,
>>
>> Tom
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Gift Vouchers

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

i am not sure if i understood you. do you mean a gift card is taxable? or
the tax you would collect when a gift card is used to make a purchase?

> On Thursday 19 April 2007, la...@cl... wrote:
>> 1. create gift voucher in part.
>> 2. create sales invoice to sell a gift voucher to john smith (money to
>> your bank).
>> 3. create an negative ar transaction (money to your credit note or gift
>> voucher account) for john smith.
>
> What would you do with taxes here?
>
>> 4. john smith's account should now reflect that he has a credit.
>>
>> the credit note or gift voucher account should help you track your gift
>> vouchers.
>>
>> would this do it?
>
>> > Anybody out there selling gift vouchers? If so how do you do it? How
>> do
>> > you
>> > track them?
>> >
>> >
>> > --
>> > George
>> > AUSTRALIA
>> > http://www.okstudio.com.au
>> >
>> > -------------------------------------------------------------------------
>> > This SF.net email is sponsored by DB2 Express
>> > Download DB2 Express C - the FREE version of DB2 express and take
>> > control of your XML. No limits. Just data. Click to get it now.
>> > http://sourceforge.net/powerbar/db2/
>> > _______________________________________________
>> > sql-ledger-users mailing list
>> > sql...@li...
>> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
> --
> George
> AUSTRALIA
> http://www.okstudio.com.au
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] AR balance sheet vs trial balance vs outstanding

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

Thankyou Tom
Yes I'm guilty (as charged) of using an old (and modified)
version and not yet upgrading.
Yes, I've made these suggestions before.  Perhaps others
have too, which is why its now improved.
Yes, I tried to check these features on the 2.8.1 DWS demo
system but the System options are blocked (for good reason).
Yes, I will upgrade soon, for these features.  (Had
previously read the changes details, but either missed this
issue, or it's not listed.)
Sorry if it sounds like whining.  Intending to be helpful
and constructive.
David J
 
> I have not been following this thread but so far it
> appears that you either do not understand how to use the
> program or you are using an old version and whining about
> it. Maybe a combination of both who knows. :-)
> 
> Regards,
>
> Tom

Re: [SL] Gift Vouchers

[George O. <geo...@ya...>]

On Thursday 19 April 2007, la...@cl... wrote:
> 1. create gift voucher in part.
> 2. create sales invoice to sell a gift voucher to john smith (money to
> your bank).
> 3. create an negative ar transaction (money to your credit note or gift
> voucher account) for john smith.

What would you do with taxes here?

> 4. john smith's account should now reflect that he has a credit.
>
> the credit note or gift voucher account should help you track your gift
> vouchers.
>
> would this do it?

> > Anybody out there selling gift vouchers? If so how do you do it? How do
> > you
> > track them?
> >
> >
> > --
> > George
> > AUSTRALIA
> > http://www.okstudio.com.au
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users



-- 
George
AUSTRALIA
http://www.okstudio.com.au

Re: [SL] AR balance sheet vs trial balance vs outstanding

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

On Thu, 19 Apr 2007, David J wrote:

> And what would really improve this Cash v. Accrual matter
> would be to have the ability to setup the default
> [cash|accrual] in the company settings.
> eg System, Defaults.  So that [cash|accrual] doesn't need to
> be reselected each and every time a report is requested.  Or
> worse, forgotten.

You either need to upgrade or understand how to use the program.
2.7.x+ allow you to set the type of accounting your company uses.
This means it is already set when you bring up a function where it
is revelant.

> And while we're discussing company-wide options, the
> "company name" should prolly go there too.  Why does the
> name need to be re-entered for each and every new user ?
> Seems unusual.

I have not been following this thread but so far it appears that you either do
not understand how to use the program or you are using an old version and
whining about it. Maybe a combination of both who knows. :-)

Regards,

Tom

Re: [SL] AR balance sheet vs trial balance vs outstanding

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

And what would really improve this Cash v. Accrual matter
would be to have the ability to setup the default
[cash|accrual] in the company settings.
eg System, Defaults.  So that [cash|accrual] doesn't need to
be reselected each and every time a report is requested.  Or
worse, forgotten.
And while we're discussing company-wide options, the
"company name" should prolly go there too.  Why does the
name need to be re-entered for each and every new user ? 
Seems unusual.
- David J


> Cash vs Accrual can certainly cause some problems,
> especially if   you're cash based, because everything
> defaults to Accrual.
>     That said, one does have the option to choose which
> way to run a   report in virtually every case so unless
> you make a mistake and   choose the wrong one the reports
> should(!) be correct either way.    This may be the heart
> of the problem though, there may be some   reports which
> simply don't pay attention to the setting.
> 
> 
> Thanks,
> 
> Michael
> 
> 
> On Apr 18, 2007, at 5:45 AM, ma...@hu...
> wrote:
> 
> >> Chris Johnson wrote:
> >>> Mark, your clue re receipt and invoice happening in
> different years >>> definitely seemed promising.
> >
> >> To me it seems you use a mixture of cash based
> accounting and accrual >> based accounting?
> >> AR for accruals, cash customers for cash based?
> >
> > This, I believe is the crux of the matter.
> >
> > If you are doing cash-basis accounting, I think you
> > technically   should not
> > be using invoices--you should enter cash receipts when
> > the money   comes in.
> >
> > However, DS has given users like me enough rope, which I
> > have used liberally.  (A situation I prefer.)
> >
> > That being said, I think technically it is possible to
> > create cash-  basis
> > reports that ignore invoices (and their dates) and just
> > use the cash receipt date.
> >
> > But it can convoluted--what cash-basis date would you
> > use for an   invoice
> > line item that is associated with an expense account? 
> > For example,   say
> > you want to book advance payment discounts to a
> > marketing expense   and you
> > put that discount as a seperate line item on an invoice
> > using a   special
> > part number.  You can't use the invoice date, in case
> > the invoice   is never
> > paid.
> >
> > I guess you would book this as cash when the invoice is
> > fully paid.  A partial cash payment would not trigger
> > it.  There are probably other complicating wrinkles I am
> > not considering, like returns, credit   memos,
> > etc, etc.
> >
> > I'm not an accountant, but I've thought about this one a
> > lot.    Improved
> > cash-basis reports was the first item on my wish list. 
> :) >
> > m
> >

Re: [SL] PR, SQL-Ledger in the news

[Corporate U. <und...@gm...>]

On 4/16/07, C. Duncan Hudson <Du...@du...> wrote:
>
> Perhaps not the best PR, but still getting the name out there is always
> good:  http://yro.slashdot.org/article.pl?sid=07/04/15/1759254


Yeah, there has been a lot of news about the whole thing. Here are some of
the URL's I noticed, with a lot of opions flying about:

http://fosswire.com/2007/04/15/sql-ledger-licensing-controversy/

http://www.linuxtoday.com/news_story.php3?ltsn=2007-04-16-012-26-NW-BZ-LL

http://lwn.net/Articles/230828/

http://opensourcesmall.biz/archives/2007/04/when-gpl-software-goes-bad/

http://yro.slashdot.org/article.pl?sid=07/04/15/1759254

http://www.purple.dropbear.id.au/sql-ledger-license-changed-no-longer-gpl-when-gpl-software-goes-bad


It will be interesting to see how this all plays out once the dust settles.


UC.

Re: [SL] Gift Vouchers

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

sol...

i would put a unique identifier (serial no.) on the g.v. and put that in
the note field of the invoice, and when joe smith try to use that g.v.
then i would validates it against the invoice and generate the negative ar
transaction for joe smith. you would probably want to have a g.v. log book
on the side to track what has been redeemed so no one would try to reuse a
g.v.

i hope this helps...tim

> What if the Gift voucher was purchased by John Smith.
> However it was intended for an unknown person.
>
> IE. It was to be used in a raffle or draw.
>
>
>
> On Wed, April 18, 2007 1:33 pm, la...@cl... wrote:
>> 1. create gift voucher in part.
>> 2. create sales invoice to sell a gift voucher to john smith (money to
>> your bank). 3. create an negative ar transaction (money to your credit
>> note
>> or gift voucher account) for john smith. 4. john smith's account should
>> now
>> reflect that he has a credit.
>>
>> the credit note or gift voucher account should help you track your gift
>> vouchers.
>>
>> would this do it?
>>
>>
>>> Anybody out there selling gift vouchers? If so how do you do it? How do
>>>  you track them?
>>>
>>>
>>> --
>>> George
>>> AUSTRALIA
>>> http://www.okstudio.com.au
>>>
>>>
>>> -----------------------------------------------------------------------
>>> --
>>> This SF.net email is sponsored by DB2 Express
>>> Download DB2 Express C - the FREE version of DB2 express and take
>>> control of your XML. No limits. Just data. Click to get it now.
>>> http://sourceforge.net/powerbar/db2/
>>> _______________________________________________
>>> sql-ledger-users mailing list sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>
>>
>>
>> -------------------------------------------------------------------------
>>  This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> !DSPAM:11,46265869115238248347463!
>>
>>
>>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Gift Vouchers

[<lh...@pa...>]

What if the Gift voucher was purchased by John Smith.
However it was intended for an unknown person.

IE. It was to be used in a raffle or draw.



On Wed, April 18, 2007 1:33 pm, la...@cl... wrote:
> 1. create gift voucher in part.
> 2. create sales invoice to sell a gift voucher to john smith (money to
> your bank). 3. create an negative ar transaction (money to your credit note
> or gift voucher account) for john smith. 4. john smith's account should now
> reflect that he has a credit.
>
> the credit note or gift voucher account should help you track your gift
> vouchers.
>
> would this do it?
>
>
>> Anybody out there selling gift vouchers? If so how do you do it? How do
>>  you track them?
>>
>>
>> --
>> George
>> AUSTRALIA
>> http://www.okstudio.com.au
>>
>>
>> -----------------------------------------------------------------------
>> --
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> sql-ledger-users mailing list sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>
>
>
> -------------------------------------------------------------------------
>  This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> !DSPAM:11,46265869115238248347463!
>
>
>

Re: [SL] Recover lost dataset password?

[Mark C. <ma...@ju...>]

thanks --- I updated that file and sql-ledger/users/<username>.conf

Dr Eberhard Lisse wrote:
> If I am not mistaken, the root password is encrypted in the
> /srv/www/htdocs/sql-ledger/users/members file, just remove it and log in
> again to create a new one.
>=20
> el
>=20
> on 4/18/07 7:50 AM mxc said the following:
>> Hi there,
>>
>> I cant remember the password to use when setting up a new user with thei=
r
>> relevant dataset. How can I recover this? I know the postgresql admin
>> password and can get into the databases.
>>
>> thanks
>>
>> mark
>>
>=20

Re: [SL] Gift Vouchers

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

1. create gift voucher in part.
2. create sales invoice to sell a gift voucher to john smith (money to
your bank).
3. create an negative ar transaction (money to your credit note or gift
voucher account) for john smith.
4. john smith's account should now reflect that he has a credit.

the credit note or gift voucher account should help you track your gift
vouchers.

would this do it?


> Anybody out there selling gift vouchers? If so how do you do it? How do
> you
> track them?
>
>
> --
> George
> AUSTRALIA
> http://www.okstudio.com.au
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

[SL] Print pricegroup on Latex Template

[Sean K. E. <ske...@gm...>]

How do you print the pricegroup for a particular customer on Latex
Templates?

I have tried <%pricegroup%> on a Pick List to no avail.

Regards,
skebrown

Re: [SL] Recover lost dataset password?

[Dr E. L. <el...@li...>]

If I am not mistaken, the root password is encrypted in the
/srv/www/htdocs/sql-ledger/users/members file, just remove it and log in
again to create a new one.

el

on 4/18/07 7:50 AM mxc said the following:
> Hi there,
> 
> I cant remember the password to use when setting up a new user with their
> relevant dataset. How can I recover this? I know the postgresql admin
> password and can get into the databases.
> 
> thanks
> 
> mark
> 

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] AR balance sheet vs trial balance vs outstanding

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

Cash vs Accrual can certainly cause some problems, especially if  
you're cash based, because everything defaults to Accrual.
    That said, one does have the option to choose which way to run a  
report in virtually every case so unless you make a mistake and  
choose the wrong one the reports should(!) be correct either way.   
This may be the heart of the problem though, there may be some  
reports which simply don't pay attention to the setting.


Thanks,

Michael


On Apr 18, 2007, at 5:45 AM, ma...@hu... wrote:

>> Chris Johnson wrote:
>>> Mark, your clue re receipt and invoice happening in different years
>>> definitely seemed promising.
>
>> To me it seems you use a mixture of cash based accounting and accrual
>> based accounting?
>> AR for accruals, cash customers for cash based?
>
> This, I believe is the crux of the matter.
>
> If you are doing cash-basis accounting, I think you technically  
> should not
> be using invoices--you should enter cash receipts when the money  
> comes in.
>
> However, DS has given users like me enough rope, which I have used
> liberally.  (A situation I prefer.)
>
> That being said, I think technically it is possible to create cash- 
> basis
> reports that ignore invoices (and their dates) and just use the cash
> receipt date.
>
> But it can convoluted--what cash-basis date would you use for an  
> invoice
> line item that is associated with an expense account?  For example,  
> say
> you want to book advance payment discounts to a marketing expense  
> and you
> put that discount as a seperate line item on an invoice using a  
> special
> part number.  You can't use the invoice date, in case the invoice  
> is never
> paid.
>
> I guess you would book this as cash when the invoice is fully paid.  A
> partial cash payment would not trigger it.  There are probably other
> complicating wrinkles I am not considering, like returns, credit  
> memos,
> etc, etc.
>
> I'm not an accountant, but I've thought about this one a lot.   
> Improved
> cash-basis reports was the first item on my wish list.  :)
>
> m
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users