In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Advanced Details Jump to Notes ] Wiki ] View Simple ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0001033 [In-Portal CMS] Data Management feature request always 2011-04-03 19:26 2012-07-25 05:32
Reporter Dmitry View Status public Project Name In-Commerce
Assigned To alex Developer
Priority normal Resolution fixed Platform
Status closed   OS
  OS Version
ETA none Fixed in Version 5.2.0-B1 Product Version 5.1.2
  Target Version 5.2.0 Product Build
Time EstimateNo estimate
Summary 0001033: VAT Calculation and Invoicing
Description 1. Create a new In-Commerce Configuration setting, ie. VATIncluded.

2. Add a new VATIncluded field that will be applied to the Orders table in addition to currently existing - VAT (amount) and VATPercent fields.

3. Based on the Config. setting apply new field to the Order Calculations and Invoicing when the order is place on the Front-end. Show it check-box on "Bill To" step in the Admin and allow changing it.

New field will store the setting for that Order when VAT was Included or Excluded based on described by options below:




Examples how this will be applied:
=============
- when prices are displayed without VAT, and user want to have a real
invoice, we configure VAT (19.6% in my example, actual french rate),
the result is like this:

Sub-total : 100 $ exc.vat
Shipping : 10 $ exc. vat

VAT 19.6% : 21,56 $ ## if vat apply to shipping, otherwise VAT
would be 19,60 $

Grand Total : 131,56 $ inc.vat

- when prices are displayed with VAT, and user want to have a real
invoice :

Sub-total : 100 $ inc.vat
Shipping : 10 $ inc. vat

VAT 19.6% : 18,03 $ ## Deducted From total price 110 $ if vat apply
to shipping -- otherwise VAT is deducted from 100 $ only, VAT total
would be 16.38 $

Grand Total : 110,00 $ inc.vat
Steps To Reproduce
Additional Information
Tags No tags attached.
Reference https://groups.google.com/d/topic/in-portal-dev/YLA0A96ZgyM/discussion
Change Log Message Ability to include/exclude VAT
Estimate Points 3
Attached Files patch file icon vat_calculation_1033.patch [^] (12,490 bytes) 2011-12-16 09:30 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0004269)
erik (manager)
2011-12-16 09:30

Patch attached - needs testing
User avatar (0004275)
alex (manager)
2011-12-19 05:24

Will test all together later.
User avatar (0004276)
alex (manager)
2011-12-19 05:26

Fix committed to 5.2.x branch. Commit Message:

Fixes 0001033: VAT Calculation and Invoicing
Commit on behalf of Erik
User avatar (0004277)
alex (manager)
2011-12-19 05:27

Reminder sent to: Dmitry

Works, but I've noticed some issues with current tax processing:

1. when tax is included in product price, then it also always must be included in shipping cost & processing free

2. insurance fee isn't taxable, when shipping (associated with given insurance fee) is taxable
User avatar (0005023)
alex (manager)
2012-07-25 05:32

Since 5.2.0 version was released.

- Related Changesets
Modules :: In-Commerce: 5.2.x r14884
Timestamp: 2011-12-19 05:26:05
Author: alex
Details ] Diff ]
Fixes 0001033: VAT Calculation and Invoicing
Commit on behalf of Erik
mod - /w/in-commerce/branches/5.2.x/admin_templates/orders/orders_edit_billing.tpl Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/install/english.lang Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/install/install_data.sql Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/install/install_schema.sql Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/install/upgrades.sql Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/orders/orders_config.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/orders/orders_event_handler.php Diff ] File ]
mod - /w/in-commerce/branches/5.2.x/units/orders/orders_item.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2012-07-25 05:32 alex Note Added: 0005023
2012-07-25 05:32 alex Status resolved => closed
2011-12-19 05:27 alex Note Added: 0004277
2011-12-19 05:26 alex Note Added: 0004276
2011-12-19 05:26 alex Status reviewed and tested => resolved
2011-12-19 05:26 alex Fixed in Version => 5.2.0-B1
2011-12-19 05:26 alex Resolution open => fixed
2011-12-19 05:26 alex Changeset attached 5.2.x r14884
2011-12-19 05:24 alex Note Added: 0004275
2011-12-19 05:24 alex Status needs testing => reviewed and tested
2011-12-16 09:30 erik Time Estimate Removed 3 =>
2011-12-16 09:30 erik Note Added: 0004269
2011-12-16 09:30 erik Assigned To erik => alex
2011-12-16 09:30 erik Developer => erik
2011-12-16 09:30 erik Status needs work => needs testing
2011-12-16 09:30 erik File Added: vat_calculation_1033.patch
2011-12-15 18:00 Dmitry Assigned To Dmitry => erik
2011-10-22 05:38 alex Estimate Points => 3
2011-09-27 05:02 alex Time Estimate Added 3
2011-09-24 11:44 Dmitry Assigned To => Dmitry
2011-09-24 11:44 Dmitry Status active => needs work
2011-09-24 11:44 Dmitry Target Version Icebox => 5.2.0
2011-04-03 19:26 Dmitry New Issue
2011-04-03 19:26 Dmitry Reference => https://groups.google.com/d/topic/in-portal-dev/YLA0A96ZgyM/discussion
2011-04-03 19:26 Dmitry Change Log Message => Ability to include/exclude VAT



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker