cash discount implementation question

[Korbinian Preisler]

Hello to everybody,

in the last days there was some interest on a cash discount
implementation for tryton on the irc. We have a concept[1] about this on
the wiki of the german community (it is written in English).

There are some questions left. We do not know enough about the handling
of cash discount in other countries. So it would be great if you could
have a look if our concept matches the needs in your country.

A special topic is the handling of the cash discount moves on the tax
codes. For the moment the same tax codes like for the move of the
invoice are used. Do you need to use different tax codes for the cash
discount move in your country?

[1] http://tryton.origo.ethz.ch/wiki/implementierung_skonto

Regards,

--
Korbinian Preisler
____________________________________
virtual things
Preisler & Spallek GbR
Munich - Aix-la-Chapelle

Windeckstr. 77
81375 Munich - Germany
Tel: +49 (89) 710 481 55
Fax: +49 (89) 710 481 56

in...@virtual-things.biz
http://www.virtual-things.biz

[Dieter Van Eessen]

Hello,

Has there been any improvement on how to accomplish discount for cach/direct payment?
The link you provided, appears to be dead. I'm trying to circumvent the problem,
but I'm not sure wether this method is completely legit.
Account codes are for belgium, account names should be universal.

Example bill:
+ I'm buying 2 products from Vendor: 
  - ProductA: 1000 euro, 21% VAT/BTW
  - ProductB: 300 euro, 6% VAT/BTW
  These product are to be sold again (company cost, NOT personal)
+ I can get 2% discount for payment within 7 days (thus also reducing VAT/BTW)
+ In Belgium, I don't have to pay VAT/BTW, EVEN IF I DONT PAY WITHIN 7 DAYS.
   This rule only applies if the % discount  for direct/cash/quick payment is low enough (max 2%)

Thus:
+ Total VAT to pay (always taking in account the 2% discount)
  VAT 21%: Base 980 =>  205,8
  VAT 6%: Base 294 => 17,64

Now after posting the bill, the result on the account tree should be:
604 Costs -> debit: 1000+300 = 1300
411 VAT to get back from government -> debit: 205,8 + 17,64 = 223,44
440 vendors/crediteurs -> credit: 1300 + 223,44 = 1523,44
 
The discount I MAY use is 26 euro, but this information musn't be added when posting the bill

Thus to summarize:
+It basically comes down to reducing the VAT on the bill:
 FROM (without belgian 2% for quick pay rule) 1000*21% + 300*6%
 TO (with belgian 2% for quick pay rule) 0,98*1000*21% +  0,98*300*6%
+ Solving the problem may be done by adding a second tax to the products:
  - ProductA: 1000 euro; tax1: +21%; tax2: -0,02*21%
  - ProductB: 300 euro; tax1: +6%; tax2: -0,02*6%

This could work to post bills (aankoopfacturen), but for invoices (verkoopfacturen) I think
the printed result won't be legit.

Is the above example ok?
Please send feedback. I'm still learning how to to accounting from this open source books
available on www.ciro.be (they have very nice practical exercises with solutions).
I've been trying to do these things with GNUcash, but it's quite hard to solve this problem in that program.

kind regards,
Dieter

[Cédric Krier]

It seems it depends if the discount is with or without condition.
So I think any implemetation should be able to manage both cases.

> + Solving the problem may be done by adding a second tax to the products:
> - ProductA: 1000 euro; tax1: +21%; tax2: -0,02*21%
> - ProductB: 300 euro; tax1: +6%; tax2: -0,02*6%

I don't think it is the right path to follow because it will lead to
multiplication of taxes.
Indeed it is the base amount of the computation of the tax that must be
adapated in case of discount. It should probably not difficult to adapt
Tryton to allow an easy customisation of the base amount.

> This could work to post bills (aankoopfacturen), but for invoices
> (verkoopfacturen) I think
> the printed result won't be legit.
>
> Is the above example ok?

I think this part is quite clear but the tricky one is how to manage it
when receive the paiment. Because you have to compute the discount and
make the right move to reconcile.

PS: Please don't top-post on this mailing list, see
http://groups.tryton.org/netiquette
--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Jan Grasnick | Grasbauer UG]

Am 13.09.2014 10:39, schrieb Dieter Van Eessen:

Is the above example ok?
Please send feedback. I'm still learning how to to accounting from this open source books
available on www.ciro.be (they have very nice practical exercises with solutions).
I've been trying to do these things with GNUcash, but it's quite hard to solve this problem in that program.

kind regards,
Dieter

On Thursday, November 11, 2010 9:53:42 PM UTC+1, Timitos wrote:

Hello to everybody,

[1] http://tryton.origo.ethz.ch/wiki/implementierung_skonto

Regards,

Hi Timitos,

this is a rewrite of your original module (not finished yet)

http://review.gewinnmonitor.de/account_invoice_cash_discount

possibly you can discuss the needs on this implementation .....

Jan

[Ossi Viljakainen]

On Tuesday, September 16, 2014 at 4:33:28 PM UTC+5:30, Jan Grasnick wrote:

Hi Timitos,

this is a rewrite of your original module (not finished yet)
http://review.gewinnmonitor.de/account_invoice_cash_discount
possibly you can discuss the needs on this implementation .....
Jan

Hi Jan,

We would need exactly something like this. Are you using this module? What is your experience with it? I will get it installed and start testing soon.

-Ossi

[Korbinian Preisler]

Hi Ossi,

thx to the work of Jan and Axel we updated to module to 3.4 now. We also added a first small test szenario and fixed some issues.
You can find it here[1]. We will use the module for a new project on 3.4 and have the module running on some older versions. I think there is still place for improvements. Patches are always welcome.

With regards

Korbinian

[1] https://bitbucket.org/virtualthings/account_invoice_cash_discount/

[Jan Grasnick]

Hi Ossi,

there is a new release form virtual things - take a look at:

https://bitbucket.org/virtualthings/account_invoice_cash_discount

we will stop our fork and go with this

Jan